Latest Banking jobs   »   IT Officer Quiz (DBMS):16 January 2016

IT Officer Quiz (DBMS):16 January 2016



00:00:00



1. Which is not a component of a relational database?

Entity
Attribute
Table
hierarchy
All of the above


2. Fifth Normal form is concerned with

Functional dependency
Join dependency
Multivalued dependency
Domain-key
none of the above


3. Functional Dependencies are the types of constraints that are based on______.

Key
Key revisited
Superset key
All of the above
None of the above

4. Which is a unary operation:

Selection operation
Primitive operation
Projection operation
Generalized selection
None of these

5. A _____ indicates an absent value that may exist but be unknown or that may not exist at all.

Empty tuple
New value
NULL value
Old value
None of the above

6. Using the ______ clause retains only one copy of such identical tuples.

Null
Unique
Not Null
Distinct
None of the above

7. The primary key must be

Unique
Not Null
Both (a) and (b)
Either a or b
None of the above

8. The normal form which satisfies multivalued dependencies and which is in BCNF is

4 NF
3 NF
2 NF
1 NF
All of the mentioned

9. Representations such as the in the dept year relation, with one column for each value of an attribute, are called _______; they are widely used in spreadsheets and reports and in data analysis tools.

Cross-tabs
Snapshot
Both (a) and (b)
All of the above
None of these


10. The logical data structure with a one-to-many relationship is :

Network
Tree
Chain
Relational
None of these

                                       




Leave a comment

Your email address will not be published. Required fields are marked *