Database Management System Mcqs with Answers

The database is a data structure that stores organized information. Most databases contain multiple tables, which may each include several different fields. For example, a company database may include tables for products, employees, and financial records.

Database Mcqs set 2

11. ………. keyword is used to find the number of values in a column.
A. TOTAL
B. COUNT
C. ADD
D. SUM

12. Data independence means
A. data is defined separately and not included in programs.
B. programs are not dependent on the physical attributes of data 
C. programs are not dependent on the logical attributes of data 
D. both B and C 


13. The collection of information stored in a database at a particular moment is called as ……
A. schema
B. instance of the database
C. data domain
D. independence

14. DBMS helps achieve
A. Data independence 
B. Centralized control of data
C. Neither A nor B
D. Both A and B 

15. Key to represent relationship between tables is called
A. primary key
B. secondary key
C. foreign key
D. none of the above

16. ………. command can be used to modify a column in a table
A. alter
B. update
C. set
D. create

17. A ……… is used to define overall design of the database
A. schema
B. application program
C. data definition language
D. code

18) Grant and revoke are ……. statements.
A. DDL
B. TCL 
C. DCL
D. DML


19. A relational database developer refers to a record as 
A. a criteria
B. a relation
C. a tuple
D. an attribute

20. An advantage of the database management approach is 
A. data is dependent on programs
B. data redundancy increases
C. data is integrated and can be accessed by multiple programs
D. none of the above


Next




Leave a Reply

Your email address will not be published. Required fields are marked *