Placement papers on Database - Set 3

Placement papers on Database - Set 3

1. A transparent DBMS?

Can not hide sensitive information from users
Keep its logical structure hidden from users
Keeps its physical structure hidden from users
Both B and C
View Answer / Hide Answer


2. Primitive operations common to all record management system include ?

Print
Sort
Look up
All of above
View Answer / Hide Answer


3. The master list of an indexed file ?

Is sorted in ascending order
contains only a list of keys and record numbers
has a number assigned to each record
Both B and C
View Answer / Hide Answer


4. A condition that led to the development of database was ?

A demand for more data to support information needs
An increase in the amount of data handled by organizations
The poliferation of data files
All of above
View Answer / Hide Answer


5. Information can be transferred between the DBMS and a ?

Spreadsheet program
Word processor program
Graphics programs
All of above
View Answer / Hide Answer


6. Goals for the design of the logical schema includes ?

Avoiding data inconsistency
Being able to construct queries easily
Being able to access data efficiency
All of above
View Answer / Hide Answer


7. A locked file can be ?

Accessed by only one user
Modified by users with the correct password
Is used to hide sensitive information
Both B and C
View Answer / Hide Answer


8. A trigger is ?

A statement that enables to start any DBMS
A statement that is executed by the user when debugging an application program
A condition the system tests for the validity of the database user
A statement that is executed automatically by the system as a side effect of modification to the database
View Answer / Hide Answer


9. Manager's salary details are hidden from the employee. This is ?

Conceptual level data hiding
Physical level data hiding
Externel level hiding
None of above
View Answer / Hide Answer


10. An unnormalized relation contains values ?

Atomic
Non - Atomic
Classified
None of these
View Answer / Hide Answer