1. In an Object Oriented database, we must implement object identifications (OIDs) which are abstracted, internally created, immutable, unique hexidecimal addresses of the database.

a. True

b. False

2. The only places that data is found in an object oriented database are atoms and tuples.

a. True

b. False

3. A set of constructors for objects in an object-oriented database are used to construct atoms, tuples, sets, lists and arrays. For every value that is not atomic, the dbms constructs a tuple, a list, an array or a pair that holds only OIDs .

a. True

b. False

4.In an Object Oriented DBMS

a. objects can be defined to be significant or persistent

b. objects of arbitrary complexity can be subdivided

c. objects maintain a real-world correspondence to the world being modeled

d.all of the above

5.To add a field to a table that is already a part of my database, I would use the ALTER command in SQL.

a. True

b. False

6. SQL is a language with certain syntax and grammar developed at Microsoft for the implementation of databases.

a. True

b. False

7. SQL is a procedural language.

a. True

b. False

8. SQL supports VDL, MDL HTML and SDL languages of a DBMS

a. True

b. False

9.In the WHERE clause of an SQL query, only the Booleans for joins should be specified.

a. True

b. False

10.JOIN is an operation that requires tables of the same real world type.

a. True

b. False

11. An aggregate query in SQL requires the creation of an alias to hold the results of an aggregate operation.

a. True

b. False

12.The SQL key word phrase ORDER BY is used with aggregate queries to summarize the aggregate results for each value of the field being ordered.

a. True

b. False

13. Normalization is used to reduce redundant values.

a. True

b. False

14.A functional dependency is a way of joining two sets of attributes from a database.

a. True

b. False

15.The key values in a functional dependency statement are listed to the left of a right-pointing arrow.

a. True

b. False

16.The expression X Y is read Y is functionally dependent on X.

a. True

b. False

17.The closure set, F, is the set of functional dependencies that constitute the entire original relation.

a. True

b. False

18.Transitive dependencies are not allowed in 2nd Normal Form.

a. True

b. False

19.A distributed database is a collection of data that belongs logically to multiple systems and physically to one site.

a. True

b. False

20.Advantages of a distributed system include increased reliability and complexity of system maintenance.

a. True

b. False

21.DBMSs must provide extra communication software to operate client/server architectures in distributed systems.

a. True

b. False

22.A Fragmentation Schema is simply the set of all fragments that satisfies the condition that the whole database can be reconstructed via Join or Outer Join operations on those fragments.

a. True

b. False

23.An Allocation Schema is a map of all the fragments at their physical locations. Replication is not shown in an Allocation Schema.

a. True

b. False

24.Write-intensive databases need full replication.

a. True

b. False