Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. According to the ANSI SQL standard, when does a transaction begin?
a. with use of the START command
b. when the first SQL statement is encountered
c. with the BEGIN command
d. with the BEGIN TRANSACTION command
Q. The ____ lock allows concurrent transactions to access the same row as long asthey require the use of different fields within that row.
a. table-level
b. page-level
c. row-level
d. field-level
Q. Which refers to a property of computer to run several operation simultaneouslyand possible as computers await response of each other:
a. Concurrency
b. Deadlock
c. Backup
d. Recovery
Q. Which is refers to a stalemate situation due to which no further progress ispossible as computer await response of each other:
a. Concurrency
b. Deadlock
c. Backup
d. Recovery
Q. Which is a duplicate copy of a file program that is stored on a different storagemedia than the original location:
a. Concurrency
b. Deadlock
c. Backup
d. Recovery
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. ................. requires that data should be made available to only authorized users.
a. Data integrity
b. Privacy
c. Security
d. None of the above
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. To delete a database ................... command is used
a. delete database database_name
b. Delete database_name
c. drop database database_name
d. drop database_name
Q. Some of the utilities of DBMS are .............i) Transaction ii) Backup iii) File organization iv) Process Organization
a. i, ii, and iv only
b. i, ii and iii only
c. ii, iii and iv only
d. All i, ii, iii, and iv