QUESTION 1

1. The CREATE TABLE command lets you define constraints when you use the CONSTRAINT keyword, known as a(n) _____ constraint.

	a.	cell
	b.	table
	c.	column
	d.	index

QUESTION 2

1. The _____ pseudo-column is used to select the next value from a sequence.

	a.	CURRVAL
	b.	NEXT
	c.	NEXTVAL
	d.	GET_NEXT

QUESTION 3

1. _____ serve as the intermediary between the user and the database.

	a.	Programming languages
	b.	Metadata
	c.	End-user data
	d.	DBMSs

QUESTION 4

1. _____ is a cursor attribute that returns TRUE if the last FETCH returned a row, and FALSE if not.

	a.	%ISOPEN
	b.	%FOUND
	c.	%ROWCOUNT
	d.	%NOTFOUND

QUESTION 5

1. The hierarchical data model was developed in the _____.

	a.	1960s
	b.	1970s
	c.	1980s
	d.	1990s

QUESTION 6

1. _____ is a relational set operator.

	a.	ALL
	b.	PLUS
	c.	EXCEPT
	d.	EXISTS

QUESTION 7

1. In Oracle, _____ retrieves the current value of a sequence.

	a.	VARCHAR2
	b.	NEXTVAL
	c.	CURRVAL
	d.	VARCHAR

QUESTION 8

1. The relational data model was developed in the _____.

	a.	1960s
	b.	1970s
	c.	1980s
	d.	1990s

QUESTION 9

1. A _____ is a block of code containing standard SQL statements and procedural extensions that is stored and executed at the DBMS server.

	a.	cursor-style process
	b.	statement-level trigger
	c.	base table
	d.	persistent storage module (PSM)

QUESTION 10

1. A(n) _____ is a restriction placed on the data.

	a.	relationship
	b.	attribute
	c.	entity
	d.	constraint