2 - Class 12 CS and IP Objective Type Revision Class - 2

 DBMS – CLASS 12 CS and IP

1.      The _______ allows you to perform tasks related to data definition.

A).   DDL

B).   DML

C).   TCL

D).   None of These

 

2.      The ________ allows you to perform tasks related to data manipulation.

A).   DDL

B).   DML

C).   TCL

D).   None of These

 

3.      A ________is a text that is not executed.

A).   Statement

B).   Query

C).   Comment

D).   Clause

 

4.      _________ are words that have a special meaning in SQL.

A).   Keywords

B).   Literal

C).   Variable

D).   Table

 

5.      _________command helps to open the database for use.

A).   Use

B).   Open

C).   Distinct

D).   Select

 

6.      ___________command helps to fetch data from relation.

A).   Use

B).   Show

C).   Fetch

D).   Select

 

7.      The ___________ keyword eliminates duplicate rows from the results of a Select statement.

A).   OR

B).   Distinct

C).   Any

D).   All

 

8.      __________command helps to see the structure of a table/relation.

A).   Show

B).   Select

C).   Describe

D).   Order By

 

9.      A relational database consists of a collection of

A).   Tables

B).   Fields

C).   Records

D).   Keys

 

10.   A relational database consists of a collection of

A).   Tuples

B).   Attributes

C).   Relations

D).   Keys

 

11.   A (n) ____ in a table represents a logical relationship among a set of values.

A).   Attribute

B).   Key

C).   Tuple

D).   Entry

 

12.   The term ________ is used to refer to a field in a table.

A).   Attribute

B).   Tuple

C).   Row

D).   Instance

 

13.   A _________ is a property of the entire relation, which ensures through its value that each tuple is unique in a relation.

A).   Rows

B).   Key

C).   Attribute

D).   Fields

 

14.   Which of the following attributes cannot be considered as a choice for primary key?

A).   Id

B).   License Number

C).   Dept_id

D).   Street

 

15.   An attribute in a relation is a foreign key if it is the _________ key in any other relation.

A).   Candidate

B).   Primary

C).   Super

D).   Sub

    CLICK HERE FOR VIDEO EXPLANATION OF THESE QUESTIONS

Answer:

1.      A

2.      B

3.      C

4.      A

5.      A

6.      D

7.      B

8.      C

9.      A

10.   C

11.   C

12.   A

13.   B

14.   D

15.   B