ADBMS MCQs

1) Data models that preceded the relational model include the hierarchical and ___________ models
A) relational    B) network    C) database    D) None of the above
Correct Ans: network

2) In ______________ Multiple tables that represent the parent class and each child class
A) Generalization    B) Polymorphism     C) Inheritance     D) Specialization
Correct Ans:Inheritance

3) In _____________, users are permitted to create new data types of their own on their interest.
A) DBMS    B) RDBMS    C) ORDBMS    D) All of the above
Correct Ans: ORDBMS

4) A means of identifying sub-groups within an entity set which have attributes that are not shared by all the entities (top-down).
A) Specialization    B) Generalization    C) Both A & B    D) None of these
Correct Ans: Specialization

5) ORDBMS is the data model in which data is stored in form of _____________.
A) entity    B) Class    C) tree    D) objects
Correct Ans: Objects

6) ______________________ Allows more intuitive modeling for applications with complex data.
A) Motivation    B) Nested relations    C) Data Models.    D) Decomposition
Correct Ans: Motivation

7) A _______________ is a database that can do multiple tasks in parallel.
A) Distributed database    B) Parellel Database    C) Linear Database    D) None of these
Correct Ans: Parellel Database

8) The basic problem of a ____________ algorithm is to find, for each distinct value of the join attribute.
A) Sorting    B) Join    C) Sort-Merge    D) None of these
Correct Ans: Join

9) _______________ is the process of storing separate copies of the database at two or more sites.
A)Data fragmentation     B) Distributed Database    C) Data replication    D) None of these
Correct Ans: Data replication

10) _______________ layer has all the data or we can say it is our main device or server which has all information.
A) Application server B) Web server    C) Database server    D) All of these
Correct Ans: Database server

11) The data stored in the database can be queried using ______________.
A) XML        B) XQuery       C) table        D) records
Correct Ans: XQuery

12) The _________________model is a database model where there is no separation between the data and the schema.
A) Semi-structured   B) Structured    C) both A & B    D) None of these
Correct Ans: Semi-structured

13) An _________________ is a database that includes an event-driven architecture.
A) Active database    B) temporal database    C) spatial database    D) deductive databases
Correct Ans: Active database

14) Most ________________ allow the representation of simple geometric objects such as points, lines and polygons.
A) Active database    B) temporal database    C) spatial database    D) deductive databases
Correct Ans: spatial database

15) ______________ is a step wise process that can be used at the physical level of the file system.
A) Query processing    B) Mobile Database    C) Query optimization D) None of these
Correct Ans: Query processing

16) The data in a database can be accessed from anywhere using a _____________.
A) Active database    B) temporal database    C) spatial database    D) Mobile databases
Correct Ans: Mobile databases

17) If the index is created on the basis of the primary key of the table, then it is known as primary indexing.
A) Primary Index    B) Dense Index    C) Clustering Index    D) Secondary Index
Correct Ans: Primary Index

18) __________________makes searching faster.
A) Secondary index    B) Clustering Index    C) Dense Index    D) Sparse Index
Correct Ans: Dense Index