Relational Database Management System Mcqs

Page No. 31

What is a multitable clustering file organization?


aIt stores related records of two or more relations in each block


bIt stores related data about the relations in each block


c It links each and every block by introducing an external attribute


dNone of the mentioned



Data dictionary is also called as ________


aData log


bSystem log


cSystem catalog


dSystem database log


View Answer System catalog

Metadata about the relations are stored in ________


aFile header


b Data dictionary


cData query


dData analyser


View Answer Data dictionary

What is a search key in sequential file organization?


aA number assigned to each record


bNecessarily the primary key


c Any attribute or a set of attributes


dNone of the mentioned



What is hashing file organization?


aAny record can be placed wherever there is a space for the record


bRecords are stored in a sequential order according to a search key


c A hash function is computed on some attribute and that decides the block


dNone of the mentioned



What is sequential file organization?


aAny record can be placed wherever there is a space for the record


bRecords are stored in a sequential order according to a search key


cA hash function is computed on some attribute and that decides the block


dNone of the mentioned



What is heap file organization?


a Any record can be placed wherever there is a space for the record


b Records are stored in a sequential order according to a search key


cA hash function is computed on some attribute and that decides the block


dNone of the mentioned



A search key containing more than one attribute is called a _________ search key


a Multiple


b Multilevel


c Composite


dPrimary


View Answer Multilevel

Indices with two or more levels are called as?


aMultiple Indices


bMultilevel indices


cBi- tri- Indices


dNone of the mentioned


View Answer Multilevel indices

If an index entry appears for only some of the search key values in the file, it is called as ________


aDense key


bDense index


cSparse key


dSparse index


View Answer Sparse index

Goto Page No.

Page 31 of 54

Alphabetical MCQs Categories

Here below You find all kind of categories of MCQs in alphabetical order.


"Comprehensive Collection of MCQs: Alphabetically Organized by Subject"

"Discover an extensive collection of multiple-choice questions (MCQs) neatly categorized by subject from A to Z. This resource is designed for anyone eager to explore various topics in a straightforward and organized manner. Whether you're a student preparing for exams, an educator seeking supplementary materials, or simply curious about different subjects, this compilation offers a convenient way to learn and assess your knowledge. With questions arranged alphabetically, navigation is effortless, allowing you to delve into subjects of interest at your own pace. Engage, learn, and expand your understanding with this accessible and comprehensive repository of MCQs!"


BolPakistan

bolpakistan.com.pk includes Job Mcqs and Pak Mcqs is the Top Largest Mcqs Forum in World, in which you can read Mcqs of All Subjects, PPSC test preparation, FPSC, NTS and PPSC PAST PAPERS, PPSC PAST MCQS. A Collection of Repeated MCQs for JOBs seekers.

Copyright © 2024, Designed & Developed by BolPakistan