Name:     ID: 
 
Email: 

CPT242 Test 1 Summer 2008

True/False
Indicate whether the statement is true or false.
 

 1. 
Hierarchical databases are now obsolete.
 

 2. 
One way of controlling user access of a database is to limit the command set.
 

 3. 
Costs are both an advantage and a disadvantage of using a database.
 

 4. 
SQL incorporates both DDL and DML.
 

 5. 
The information protection of having your data pooled together in a database makes the data more vulnerable to catastrophic events.
 

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 6. 
WHICH OF THE FOLLOWING ARE NOT ADVANTAGES OF A DATABASE SYSTEM?
a.
SEQUENTIAL ACCESS EFFICIENCY
c.
UNIFORM SECURITY AND PRIVACY
b.
MINIMAL DATA REDUNDANCY
d.
EASIER ENFORCEMENT OF STANDARDS
 

 7. 
A DATABASE IS A COLLECTION OF DATA THAT IS SHARED AND ..
      
a.
 UNIFORM
c.
INTEGRATED
b.
ACCESSIBLE
d.
INDEPENDENT
 

 8. 
WHICH OF THE FOLLOWING ARE DATABASE MODELS?
     
a.
NETWORK
c.
RELATIONAL
b.
HIERARCHICAL
d.
ALL OF THE ABOVE
 

 9. 
An application where only one user accesses the database at a given time is an example of a(n) _________ .
a.
single-user database application
c.
e-commerce database application
b.
multiuser database application
d.
data mining database application
 

 10. 
Because it contains a description of its own structure, a database is considered to be ____________ .
a.
described
c.
self-describing
b.
metadata compatible
d.
an application program
 

 11. 
Which of the following products implemented the CODASYL DBTG model?
a.
IDMS
c.
dBase-II
b.
DB2
d.
R:base
 

 12. 
Which of the following schema represents the user view?
a.
External schema
c.
Internal schema
b.
Conceptual schema
d.
Physical schema
 

 13. 
Data definition commands are sometimes called:
a.
DDL.
c.
SQL.
b.
DML.
d.
None of the above
 

 14. 
Query and update commands are sometimes called:
a.
DDL.
c.
SQL.
b.
DML.
d.
None of the above.
 

 15. 
What allowed database technology to move from an organizational context to a personal-computing context?
a.
The combination of microcomputers and distributed database processing
c.
The development of the Web
b.
Object-Oriented DBMS
d.
The combination of microcomputers, the relational model, and improved user interfaces
 

 16. 
The data about the structure of a database is called:
a.
application metadata.
c.
metadata.
b.
user data.
d.
indexes.
 

 17. 
Facts about objects, people, or entities is/are called:
a.
Information
c.
Metadata
b.
Data
d.
none of the above
 

 18. 
Which of the following is not true about manual file processing?
a.
data is separated and isolated
c.
File definitions are independent
b.
Files are often incompatible
d.
None of the above
 

 19. 
Which of the following is not an advantage of a DBMS?
a.
Reduced data redundency
c.
Information protection
b.
Faster response time
d.
None of the above
 

 20. 
When should you use a Database?
a.
Application needs are constantly changing
c.
Data elements are shared amomg users
b.
Rapid access is required
d.
All of the above
 

 21. 
Which of the following is not considered one of the 3 levels of databases?
a.
Workgroup
c.
Distributed
b.
Personal
d.
Organizational
 

 22. 
Which of the following database models may be entered from the top node?
a.
Hierarchical
c.
Relational
b.
Network
d.
Object
 

 23. 
“Many to Many” relationships are implementable in which of the following models?
a.
Hierarchical
c.
Relational
b.
Network
d.
None of the above
 

 24. 
In which of the following models is a an entity not allowed to be both a parent and a child?
a.
Relational
c.
Limited Network
b.
Simple Network
d.
None of the above
 

 25. 
Which of the following is not considered to be a component of a DBMS?
a.
Hardware
c.
Procedures
b.
Software
d.
None of the above
 



 
         Start Over