Solved MCQ of Database Management System (DBMS) Set - 3

1. State true or false.
i) Select operator is not a unary operator.
ii) Project operator chooses subset of attributes or columns of a relation.

A) i-True, ii-False

B) i-True, ii-True

C) i-False, ii-True

D) i-False, ii-False


2. …………… database is used as template for all databases created.

A) Master

B) Model

C) Tempdb

D) None of the above


3. One aspect that has to be dealt with by the integrity subsystem is to ensure that only valid values can be assigned to each data items. This is referred to as

A) Data Security

B) Domain access

C) Data Control

D) Domain Integrity


4. ………………….. operator is basically a join followed by a project on the attributes of first relation.

A) Join

B) Semi-Join

C) Full Join

D) Inner Join


5. Which of the following is not a binary operator in relational algebra?

A) Join

B) Semi-Join

C) Assignment

D) Project


6. Centralizing the integrity checking directly under the DBMS ………….. Duplication and ensures the consistency and validity of the database.

A) Increases

B) Skips

C) Does not reduce

D) Reduces


7. Which of the following is/are the DDL statements?

A) Create

B) Drop

C) Alter

D) All of the above


8. In snapshot, …………………. clause tells oracle how long to wait between refreshes.

A) Complete

B) Force

C) Next

D) Refresh


9. ……………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.

A) Column

B) Constraint

C) Index

D) Trigger


10. For like predicate which of the following is true.
i) % matches zero of more characters.
ii) _ matches exactly one character.

A) i-only

B) ii-only

C) Both of them

D) None of them

Answers:

1. C) i-False, ii-True
2. B) Model
3. D) Domain Integrity
4. B) Semi-Join
5. D) Project
6. D) Reduces
7. D) All of the above
8. D) Refresh
9. B) Constraint
10. C) Both of them

Related Posts

• Solved MCQ of Database Management System (DBMS) Set - 1

• Solved MCQ of Database Management System (DBMS) Set - 2

• Solved MCQ of Database Management System (DBMS) Set - 3

• Solved MCQ of Database Management System (DBMS) Set - 4

• Solved MCQ of Database Management System (DBMS) Set - 5

• MCQ of Database Management System (DBMS) with answer set-6

• MCQ of Database Management System(DBMS) with answer set-7

• Solved MCQ of Database Management System (DBMS) Set - 8

• Solved Objective Questions of Database Management System set-9

• Solved MCQ on Fundamental of DBMS set-10

For other more Multiple Choice Questions (MCQs): Click Here