Question 47

1. You issue this statement:

SQL> CREATE PUBLIC SYNONYM part FOR linda.product;

Which task was accomplished by this statement?

		A new segment object was created.
		A new object privilege was assigned.
		A new system privilege was assigned.
		The need to qualify an object name with its schema was eliminated.

0.5 points

Question 48

1. Which of the following is not a valid way to avoid search problems when you want to search for rows that have a specific date in a column thats defined with the DATE data type?

	a.	use the TRUNC function to truncate the time values from the date value in the column that youre searching
	b.	search for date values that fall between the day and the day after the date you want
	c.	use the TO_DATE function to remove the time values from the dates in each column

Question 50

1. With shadow paging, the commit operation involves all the following EXCEPT

	A.	write the log records out to disk
	B.	copy the current page table to disk
	C.	write modified database buffer pages to disk
	D.	make the current page table the new shadow page table

Question 52

1. Which of the following statements about mapping a union in an EE-R diagram to a relational schema is true?

	A.	The union can be represented using a single table can be includes all the supersets Ans. C
	B.	A surrogate key is always required
	C.	It is not possible to represent a union in a relational schema
	D.	The union can be represented as a table, with additional tables for the supersets

Question 56

1.

Which statement about error propagation is true?

	a.	An exception can propagate across remote procedure calls.
	b.	The RAISE; statement in an exception handler ends the current exception.
	c.	An exception raised inside an exception handler will not propagate to the enclosing block.
	d.	When an exception is raised in a called procedure, control goes to the exception section of that block.

0.5 points

Question 57

1. Which statements represent benefits of using the EXECUTE IMMEDIATE statement over the DBMS_SQL package?

(Choose all that apply.)

	a.	EXECUTE IMMEDIATE is simpler to use.
	b.	EXECUTE IMMEDIATE is faster than DBMS_SQL.
	c.	Client-side programs support EXECUTE IMMEDIATE .
	d.	Unlike DBMS_SQL , EXECUTE IMMEDIATE supports user-defined types.
	e.	SQL statements that are larger than 32 KB are supported by EXECUTE IMMEDIATE .