DataBase Management System (DBMS) solved MCQs

a. in the mysql database meta

B. in the mysql database metasql

c. in the mysql database metadata

d. in the mysql database mysql

a. identical

B. unique

c. auto_increment

d. sequence

a. keys

B. records

c. tables

d. fields

a. collection of data describing one particular enterprise

B. collection of programs to access data

c. all options are correct

d. collection of interrelated data

a. view level

B. physical level

c. logical level

d. critical level

a. data isolation

B. data redundancy and inconsistency

c. difficulty in accessing data

d. all options are correct

a. tables

B. attributes

c. database

d. entity sets

a. transaction manager

B. logical manager

c. file manager

d. buffer manager

a. retrieval of information stored in database

B. insertion of new information into the database

c. deletion of information from the database

d. all the options are correct

a. logical schema

B. physical schema

c. database schema

d. critical schema

a. data definition language

B. data manipulation language

c. data query language

d. all of the options

a. network maintenance

B. schema definition

c. authorization for data access

d. routine maintenance

a. entity relationship model

B. object based data model

c. all of the options are correct

d. relational data model

a. collection of interrelated data

B. collection of data describing one particular enterprise

c. all of the options

d. collection of programs to access data

a. physical level

B. view level

c. critical level

d. logical level

a. data redundancy and inconsistency

B. data isolation

c. all of the options

d. difficulty in accessing data

a. transaction manager

B. buffer manager

c. file manager

d. logical manager

a. retrieval of information stored in database

B. deletion of information from the database

c. all of the above

d. insertion of new information into the database

a. logical schema

B. critical schema

c. database schema

d. physical schema

a. all of the options

B. query language

c. data definition language

d. data manipulation language

a. authorization for data access

B. network maintenance

c. routine maintenance

d. schema definition

a. object-based data model

B. all of the options

c. entity-relationship model

d. relational data model

a. table

B. domain

c. attributes

d. relation

a. schema

B. superkey

c. domain

d. attribute

a. schema keys

B. attribute keys

c. candidate keys

d. domain keys