IBPS IT Officer MCQ – 18 (DBMS)

Previous MCQs on DBMS:
DBMS 1

DBMS 2
DBMS 3
DBMS 4
DBMS 5

1. The candidate key is that you choose to identify each row uniquely is called ……………..
A) Alternet Key
B) Primary Key
C) Foreign Key
D) None of the above

2. …………….. is used to determine whether of a table contains duplicate rows.
A) Unique predicate
B) Like Predicate
C) Null predicate
D) In predicate

3. To eliminate duplicate rows ……………… is used
A) NODUPLICATE
B) ELIMINATE
C) DISTINCT
D) None of these

4. State true or false
i) A candidate key is a minimal super key.
ii) A candidate key can also refer to as surrogate key.
A) i-true, ii-false
B) i-false, ii-true
C) i-true, ii-true
D) i-false, ii-false

5. DCL stands for
A) Data Control Language
B) Data Console Language
C) Data Console Level
D) Data Control Level

6. …………………… is the process of organizing data into related tables.
A) Normalization
B) Generalization
C) Specialization
D) None of the above

7. A ………………. Does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity.
A) Weak entity
B) Strong entity
C) Non attributes entity
D) Dependent entity

8. …………….. is the complex search criteria in the where clause.
A) Substring
B) Drop Table
C) Predict
D) Predicate

9. ………………… is preferred method for enforcing data integrity
A) Constraints
B) Stored Procedure
C) Triggers
D) Cursors

10. The number of tuples in a relation is called its …………. While the number of attributes in a relation is called it’s ………………..
A) Degree, Cardinality
B) Cardinality, Degree
C) Rows, Columns
D) Columns, Rows

 

ANSWER

1. B) Primary Key
2. A) Unique predicate
3. C) DISTINCT
4. C) i-true, ii-true
5. A) Data Control Language
6. A) Normalization
7. A) Weak entity
8. D) Predicate
9. A) Constraints
10. B) Cardinality, Degree

About the author

A Moorthy

Leave a Comment