Database Management MCQs

A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as ..........

• Data Model

• E-R Model

• DBMS

• All of the above

Dr.E.F. Codd represented ....... rules that a database must obey if it has to be considered truly relational.

• 10

• 15

• 14

• 12

In E-R Diagram, weak entity is represented by.......

• Rectangle

• Square

• Double Rectangle

• Circle

........ is a bottom-up approach in which two lower level entities combine to form a higher level entity.

• Aggregation

• Specialization

• Generalization

• None of the above

An entity set that does not have sufficient attributes to form a primary key, is a ......

• Primary entity set

• Weak entity set

• Strong entity set

• None of the above

Which SQL command delete all the records and does not remove the structure?

• Drop

• Insert

• Truncate

• None of the above

Which of the following is a Data Definition Language (DDL) command?

• Delete

• Insert

• Drop

• Merge

In ........ database, data is organized in the form of trees with nodes.

• Hierarchical

• Relational

• Network

• None of the above

Which command is used to retrieve records from one or more table?

• Delete

• Insert

• Drop

• Select

Rows of a relation are called

• entity

• degree

• tuples

• None of the above