Thursday, 10 December 2015

IBPS SO (IT Officer) Exam : Computer Knowledge Database Management System Quiz 71

Dear candidates,
Here we are sharing the Quiz for IBPS SO (IT Officer) Exam Computer Knowledge Database Management System Free online mock test quiz.

1. Primitive operations common to all record management systems include
(a) Print             
(b) Sort              
(c) Look-up       
(d) All of the above


2. Each of data files has a _______ that describe the way the data is stored in the file.
(a) File structure            
(b) Records       
(c) Fields            
(d) Database

3. What is the language used by most of the DBMS for helping their users to access data?
(a) High level language
(b) Query language       
(c) SQL
(d) 4GL

4. Data item characteristics that are important in data management include
(a) Punctuation              
(b) Language    
(c) Spelling        
(d) Width

5. A locked file can be                                
(a) Accessed by only one user   
(b) Modified by users with the correct password            
(c) Is used to hide sensitive information              
(d) Both (b) and (c)

6. 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

7. 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

8. 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

9. When using a database management system, the first thing that you must do is to
(a) Create a database file               
(b) Activate file editor   
(c) Load the software into your microcomputer              
(d) Keep a floppy disk in readiness

10. 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

11. The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
(a) Record           
(b) Field             
(c) File  
(d) Data base

12. 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

13. 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

14. 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

15. Which privilege is required to create a database?
(a) SYSDBA        
(b) DBA              
(c) SYSOPER      
(d) RESOURCE

16. 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

17. Which type of file is part of the Oracle database?                                 
(a) Control file
(b) Password file                
(c) Parameter files         
(d) Archived log files

18. 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

19. What Oracle backup and recovery file contains user and system data?
(a) Control file  
(b) Data file      
(c) OnLine ReDo file      
(d) Offline ReDo file

20. When is the SGA created in an Oracle database environment?
(a) When the database is created           
(b) When a user process is started         
(c) When the database is mounted        
(d) When the instance is started

Also read our previous Free Computer Knowledge/Computer Awareness Moct Test Online Quiz for IBPS Bank PO and Clerk Exam. IBPS SO Specialist Officer Exam. SBI PO and Clerk Exam. RRB Office Assistant and PO Exam, RRB Grade 'B' Officer and Assistant Exam.
 

No comments:

Post a Comment

Advertisement