IBPS SO | IT OFFICER QUIZ - 5

DBMS

1. Once a sequence is created, it is documented in the ?

a. Database

b. Database admin

c. Data Dictionary

d. Data Document

e. None of these

2. What software packages are most commonly  for business that have to track extensive lists of clients and inventory ?

a. Special purpose package

b. Custom made programs

c. Single function application package

d. Data management packages

e. None of these

3. Periodically adding, changing and deleting file records in a file called ?

a. Updating

b. Upgrading

c. Restructuring

d. Renewing

e. None of these

4. Data security threats include ?

a. Hardware failure

b. Privacy inclusion

c. Fraudulent manipulation of data

d. All of these

e. None of these

5. The online soft copy display a customer's charge account to respond to an enquiry is an example of ?

a. Forecasting report

b. Exception report

c. Regulated scheduled report

d. Do demand report

e. None of these

6. In order to understand DBMS, it is important to understand ?

a. The physical schema

b. All sub schema that are system supported

c. One sub schema

d. Both a and b

e. On demand report

7. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles ?

a. Full backup

b. Consistent backup

c. Inconsistent backup

d. Differential backup

e. None of these

8. Which type of file is part of the Oracle Database ?

a. Control file

b. Password file

c. Parameters file

d. Archieved log files

e. None of these

9. What type of failure occurs when Oracle fails due to an operating system or computer hardware failure ?

a. Application failure

b. Instance failure

c. Media failure

d. Rollback failure

e. None of these

10. What Oracle backup and recovery file contains user and system data ?

a. Control file

b. Datafile

c. OnLine ReDo file

d. Offline ReDo file

e. None of these