Database Systems MCQS
All Questions for: Database Systems MCQS
Question 1: In SQL, which command is used to select only one copy of each set of duplicable rows
- A SELECT DISTINCT
- B SELECT DIFFERENT
- C None of the above
- D All of the above
- E SELECT UNIQUE
Explanation: The correct answer to the question is: SELECT DISTINCT
Question 2: Which of the following is not the responsibility of the utilities component of DBMS software?
- A removing flagged records for deletion
- B None of the above
- C monitoring performance
- D creating the physical and logical designs
- E creating and maintaining the data dictionary
Explanation: The correct answer to the question is: creating the physical and logical designs
Question 3: Which of the following is not a logical data-base structure?
- A network
- B tree
- C relational
- D chain
- E All of the above
Explanation: The correct answer to the question is: chain
Question 4: In SQL, which command is used to changes data in a table?
- A INSERT
- B None of the above
- C BROWSE
- D UPDATE
- E APPEND
Explanation: The correct answer to the question is: UPDATE
Question 5: The PROJECT command will create new table that has
- A both (a) and (b)
- B all the fields of master table
- C more rows than the original table
- D more fields than the original table
- E None of the above
Explanation: The correct answer to the question is: None of the above
Question 6: A file that is organized in uniform format is formally referred to as a _____ or a database file.
- A None of the above
- B Structured data file
- C Record
- D Database
- E Document
Explanation: The correct answer to the question is: Structured data file
Question 7: The activity of a file
- A if high, reduces processing efficiency for sequential and nonsequential files
- B is a low percentages of number of records added or deleted from a file
- C is a measure of the percentage of existing records updated during a run
- D None of the above.
- E refers to how closely the files fits into the allocated
Explanation: The correct answer to the question is: is a low percentages of number of records added or deleted from a file
Question 8: In SQL, the CREATE VIEW command is used
- A None of the above
- B to define a view of one or more tables or views
- C to recompile view
- D to recompile a table
- E to create a trigger
Explanation: The correct answer to the question is: to define a view of one or more tables or views
Question 9: The language used in application programs to request data from the DBMS is referred to as the
- A All of the above
- B DDL
- C None of the above
- D DML
- E query language
Explanation: The correct answer to the question is: DML
Question 10: The distinguishable parts of a record are called
- A data
- B database
- C fields
- D files
- E None of the above
Explanation: The correct answer to the question is: fields
Question 11: Large collections of files are called
- A databases
- B records
- C fields
- D file system
- E None of the above
Explanation: The correct answer to the question is: databases
Question 12: A report generator is used to
- A All of the above
- B update files
- C data entry
- D None of the above
- E print files on paper
Explanation: The correct answer to the question is: print files on paper
Question 13: The main idea behind computer files is that it is convenient to
- A create them
- B store information together
- C arrange them
- D None of the above
- E access them
Explanation: The correct answer to the question is: store information together
Question 14: In SQL, GRANT command is used to
- A allow user to access databases
- B grant system privileges, roles, and object privileges to uses and roles
- C choose auditing for specific SQL commands
- D allow user to create databases
- E None of the above
Explanation: The correct answer to the question is: grant system privileges, roles, and object privileges to uses and roles
Question 15: The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
- A data item
- B field
- C record
- D file
- E data base
Explanation: The correct answer to the question is: record
Question 16: Data encryption techniques are particularly useful for
- A protecting data in data communication systems
- B None of the above
- C reducing storage space requirements
- D improving data integrity
- E All of the above
Explanation: The correct answer to the question is: protecting data in data communication systems
Question 17: Which of the following is not true of the traditional approach to information processing?
- A Programs are dependent on the files
- B It is file-oriented
- C There is common sharing of data among the various applications
- D All of the above are true
- E It is inflexible
Explanation: The correct answer to the question is: There is common sharing of data among the various applications
Question 18: The model for a record management system might be
- A handwritten list
- B a Rolodex card file
- C a business form
- D None of the above
- E All of the above
Explanation: The correct answer to the question is: All of the above
Question 19: The Management Information system (MIS) structure with one main computer system is called a
- A hierarchical MIS structure
- B centralized MIS structure
- C distributed MIS structure
- D decentralized MIS structure
- E None of the above
Explanation: The correct answer to the question is: centralized MIS structure
Question 20: In order to use a record management system
- A Both (a) and (b)
- B None of the above
- C You need to understand the model the record management system uses.
- D You need to understand the low-level details of how information in stored
- E All of the above
Explanation: The correct answer to the question is: You need to understand the model the record management system uses.
Question 21: A _____ Contains fields of data about one entity.
- A None of the above
- B Document
- C File
- D Record
- E Fields
Explanation: The correct answer to the question is: Record
Question 22: In SQL, which command is used to add new rows to a table?
- A APPEND
- B ADD ROW
- C ALTER TABLE
- D None of the above
- E INSERT
Explanation: The correct answer to the question is: INSERT
Question 23: Which of the following is not characteristic of a relational database model?
- A complex logical relationships
- B None of the above
- C records
- D tables
- E treelike structure
Explanation: The correct answer to the question is: treelike structure
Question 24: Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
- A data manipulation language
- B transaction log
- C report writer
- D query language
- E None of the above
Explanation: The correct answer to the question is: transaction log
Question 25: A data dictionary is a special file that contains
- A the widths of all fields in all files
- B the names of all fields in all files
- C the data types of all fields in all files
- D All of the above
- E None of the above
Explanation: The correct answer to the question is: All of the above
Question 26: Queries to a database
- A can use aggregate functions like SUM and COUNT
- B are written in English
- C None of the above
- D All of the above
- E both (a) and (b)
Explanation: The correct answer to the question is: can use aggregate functions like SUM and COUNT
Question 27: A race condition occurs when
- A two users of the DBMS are interacting with different files at the same time
- B All of the above
- C both (a) and (b)
- D None of the above
- E Two concurrent activities interact to cause a processing error
Explanation: The correct answer to the question is: Two concurrent activities interact to cause a processing error
Question 28: What is the name given to the database management system which is able to handle full text data, image data, audio and video?
- A Graphics media
- B Hypertext
- C None of the above
- D Full media
- E Multimedia
Explanation: The correct answer to the question is: Multimedia
Question 29: Which of the following command(s) is(are) used to recompile a stored procedure in SQL?
- A None of the above
- B None of the above
- C ALTER PROCEDURE
- D COMPILE PROCEDURE
- E MODIFY PROCEDURE id) All of the above
Explanation: The correct answer to the question is: ALTER PROCEDURE
Question 30: Which of the following is not a relational database?
- A None of the above
- B Reflex
- C FoxPro
- D 4th Dimension
- E dBASE IV
Explanation: The correct answer to the question is: Reflex
Question 31: A list in alphabetical order
- A is in descending order
- B is the result of a sort operation
- C both (b) and (c)
- D is in ascending order
- E None of the above
Explanation: The correct answer to the question is: both (b) and (c)
Question 32: An indexing operation
- A None of the above
- B establishes an index for a file
- C sorts file using two keys
- D both (b) and (c)
- E sorts a file using a single key
Explanation: The correct answer to the question is: establishes an index for a file
Question 33: The model for a _____ resembles the hierarchical model in many respects.
- A Hierarchical database
- B Relational database
- C Distributed database
- D None of the above
- E Network database
Explanation: The correct answer to the question is: Network database
Question 34: A compound key
- A is a combination of each unique key
- B both (a) and (b)
- C uniquely identifies an item in a list
- D None of the above
- E is made up a several pieces of information
Explanation: The correct answer to the question is: both (a) and (b)
Question 35: When you have finished entering information into a form
- A All of the above
- B the template is written to the data file
- C the contents of the form are written to the data file
- D the contents of the form can be printed
- E None of the above
Explanation: The correct answer to the question is: the contents of the form are written to the data file
Question 36: Which of the following is a serious problem of file management systems?
- A All of the above
- B program dependence
- C data redundancy
- D difficult to update
- E lack of data independence
Explanation: The correct answer to the question is: All of the above
Question 37: Characteristic(s) of a distributed MIS structure is
- A computers supporting local DP operations
- B All of the above
- C interactive sharing of the workload
- D None of the above
- E a multiprocessing environment
Explanation: The correct answer to the question is: All of the above
Question 38: A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.
- A None of the above
- B Network
- C Relational
- D Hierarchical
- E Object-Oriented
Explanation: The correct answer to the question is: Relational
Question 39: A command that lets you change one or more fields in a record is
- A Insert
- B None of the above
- C Modify
- D Look-up
- E All of the above
Explanation: The correct answer to the question is: Modify
Question 40: What is the language used by most of the DBMSs for helping their users to access data?
- A High level language
- B 4GL
- C None of the above
- D SQL
- E Query language
Explanation: The correct answer to the question is: Query language
Question 41: Each of data files has a _____ that describe the way the data is stored in the file.
- A File structure
- B Records
- C Database
- D Fields
- E None of the above
Explanation: The correct answer to the question is: File structure
Question 42: In SQL, which command is used to add a column/integrity constraint to a table
- A None of the above
- B ALTER TABLE
- C ADD COLUMN
- D INSERT COLUMN
- E MODIFY TABLE
Explanation: The correct answer to the question is: ALTER TABLE
Question 43: If a calculation is embedded in a form
- A the calculations are stored with the form
- B the result of the calculations are printed in report
- C All of the above
- D None of the above
- E the result of the calculations are stored with the form
Explanation: The correct answer to the question is: the calculations are stored with the form
Question 44: A number of related records that are treated as a unit is called
- A field
- B data
- C file
- D batch
- E None of the above
Explanation: The correct answer to the question is: file
Question 45: In any hierarchy of data organization, the smallest entity to be processed as a single unit is called
- A data record
- B data file
- C data field
- D database
- E None of the above
Explanation: The correct answer to the question is: data field
Question 46: A computer file contains several records. What does each record contain?
- A Fields
- B None of the above
- C Words
- D Database
- E Bytes
Explanation: The correct answer to the question is: Fields
Question 47: The highest level in the hierarchy of data organization is called
- A data file
- B None of the above
- C data bank
- D data record
- E database
Explanation: The correct answer to the question is: database
Question 48: An operation that will increase the length of a list is
- A All of the above
- B Modify
- C None of the above
- D Insert
- E Look-up
Explanation: The correct answer to the question is: Insert
Question 49: Which of the following hardware components is the most important to the operation of a database management system?
- A plotter
- B high-resolution video display
- C high speed, large-capacity disk
- D mouse
- E printer
Explanation: The correct answer to the question is: high speed, large-capacity disk
Question 50: In SQL, which of the following is not a data Manipulation Language Commands?
- A SELECT
- B UPDATE
- C DELETE
- D CREATE
- E None of the above
Explanation: The correct answer to the question is: CREATE