1z0-071 Practice Test

Question 46

Which two are true about external tables that use the ORACLE_DATAPUMP access driver? (Choose two.)

1. When creating an external table, data can be selected only from a table whose rows are stored in database blocks.
2. Creating an external table creates a directory object.
3. When creating an external table, data can be selected from another external table or from a table whose rows are stored in database blocks.
4. Creating an external table creates a dump file that can be used by an external table in the same or a different database.
5. Creating an external table creates a dump file that can be used only by an external table in the same database.

Question 47

Examine the description of the EMPLOYEES table: Which statement will fail? A. B. C. D.

Question 48

Examine the data in the NEW_EMPLOYEES table: Examine the data in the EMPLOYEES table: You want to: 1. Update existing employee details in the EMPLOYEES table with data from the NEW_EMPLOYEES table. 2. Add new employee details from the NEW_EMPLOYEES table to the EMPLOYEES table. Which statement will do this? A. B. C. D.

Question 49

Examine the description of the EMPLOYEES table: For each employee in department 90 you want to display: 1. their last name 2. the number of complete weeks they have been employed The output must be sorted by the number of weeks, starting with the longest serving employee first. Which statement will accomplish this? A. B. C. D.

Question 50

Examine the description of the PRODUCT_DETAILS table: Which two statements are true? (Choose two.)

1. EXPIRY_DATE contains the SYSDATE by default if no date is assigned to it.
2. PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it.
3. PRODUCT_NAME cannot contain duplicate values.
4. EXPIRY_DATE cannot be used in arithmetic expressions.
5. PRODUCT_PRICE contains the value zero by default if no value is assigned to it.
6. PRODUCT_ID can be assigned the PRIMARY KEY constraint.