SQL

-----------------------------------------

An example of a command a user would use when making changes to a PRODUCT table is _____.

		CHANGE PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
		ROLLBACK PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
		UPDATE PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
		EDIT PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';

-------------------------------------------------------------------------------------

TOO_MANY_ROWS exception can happen when SELECT INTO fails because it returns_______________.

		more than one row
		more than one column
		exactly 5 rows
		exactly 5 columns

-----------------------------------------------------------------------

In Oracle, _____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping.

		cursor-style processing
		embedded SQL
		Procedural Language SQL
		stored procedures

------------------------------------------------

A(n) _____ is the set of possible values for a given attribute.

		range
		identifier
		key
		domain

---------------------------------------------------------------------

Which of the following is true about the functional dependency (A, B) (C, D)?

		A and B together determine D.
		A is the determinant of C.
		C and D together determine A.
		A and B together are determined by C and D together.

----------------------------------------------------------

Which of the following is true of business rules?

		They can serve as a communication tool between the users and designers.
		They allow the designer to set company policies with regard to data.
		They provide a framework for the companys self-actualization.
		They allow the designer to develop business processes.

----------------------------------------------------------------

A(n)_______ is not associated with a table and stored as an object in an Oracle database.

		Trigger
		sequence
		Index
		view

----------------------------------------

The syntax for a left outer join is _____.

		SELECT column-list FROM table1 LEFT [OUTER] JOIN table2 ON join-condition
		SELECT column-list FROM table1 LEFT table2 [JOIN] WHERE join-condition
		SELECT column-list WHERE LEFT table1 = table 2
		SELECT column-list FROM table1 OUTER JOIN table2 LEFT WHERE join-condition

----------------------------------------------------------------

A(n) _____ join will select only the rows with matching values in the common attribute(s).

		outer
		full
		cross
		natural

----------------------------------------------

The SQL data manipulation command HAVING:

		restricts the selection of grouped rows based on a condition.
		restricts the selection of rows based on a conditional expression
		modifies an attributes values in one or more tables rows.
		groups the selected rows based on one or more attributes.