Given the New Whatcom Library Checkout List shown above, there is no way to know if the
borrowers owe fines for past due books. This is an example of a ____.
A -
missing data problem
B -
data inconsistency problem
C -
data deletion problem
D -
data addition problem
2-
Identity the advantages of a Network Database Model
A -
All of them
B -
The model enforces data integrity
C -
The model achieves sufficient data independence
D -
The relationships are easier to implement
3-
Identity the advantages of a Network Database Model
A -
The relationships are easier to implement
B -
The model enforces data integrity
C -
The model achieves sufficient data independence
D -
All of them
4-
If a system can enforce referential integrity, then this ensures that
A -
a non-null foreign key attribute always refers to another record
B -
a record is always referred to from another record
C -
a foreign key attribute in a record always refers to another record which does not contain nulls
D -
a record can never contain a null value for a foreign key attribute
5-
In the Entity-Relationship data model, all instances of entity of a given type are grouped into:
A -
entity attributes
B -
entity classes
C -
class objects
D -
entity objects
6-
In general, database objects should be owned by the ____. *
A -
System Administrator(sa)
B -
Database Owner(dbo)
C -
DataBase Admistrator(DBA)
D -
Database Management System(DBMS)
7-
In a nested query, which query is evaluated first?
A -
Ưhichever query is selected to execute first by the user
B -
Both are evaluated simultaneously
C -
The innermost query
D -
The outermost query
8-
In order make sure the database redesign is working properly during the redesign testing process, a
means must be created to ____. *
A -
recover all test databases to their original state
B -
reverse engineer all test databases
C -
graph dependencies in all test databases
D -
All of these answers
9-
In Hierarchical database model ____ are used to relate parent and children
A -
Pointers
B -
Dollars
C -
No relation sign
D -
Line
10-
In a database processing system, the DBMS: *
A -
processes reports
B -
processes menu
C -
processes queries
D -
the requests and returns the results to the application program and also controls and manages the database