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.
- 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
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: E
[/su_spoiler]
- 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
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: A
[/su_spoiler]
- 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
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: A
[/su_spoiler]
- 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
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: B
[/su_spoiler]
- 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
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: D
[/su_spoiler]
- Which privilege is required to create a database?
(a) SYSDBA
(b) DBA
(c) SYSOPER
(d) RESOURCE
(e) None of the above
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: A
[/su_spoiler]
- 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
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: A
[/su_spoiler]
- 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
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: B
[/su_spoiler]
- 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
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: C
[/su_spoiler]
- 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
[su_spoiler title="Answer" style="fancy" icon="arrow-circle-1"]
Option: C
[/su_spoiler]
Regards
Team EP