Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Which of the following SQL command can be used to modify existing data in a database table?
a. modify
b. update
c. change
d. new
Q. provides option for entering SQL queries as execution time, rather than at the development stage.
a. pl/sql
b. sql*plus
c. sql
d. dynamic sql
Q. The storage structure which do not survive system crashes are
a. volatile storage
b. non-volatile storage
c. stable storage
d. dynamic storage
Q. For a transaction to be durable, its changes need to be written to storage.
a. volatile storage
b. non-volatile storage
c. stable storage
d. dynamic storage
Q. The process of saving information onto secondary storage devices is referred to as
a. backing up
b. restoring
c. writing
d. reading
Q. If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by
a. flashback
b. rollback
c. both flashback and rollback
d. cannot be done
Q. Which of the following is an atomic sequence of database actions?
a. transaction
b. concurrency
c. relations
d. all of the mentioned
Q. Which of the following is not a state in transaction?
a. active
b. terminated
c. aborted
d. partially committed
Q. The is essentially used to search for patterns in target string.
a. like predicate
b. null predicate
c. in predicate
d. out predicate
Q. is a combination of two of more attributes used as a primary key
a. composite key
b. alternate key
c. candidate key
d. foreign key
Q. Which of the following is not the function of client?
a. compile queries
b. query optimization
c. receive queries
d. result formatting and presentation
Q. requires that data should be made available to only authorized users.
a. data integrity
b. privacy
c. security
d. none of the mentioned
Q. allows individual row operation to be performed on a given result set or on the generated by a selected by a selected statement.
a. procedure
b. trigger
c. curser
d. none of the mentioned
Q. Which s essential a business problem not a data problem:
a. data
b. database
c. database design
d. all of the mentioned