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
- 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
- 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
- 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
- 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
- Which privilege is required to create a database?
(a) SYSDBA
(b) DBA
(c) SYSOPER
(d) RESOURCE
(e) None of the above
- 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
- 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
- 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
- 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
Regards
Team EP
This post was last modified on November 14, 2018 10:09 pm