Latest Banking jobs   »   IT Officer Quiz (DBMS): 23 January...

IT Officer Quiz (DBMS): 23 January 2016



00:00:00



1. A deadlock exists in the system if and only if the wait-for graph contains a ___________.

Direction
Bi-direction
Rotation
Cycle
None of the above


2. Referential integrity controls relationships between :

attributes in a table
operations of an object
instances of a class
tables in a database
none of the above


3. Before any changes to database structure are attempted one should first:

create a complete backup of the operational database only.
clearly understand the current structure and contents of the database only.
test any changes on a test database only.
All of the above should be done.
None of the above

4. What is true about 4 NF ?

if a table is in a BCNF
contains multivalued dependencies
contains no multivalued dependencies
if a table is in a BCNF and contains no multivalued dependencies
None of these

5. The overall design of a database is called?

Structure of the database
The screen of database
Scheme of the database
View of the database
None of the above

6. 2 NF is based on the concept of

Multivalued dependency
Join dependency
Functional dependency
All of the above
None of the above

7. What is true about Growing phase ?

transaction may obtain locks
may release any lock
transaction may obtain locks but may not release any lock
transaction may release locks but may not obtain any new locks
None of these

8. What is true about Shrinking phase ?

transaction may release locks but may not obtain any new locks
transaction may obtain locks but may not release any lock
transaction may obtain locks and may release any lock
transaction may release locks
none of the above

9. In SQl, which command(s) is/are used to enable/disable a database trigger

ALTER VIEW
CREATE VIEW
DEFINE VIEW
COMPILE VIEW
None of these


10. A computer file contains several records. What does each record contains?

Bytes
Field
Words
Database
None of these

                                       


Leave a comment

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