Latest Banking jobs   »   Professional Knowledge Quiz for IBPS SO...

Professional Knowledge Quiz for IBPS SO IT Officer 2017

Professional Knowledge Quiz for IBPS SO IT Officer 2017 |_2.1

Q1. Which of the following is a database administrator’s function?
(a)Database design
(b)Backing up the database
(c)Performance monitoring
(d)User coordination
(e)All of the above

Q2. In SQL, which command is used to make permanent changes made by statements  since the beginning of a transaction?
(a)ZIP
(b)PACK
(c)COMMIT
(d)SAVE
(e)None of the above

Q3.The data dictionary tells the DBMS
(a)What files are in the Database
(b)What attribute are possessed by the data
(c)What these files contain
(d)All of the above
(e)None of the above

Q4.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
Q5.A top-to-bottom relationship among the items in a database is established by a
(a)Hierarchical schema
(b)Network schema
(c)Relational schema
(d)All of the above
(e)None of the above

Q6.Which of the following hardware components is the most important to the operation of a database management system?
(a)high-resolution video display
(b)printer
(c)high speed, large-capacity disk
(d)plotter
(e)mouse

Q7.In a _____ a parent record type can be linked to one or more “child” record types, but a child record type can have only one parent.
(a)Network database
(b)Relational database
(c)Distributed database
(d)Hierarchical database
(e)None of the above

Q8.Which two files are used during operation of the DBMS?
(a)query language and utilities
(b)data manipulation language and query language
(c)data dictionary and transaction log
(d)data dictionary and query language
(e)None of the above

Q9.A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?
(a)Specialized file
(b)Log file
(c)Master file
(d)Update file
(e)None of the above

Q10.Updating a database means
(a)revising the file structure
(b)reorganizing the database
(c)modifying or adding record occurrences
(d)All of the above
(e)None of the above

Q11. In SQL, which command is used to add new rows to a table?
(a)ALTER TABLE
(b)ADD ROW
(c)INSERT
(d)APPEND
(e)None of the above

Q12.A database management system might consist of application programs and a software package called
(a)FORTRAN
(b)AUTOFLOW
(c)BPL
(d)TOTAL
(e)None of the above

Q13.A race condition occurs when
(a)Two concurrent activities interact to cause a processing error
(b)two users of the DBMS are interacting with different files at the same time
(c)both (a) and (b)
(d)All of the above
(e)None of the above

Q14.Data integrity control
(a)is used to set upper and lower limits on numeric data
(b)requires the use of passwords to prohibit unauthorized access to the file
(c)has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
(d)All of the above
(e)None of the above

Q15.Database management systems are intended to:
(a)eliminate data redundancy
(b)establish relationship among different records in different files
(c)manage file access
(d)maintain data integrity
(e)all of the above



Professional Knowledge Quiz for IBPS SO IT Officer 2017 |_3.1
Professional Knowledge Quiz for IBPS SO IT Officer 2017 |_4.1

Professional Knowledge Quiz for IBPS SO IT Officer 2017 |_5.1

Leave a comment

Your email address will not be published. Required fields are marked *