IBPS SO IT Officer Professional Knowledge Quiz – DBMS – 3

Hello and welcome to exampundit. Here is a set of IBPS SO IT Officer Professional Knowledge Quiz on Database Management System (DBMS) for IBPS IT Officer Mains exam 2018.

IBPS SO IT Officer Professional Knowledge Quiz

 

  1. If the record management system allows you to edit values before they are recorded on disk, you can

(a) correct spelling changes before they are recorded

(b) change the name of a field

(c) change the width of a field

(d) All of the above

(e) None of the above

Answer

Option: E

 

  1. The relational model uses some unfamiliar terminology. A tuple is equivalent to a:

(a) Record

(b) Field

(c) File

(d) Data base

(e) Data item

Answer

Option: A

 

  1. Which command is used to remove an index from the database in SQL?

(a) DELETE INDEX

(b) DROP INDEX

(c) REMOVE INDEX

(d) ROLL BACK INDEX

(e) None of the above

Answer

Option: A

 

  1. What is the name given to the database management system which is able to handle full text data, image data, audio and video?

(a) Full media

(b) Graphics media

(c) Multimedia

(d) Hypertext

(e) None of the above

Answer

Option: B

 

 

  1. Which password management feature ensures a user cannot reuse a password for a specified time interval?

(a) Account Locking

(b) Password History

(c) Password Verification

(d) Password Expiration and Aging

(e) None of the above

Answer

Option: D

 

  1. Which privilege is required to create a database?

(a) SYSDBA

(b) DBA

(c) SYSOPER

(d) RESOURCE

(e) None of the above

Answer

Option: A

 

  1. What is the type of Oracle backup in which all uncommitted changes have been removed from the data files?

(a) Full backup

(b) Consistent backup

(c) Inconsistent backup

(d) Differential backup

(e) None of the above

Answer

Option: A

 

  1. Which type of file is part of the Oracle database?

(a) Control file

(b) Password file

(c) Parameter files

(d) Archived log files

(e) None of the above

Answer

Option: B

 

  1. 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 the above

Answer

Option: C

 

  1. 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 the above

Answer

Option: C

 

Regards

Team EP