Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Relational calculus is a
a. Procedural language.
b. Non- Procedural language.
c. Data definition language.
d. High level language
Q. In a relational database a referential integrity constraint can be specified with the helpof
a. primary key
b. foreign key
c. secondary key
d. none of the above
Q. A super key is a set of one or more attributes that, taken collectively, allow us
a. to identify uniquely an entity in the entity set
b. to make the key most powerful for faster retrieval
c. to increase effectiveness of database access
d. none of the above
Q. 4NF is designed to cope with:
a. Transitive dependency
b. Join dependency
c. Multi valued dependency
d. None of these
Q. A relational database developer refers to a record as
a. a criteri
b. a relation.
c. a tuple.
d. an attribute.
Q. The relational model feature is that there
a. is no need for primary key dat
b. is much more data independence than some other database models.
c. are explicit relationships among records.
d. are tables with many dimensions.
Q. SET concept is used in :
a. Network Model
b. Hierarchical Model
c. Relational Model
d. None of these
Q. Relational Algebra is
a. Data Definition Language .
b. Meta Language
c. Procedural query Language
d. None of the above
Q. What is ACID properties of Transactions?
a. atomicity, consistency, isolation, database
b. atomicity, consistency, isolation, durability
c. atomicity, consistency, inconsistent, durability
d. automatically, concurrency, isolation, durability
Q. If every non-key attribute is functionally dependent on the primary key, the relation will be in
a. first normal form
b. second normal form
c. third normal form
d. fourth formal form
Q. Database locking concept is used to solve the problem of
a. lost update
b. uncommitted dependency
c. inconsistent data
d. all of the above
Q. UML is stands for
a. universal modeling language
b. unified modeling language
c. united modeling language
d. uni modeling language
Q. Data Manipulation Language (DML) is not to
a. create information table in the database
b. insertion of new information into the database
c. deletion of information in the database
d. modification of information in the database
Q. Which of the following in true regarding Referential Integrity?
a. every primary-key value must match a primary-key value in an associated table
b. every primary-key value must match a foreign-key value in an associated table
c. every foreign-key value must match a primary-key value in an associated table
d. every foreign-key value must match a foreign-key value in an associated table
Q. ODBC stands for ______
a. offline database connection
b. oriented database connection
c. open database connection
d. none of above