Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer

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

a. create assertion ‘assertion-name’ check ‘predicate’;

b. create assertion check ‘predicate’ ‘assertion-name’;

c. create assertions ‘predicates’;

d. all of the mentioned

a. cast

b. drop type

c. alter type

d. convert

a. create table . . .like

b. create table . . . as

c. with data

d. create view as

a. catalogs, schemas

b. schemas, catalogs

c. environment, schemas

d. schemas, environment

a. grant select on employee to amit

b. grant update(budget) on department to raj

c. grant update(budget,salary,rate) on department to raj

d. grant delete to amit