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