Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Identify the criteria for designing database from the point of view of user
a. No redundancy
b. No inapplicable attributes
c. Uniformity in naming & definitions of the data items
d. All of the above
Q. The ............ operator preserves unmatched rows of the relations being joined.
a. Inner join
b. Outer join
c. Union
d. Union join
Q. Which are the not user in End-user:
a. Naïve users
b. Casual users
c. Sophisticated user
d. All of these
Q. DBMS is a collection of ………….. that enables user to create and maintain a database.
a. Keys
b. Translators
c. Programs
d. Language Activity
Q. In a relational schema, each tuple is divided into fields called
a. Relations
b. Domains
c. Queries
d. All of the above
Q. In an ER model, ……………. is described in the database by storing its data.
a. Entity
b. Attribute
c. Relationship
d. Notation
Q. DFD stands for
a. Data Flow Document
b. Data File Diagram
c. Data Flow Diagram
d. Non of the above
Q. A top-to-bottom relationship among the items in a database is established by a
a. Hierarchical schema
b. Network schema
c. Relational Schema
d. All of the above
Q. ……………… table store information about database or about the system.
a. SQL
b. Nested
c. System
d. None of these
Q. …………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
a. Instance
b. Schema
c. Program
d. Super Key
Q. ……………… clause is an additional filter that is applied to the result.
a. Select
b. Group-by
c. Having
d. Order by
Q. A logical schema
a. is the entire database
b. is a standard way of organizing information into accessible parts.
c. describes how data is actually stored on disk.
d. All of the above
Q. ………………… is a full form of SQL.
a. Standard query language
b. Sequential query language
c. Structured query language
d. Server side query language
Q. The candidate key is that you choose to identify each row uniquely is called ……………..
a. Alternate Key
b. Primary Key
c. Foreign Key
d. None of the above
Q. …………….. is used to determine whether of a table contains duplicate rows.
a. Unique predicate
b. Like Predicate
c. Null predicate
d. In predicate