IBPS SO | IT OFFICER - 3

DBMS

1. The DBMS acts as an interface between what two components of an enterprise class database system ?

a) Database application and database

b) Data and database

c) The user and the database application

d) Database application and SQL

e) None of these

2. The following are the components except 

a) User data

b) Metadata

c) Reports

d) Indices

e) None of these

3. A DBMS that combines a DBMS and an application generator is 

a) Microsoft's SQL Server

b) Microsoft Access

c) IBM's DB2

d) Oracle Corporation's Oracle

e) None of these

4. Which of the following is not considered to be a basic element of an enterprise class database system ?

a) Users

b) Database applications

c) DBMS

d) COBOL programs

e) None of these

5. The DBMS that is most difficult to use is

a) Microsoft SQL server

b) Microsoft access

c) IBM's DB2

d) Oracle corporation Oracle

e) None of these

6. A transparent DBMS 

a) Cannot hide sensitive information from users

b) Keep its logical structure hidden from users

c) Keeps its physical structure hidden from users

d) Both b and c

e) None of these

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

a) Print

b) Sort

c) Look up

d) All of the above

e) None of these

8. The master list of an indexed file ?

a) is sorted in ascending order

b) contains only a list of keys and a record numbers

c) has a number assigned to each record

d) Both a and c

e) None of these

9. A condition that led to development of database was ?

a) A demand for more data to support information needs

b) An increase in the amount of data handled by organisation

c) The proliferation of data files

d) All of the above

e) None of these

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

a) Spreadsheet program

b) Word processor program

c) Graphics program

d) All of the above

e) None of these

11.Goals for the design of logical schema includes ?

a) Avoiding data inconsistency

b) Being able to construct queries easily

c) Being able to access data efficiently

d) All of the above

e) None of these

12. A locked file is a ?

a) Accessed by only one user

b) Modified by users with the correct password

c) Is used to hide sensitive information

d) Both a and c

e) None of these

13. Manager's salary details are hidden from the employees. This is

a) Conceptual level data hiding

b) Physical level data hiding

c) External level data hiding

d) Internal data level hiding

e) None of these

14. A second normal form does not permit ___________ dependency between a non prime attribute and the relation key ?

a) Partial

b) Multi

c) Functional

d) Valued

e) None of these

15. A relation schema is in __________ if it is in the 1NF and if all non prime attributes are fully functionally dependent on the relation key ?

a) First normal form

b) Second normal form

c) Boyce Codd normal form

d) Fourth normal form

e) None of these

# Answers will be provided soon..!!