DBMS Multiple Choice Questions with Answers Set-3

1. A set of programs that handle a firm's database responsibilities is called a ___________________.

2. A top to the bottom relationship among the items in a database is established by a _________.

3. The relational model includes two general integrity rules. Integrity rule 1 is concerned with _____________ and Integrity rule 2 is concerned with _________________.

4. ____________________ is person who has the central control over both data and application programs.

5. An Attribute of a relation that references the primary key of another relation is known as the _______________.

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

7. In a relational database, this is a data structure that organizes the information about a single topic into rows and columns.

8. The index created by primary key column is called ________________.

9. In SQL , which command(s) is(are) used to remove rows from a table.

10. In SQL, the CREATE TABLE is used

11. What is abbreviation is used for a software package that permits the user to create, retrieve and maintain records in a database?

12. In SOL, which command is used to add new rows to a table?

13. In SQL, which of the following is not a data Manipulation Language Command?

14. The value for an attribute or a column is drawn from a set of values known as __________________.

15. Entities having primary key are called ____________________.

16. Which of the following is not a type of SQL statement?

17. Which of the following is not included in DML (Data Manipulation Language).

18. TRUNCATE statement in SQL is a ___________________________.

19. To discard all pending data ___________________.

20. ___________ is the situation in which a process is waiting on another process, which is also waiting on another process which is waiting on the first process. None of the processes involved in this circular wait is making progress.