DBMS Multiple Choice Questions with Answer Set-1

1. E-R diagram ellipse represents

2. Column of a table in database table is called

3. According to the levels of abstraction, the schema at the intermediate level is called

4. The ______________________ component is used by the data analyst to create the queries that access the database.

5. A table has ___________________ number of columns, but ____________ number of rows.

6. A relation is in ______________

7. This ____________ data mining technique devices rules from real-world case examples.

8. The RDBMS organizes the data so that its external view is a set of ____________________

9. Table in DBMS means______________

10. In an E-R diagram double lines indicate

11. A ______________________ is considered as a collection of data items organized as a set of formally described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables.

12. All the information collected during database development during database development is stored in a _________________.

13. Data Integrity Control_______________

14. Manager's salary details are hidden from employees. This is

15. Which of the following can be determined only from the meaning of the attributes in the entity type:

16. What is data Integrity?

17. Student and courses are example of ___________________

18. Which of the following operations of DBMS is unary ?

19. When you drop a ______________ corresponding  indexes are also dropped.

20. A tuple defines a  collection of _____________________ values.