Database Systems MCQS
All Questions for: Database Systems MCQS
Question 51: Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?
- A ALTER TABLE
- B All of the above
- C MODIFY TABLE
- D DEFINE TABLE
- E None of the above
Explanation: The correct answer to the question is: ALTER TABLE
Question 52: Which command is used to select distinct subject (SUB) from the table (BOOK)?
- A SELECT SUB FROM BOOK
- B SELECT DISTINCT SUB FROM BOOK
- C None of the above
- D SELECT ALL FROM BOOK
- E All of the above
Explanation: The correct answer to the question is: SELECT DISTINCT SUB FROM BOOK
Question 53: Which two files are used during operation of the DBMS?
- A data dictionary and transaction log
- B query language and utilities
- C data dictionary and query language
- D data manipulation language and query language
- E None of the above
Explanation: The correct answer to the question is: data dictionary and transaction log
Question 54: A form can be used to
- A None of the above
- B modify records
- C delete records
- D All of the above
- E format printed output
Explanation: The correct answer to the question is: All of the above
Question 55: 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 None of the above
- B Relational database
- C Hierarchical database
- D Network database
- E Distributed database
Explanation: The correct answer to the question is: Hierarchical database
Question 56: Long-range planning report produced in an MIS are primarily designed for
- A top management
- B All of the above
- C None of the above
- D lower management
- E middle management
Explanation: The correct answer to the question is: top management
Question 57: A database management system might consist of application programs and a software package called
- A TOTAL
- B BPL
- C AUTOFLOW
- D FORTRAN
- E None of the above
Explanation: The correct answer to the question is: BPL
Question 58: The _____ command is used to allocates an extent for the table in SQL
- A MODIFY ALLOCATES
- B ALTER TABLE
- C None of the above
- D MODIFY TABLE
- E REDEFINE TABLE
Explanation: The correct answer to the question is: MODIFY ALLOCATES
Question 59: In SQL, which command(s) is(are) used to enable/disable a database trigger?
- A ALTER DATABASE
- B ALTER TABLE
- C ALTER TRIGGER
- D All of the above
- E MODIFY TRIGGER
Explanation: The correct answer to the question is: ALTER TRIGGER
Question 60: The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in
- A a hashed file
- B a tree file
- C a sequential file
- D an indexed file
- E None of the above
Explanation: The correct answer to the question is: a hashed file
Question 61: A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?
- A None of the above
- B Update file
- C Specialized file
- D Log file
- E Master file
Explanation: The correct answer to the question is: Master file
Question 62: In SQL, the CREATE TABLE is used
- A to redefine a column
- B to create a table, defining its columns, integrity constrains, and storage allocation
- C All of the above
- D to add a column/integrity constraint to a table
- E to change a table's storage characteristics
Explanation: The correct answer to the question is: to create a table, defining its columns, integrity constrains, and storage allocation
Question 63: When performing a look-up operation using a form
- A None of the above
- B you type the key in an entry line, and the correct form is displayed
- C you look at each form sequentially until you see the one you want
- D you enter the search value into the form
- E All of the above
Explanation: The correct answer to the question is: you enter the search value into the form
Question 64: Data security threats include
- A None of the above
- B privacy invasion
- C fraudulent manipulation of data
- D hardware failure
- E All of the above
Explanation: The correct answer to the question is: privacy invasion
Question 65: In SQL, which command is used to create a database user?
- A All of the above
- B ADD USER TO DATABASE
- C CREATE USER
- D None of the above
- E MK USER
Explanation: The correct answer to the question is: CREATE USER
Question 66: An audit trail
- A is used to make back-up copies
- B can be used to restore lost information
- C None of the above
- D All of the above
- E is the recorded history of operations performed on a file
Explanation: The correct answer to the question is: is the recorded history of operations performed on a file
Question 67: The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?
- A None of the above
- B Bits
- C Schema
- D Data field
- E Characters
Explanation: The correct answer to the question is: Data field
Question 68: A top-to-bottom relationship among the items in a database is established by a
- A Network schema
- B All of the above
- C Relational schema
- D Hierarchical schema
- E None of the above
Explanation: The correct answer to the question is: Hierarchical schema
Question 69: A condition that led to the development of databases was
- A a demand for more data to support information needs
- B the proliferation of data files
- C None of the above.
- D All of the above
- E an increase in the amount of data handled by organizations
Explanation: The correct answer to the question is: All of the above
Question 70: Which language has recently become the de-facto standard for interfacing application programs with relational database system?
- A None of the above
- B 4GL
- C SQL
- D dBASE
- E Oracle
Explanation: The correct answer to the question is: SQL
Question 71: In SQL, the CREATE TABLESPACE is used
- A to create a database trigger
- B None of the above
- C All of the above
- D to add/rename data files, to change storage
- E to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
Explanation: The correct answer to the question is: to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
Question 72: A _____ means that one record in a particular record type may be related to more than one record of another record type.
- A None of the above
- B Many-to many relationship
- C Many-to-one relationship
- D One-to-one relationship
- E One-to-many relationship
Explanation: The correct answer to the question is: One-to-many relationship
Question 73: In SQL, the ALTER TABLESPACE command is used
- A All of the above
- B to take a tablespace online/offline
- C to change storage characteristics
- D to add/rename data files
- E to begin/end a backup
Explanation: The correct answer to the question is: All of the above
Question 74: Which command(s) is(are) used to redefine a column of the table in SQL ?
- A ALTER TABLE
- B All of the above
- C None of the above
- D DEFINE TABLE
- E MODIFY TABLE
Explanation: The correct answer to the question is: ALTER TABLE
Question 75: Which command is used to remove an index from the database in SQL?
- A REMOVE INDEX
- B DELETE INDEX
- C None of the above
- D DROP INDEX
- E ROLL BACK INDEX
Explanation: The correct answer to the question is: DROP INDEX
Question 76: If you want your database to include methods, you should use a _____ database.
- A Network
- B Hierarchical
- C None of the above
- D Object-Oriented
- E Distributed
Explanation: The correct answer to the question is: Object-Oriented
Question 77: With respect to data input, the most accurate description of batch control is
- A None of the above
- B comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system
- C All of the above
- D dividing documents to be entered into batches
- E controlling the input of each input clerk
Explanation: The correct answer to the question is: comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system
Question 78: A set of programs that handle a firm's data base responsibilities is called a
- A Data Base Management System (DBMS)
- B None of the above
- C All of the above
- D Data Base Processing System (DBPS)
- E Data Management System (DMS)
Explanation: The correct answer to the question is: All of the above
Question 79: In a relational schema, each tuple is divided into fields called
- A All of the above
- B Queries
- C Relations
- D None of the above
- E Domains
Explanation: The correct answer to the question is: Domains
Question 80: Which of the following is not an advantage of the data-base approach?
- A program/data independence
- B elimination of the data redundancy
- C increased security
- D All of the above are advantages
- E ability to associate related data
Explanation: The correct answer to the question is: All of the above are advantages
Question 81: A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.
- A Many-to-many relationship
- B One-to-one relationship
- C Many-to-one relationship
- D None of the above
- E One-to-many relationship
Explanation: The correct answer to the question is: Many-to-many relationship
Question 82: Which command is used to remove a table from the database in SQL?
- A UNATTACH TABLE
- B ERASE TABLE
- C DROP TABLE
- D DELETE TABLE
- E None of the above
Explanation: The correct answer to the question is: DROP TABLE
Question 83: When using a database management system, the first thing that you must do is to
- A keep a floppy disk in readiness
- B None of the above
- C activate file editor
- D load the software into your micro
- E create a database file
Explanation: The correct answer to the question is: load the software into your micro
Question 84: Data items grouped together for storage purposes are called a
- A list
- B title
- C record
- D None of the above
- E string
Explanation: The correct answer to the question is: record
Question 85: Data item characteristics that are important in data management include
- A spelling
- B None of the above
- C width
- D language
- E punctuation
Explanation: The correct answer to the question is: width
Question 86: Sort/report generators
- A None of the above
- B both (a) and (b)
- C do not need to sort before generating a report
- D are faster than index/report generators
- E require more disk space than index/report generators
Explanation: The correct answer to the question is: require more disk space than index/report generators
Question 87: An-owner-member set in the CODASYL specifications may have
- A only one member but many member occurrence
- B only one owner but many owner occurrences
- C None of the above
- D All of the above
- E more than one member but only one occurrence per member
Explanation: The correct answer to the question is: only one owner but many owner occurrences
Question 88: The master list of an indexed file
- A has a number assigned to each record
- B contains only a list of keys and record numbers
- C None of the above
- D both (b) and (c)
- E is sorted in ascending order
Explanation: The correct answer to the question is: has a number assigned to each record
Question 89: The designer of a form includes
- A data
- B filed designators
- C both (a) and (b)
- D None of the above
- E prompts
Explanation: The correct answer to the question is: both (a) and (b)
Question 90: After you _____ a record, many data management the environments require you to issue a command to save the changes you made.
- A Index
- B None of the above
- C Delete
- D Sort key
- E Update
Explanation: The correct answer to the question is: Update
Question 91: In a large DBMS
- A each user can access every sub
- B each subschema contains every field in the logical schema
- C All of the above
- D each user can "see" only a small part of the entire database
- E None of the above
Explanation: The correct answer to the question is: each user can "see" only a small part of the entire database
Question 92: The index consists of
- A both (a) and (b)
- B All of the above
- C pointers to the master list
- D None of the above
- E a list of keys
Explanation: The correct answer to the question is: both (a) and (b)
Question 93: A network schema
- A permits many-to-many relation
- B None of the above
- C All of the above
- D restricts the structure to a one-to-many relationship
- E stores data in tables
Explanation: The correct answer to the question is: permits many-to-many relation
Question 94: In SQL, which command(s) is(are) used to create a synonym for a schema object?
- A All of the above
- B CREATE SAME
- C CREATE SCHEMA
- D CREATE SYNONYM
- E None of the above
Explanation: The correct answer to the question is: CREATE SYNONYM
Question 95: The database administration function includes
- A computer operations management
- B All of the above
- C None of the above
- D application programming
- E database access planning
Explanation: The correct answer to the question is: database access planning
Question 96: If the record management system allows you to edit values before they are recorded on disk, you can
- A All of the above
- B None of the above
- C correct spelling changes before they are recorded
- D change the width of a field
- E change the name of a field
Explanation: The correct answer to the question is: correct spelling changes before they are recorded
Question 97: What name is given to the collection of facts, items of information or data which are related in some way?
- A Database
- B Directory information
- C None of the above
- D Information tree
- E Information provider
Explanation: The correct answer to the question is: Database
Question 98: A database management system
- A both (a) and (b)
- B allows simultaneous access to multiple files
- C can do more than a record management system
- D is a collection of programs for managing data in a single file
- E None of the above
Explanation: The correct answer to the question is: both (a) and (b)
Question 99: Two files may be joined into a third file if
- A both (b) and (c)
- B they have no records with the same value in the common field
- C they have a field in common
- D None of the above
- E they have a row in common
Explanation: The correct answer to the question is: they have a field in common
Question 100: A _____ means that one record in a particular record type is related to only one record of another record type.
- A None of the above
- B Many-to-one relationship
- C One-to-one relationship
- D Many-to-many relationship
- E One-to-many relationship
Explanation: The correct answer to the question is: One-to-one relationship