TRUE/FALSE questions:

1			A database is a collection of files.
			A)	True
			B)	False
2			A descriptive field can not be a primary key.
			A)	True
			B)	False
3			The number of logical records included in a single read or write operation is known as a blocking factor.
			A)	True
			B)	False
4			Data warehouse stores data extracted from strategic databases.
			A)	True
			B)	False
5			A good data model has no redundant data attributes. This means that each data attribute describes at most one entity.
			A)	True
			B)	False
6			Replication of data refers to the physical duplication of entire tables to multiple locations.
			A)	True
			B)	False
7			Information architecture refers to the database technology, such as the database engine, database utility, and database case tools.
			A)	True
			B)	False
8			SQL provides a RETRIEVE command to select specific records from a table based on specific criteria.
			A)	True
			B)	False
9			The Delete:Restrict rule of referential integrity specifies that a deletion of a record in the table must be disallowed until any matching records are deleted from a related table.
			A)	True
			B)	False
10			A referential integrity error will occur when a foreign key value in one table has no matching primary key value in the related table.
			A)	True
			B)	False

Multiple Choice questions:

11			The CustomerID field in a customer table can not be left blank. This is an example of:
			A)	domain integrity
			B)	logical integrity
			C)	referential integrity
			D)	physical integrity
			E)	none of the above
12			A table containing records that describe business events is:
			A)	transaction file
			B)	document file
			C)	master file
			D)	audit file
			E)	archival file
13			A language used by a DBMS to define a database or a view of a database is:
			A)	DML
			B)	DLL
			C)	DCL
			D)	DDL
			E)	none of the above
14			Many relational DBMSs can automatically enforce Delete:Cascade rule of referential integrity using
			A)	triggers
			B)	stored procedures
			C)	views
			D)	DCL
			E)	DDL
15			To delete an existing record from a database, you would use:
			A)	DCL
			B)	DDL
			C)	DML
			D)	DLL
			E)	none of the above
16			Which of the following is(are) criteria for producing a quality data model?
			A)	a good data model is complex
			B)	a good data model is flexible
			C)	a good data model is redundant
			D)	a good data model is adaptable to future needs
			E)	both (b) and (d)
17			Which of the following is(are) goals of database design?
			A)	a DB should be reliable
			B)	a DB should be scalable
			C)	a DB should support the business requirements of the information system
			D)	a DB should provide for efficient storage
			E)	all of the above
18			Which form of distribution is the simplest and the easiest to maintain?
			A)	vertical distribution
			B)	centralization
			C)	replication
			D)	horizontal distribution
			E)	hierarchical distribution
19			If two records in a student table would have the same value for StudentID, this would violate:
			A)	key integrity
			B)	referential integrity
			C)	table integrity
			D)	physical integrity
			E)	field integrity
20			Which of the following is NOT a valid deletion rule?
			A)	Delete:Restrict
			B)	Delete:Default
			C)	Delete:Cascade
			D)	Delete:Set Null
			E)	none of the above