11). _______________________ keyword is, used to find the number of, values in a column.
A. TOTAL,
B. Count,
C. ADD,
D. SUM,
see answer
B. Count,
12) The benefit of the database management method is:
A. data is dependent, on programs,
B. data redundancy increases,
C. data is integrated, and can be accessed by, multiple programs
D. None ,
see answer
C. data is integrated, and can be accessed by, multiple programs
13) The collection of info kept, in a database at a particular, moment is called as:
A. schema
B. instance of the database
C. programs are not, dependent on the logical, attributes of data
D. Both Band C
see answer
B. instance of the database
14) A _______________ is used to define, overall design of the, database.
A. schema
B. application program
C. data definition language
D. code
see answer
A. schema
15) Key to represent, relationship between tables, is called:
A. primary key,
B. secondary key,
C. foreign key
D. none of the above
see answer
C. foreign key
16) “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. data domain,
D. independence,
see answer
D. independence,
17) Grant and revoke, are ____________________________ statements.
A. DDL,
B. TCL,
C. DCL,
D. DML,
see answer
C. DCL,
18) “DBMS” helps achieve:
A. Data independence
B. Centralized control of data
C. Neither A nor B
D. Both A and B
see answer
D. Both A and B
19. ___________________Command can be, used to adapt a column, in a table
A. alter,
B. update,
C. set,
D. create,
see answer
A. alter,
20. The rough fact and figures are also known as:
A. Information
B. Schema
C. Data
D. None
see answer
C. Data
