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
