Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Which of the following is TRUE?
a. every relation in 2nf is also in bcnf
b. a relation r is in 3nf if every non-prime attribute of r is fully functionally dependent on every key of r
c. every relation in bcnf is also in 3nf
d. no relation can be in both bcnf and 3nf
Q. combines the data manipulating power of SQL with the data processing power of Procedural languages.
a. pl/sql
b. sql
c. advanced sql
d. pql
Q. has made PL/SQL code run faster without requiring any additional work on the part of the programmer.
a. sql server
b. my sql
c. oracle
d. sql lite
Q. is a sequence of zero or more characters enclosed by single quotes.
a. integers literal
b. string literal
c. string units
d. string label
Q. In the management of the password for the account can be handled outside of oracle such as operating system.
a. database authentication
b. operating system authentication
c. internal authentication
d. external authentication
Q. In of Oracle, the database administrator creates a user account in the database for each user who needs access.
a. database authentication
b. operating system authentication
c. internal authentication
d. external authentication
Q. Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction?
a. only 1
b. only 2
c. both 1 and 2 individually
d. either 1 or 2
Q. A transaction is delimited by statements (or function calls) of the form
a. begin transaction and end transaction
b. start transaction and stop transaction
c. get transaction and post transaction
d. read transaction and write transaction
Q. Identify the characteristics of transactions
a. atomicity
b. durability
c. isolation
d. all of the mentioned
Q. Which of the following has “all-or-none” property?
a. atomicity
b. durability
c. isolation
d. all of the mentioned
Q. The property of a transaction that persists all the crashes is
a. atomicity
b. durability
c. isolation
d. all of the mentioned
Q. states that only valid data will be written to the database.
a. consistency
b. atomicity
c. durability
d. isolation
Q. The Oracle RDBMS uses the statement to declare a new transaction start and its properties.
a. begin
b. set transaction
c. begin transaction
d. commit
Q. In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?
a. create package
b. create schema
c. create cluster
d. all of the mentioned
Q. The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’,’b’),
a. 6789
b. 2345
c. 1234
d. 456789