6.The textbook refers to four interrelated components of the database concept. Which of the following is not one of the components?
a.the Database Management System
b.the Database Administrator
c.the physical database
d.the conceptual database
7.Which of the following is not a responsibility of the Database Management System?
a.provide an interface between the users and the physical database
b.provide security against a natural disaster
c.ensure that the internal schema and external schema are consistent
d.authorize access to portions of the database
8.A description of the physical arrangement of records in the database is
a.the internal view
b.the conceptual view
c.the subschema
d.the external view
9.Which of the following may provide many distinct views of the database?
a.the schema
b.the internal view
c.the user view
d.the conceptual view
10.Users access the database
a.by direct query
b.by developing operating software
c.by constantly interacting with systems programmers
d.all of the above
11.The Data Definition Language
a.identifies, for the Database Management System, the names and relationships of all data elements, records, and files that comprise the database
b.inserts database commands into application programs to enable standard programs to interact with and manipulate the database
c.permits users to process data in the database without the need for conventional programs
d.describes every data element in the database
12.The Data Manipulation Language
a.defines the database to the Database Management System
b.transfers data to the buffer area for manipulation
c.enables application programs to interact with and manipulate the database
d.describes every data element in the database
13.Which statement is not correct? A query language like SQL
a.is written in a fourth-generation language
b.requires user familiarity with COBOL
c.allows users to retrieve and modify data
d.reduces reliance on programmers
14.Which duty is not the responsibility of the Database Administrator?
a.to develop and maintain the Data Dictionary
b.to implement security controls
c.to design application programs
d.to design the subschema
15.In a hierarchical model
a.links between related records are implicit
b.the way to access data is by following a predefined data path
c.an owner (parent) record may own just one member (child) record
d.a member (child) record may have more than one owner (parent)
