Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. What type of join is needed when you wish to include rows that do not have matching values?
a. equi-join
b. natural join
c. outer join
d. all of the mentioned
Q. The operation which is not considered a basic operation of relational algebra is
a. join
b. selection
c. union
d. cross product
Q. In SQL the statement select * from R, S is equivalent to
a. select * from r natural join s
b. select * from r cross join s
c. select * from r union join s
d. select * from r inner join s
Q. Which of the following creates a virtual relation for storing the query?
a. function
b. view
c. procedure
d. none of the mentioned
Q. Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause?
a. with
b. check
c. with check
d. all of the mentioned
Q. A consists of a sequence of query and/or update statements.
a. transaction
b. commit
c. rollback
d. flashback
Q. In order to undo the work of transaction after last commit which one should be used?
a. view
b. commit
c. rollback
d. flashback
Q. In case of any shut down during transaction before commit which of the following statement is done automatically?
a. view
b. commit
c. rollback
d. flashback
Q. In order to maintain the consistency during transactions, database provides
a. commit
b. atomic
c. flashback
d. retain
Q. A transaction completes its execution is said to be
a. committed
b. aborted
c. rolled back
d. failed
Q. Which of the following is used to get back all the transactions back after rollback?
a. commit
b. rollback
c. flashback
d. redo
Q. Which of the following is not an integrity constraint?
a. not null
b. positive
c. unique
d. check ‘predicate’
Q. Domain constraints, functional dependency and referential integrity are special forms of
a. foreign key
b. primary key
c. assertion
d. referential constraint