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