RDBMS (Unit 1 & 2)

Which of the following commands do we use to delete a relation (RDBMS) from a database?

• Delete relation

• Drop relation

• Alter relation

• Update relation

Which of the following command is a type of Data Definition language command?

• 1. Merge

• 1. Update

• 1. Delete

• 1. Create

Which one of the following is a type of Data Manipulation Command?

• 1. Create

• 1. Alter

• 1. Delete

• Drop

The "TCL" stands for_____.

• 1. Transaction Central Language

• 1. Transmission Control Language

• 1. Transaction Control Language

• 1. Ternary Control Language

In the relational table, which of the following can also be represented as "attribute"?

• 1. Entity

• 1. Row

• 1. Column

• 1. Both B &C

Which one of the following refers to the total view of the database content?

• 1. Conceptual view

• 1. Physical view

• 1. Internal view

• 1. External view

Which of the following levels is considered as the level closed to the end-users?

• 1. Internal Level

• 1. Conceptual Level

• 1. Physical Level

• 1. External Level

The descriptive property possessed by each entity set is _________

• Entity

• Attribute

• Relation

• Model

The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is

• Composite

• Multi valued

• Derived

• Single valued

Which of the following can be a multivalued attribute?

• Phone number

• Name

• Date of birth

• Age