Oracle 1Z0-071 Quiz 15 Topic 10 Questions 71-75

Question: 1

You issued this command:

q1_1Z0-071

Which three statements are true?

AViews referencing HR.EMPLOYEES are dropped.

BAll constraints defined on HR.EMPLOYEES are dropped.

CSequences used to populate columns in the HR.EMPLOYEES table are dropped.

DThe HR.EMPLOYEES table may be moved to the recycle bin.

EAll indexes defined on HR.EMPLOYEES are dropped.

FSynonyms for HR.EMPLOYEES are dropped.

Show Answer

Question: 2

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.

You want to display the date of the first Monday after the completion of six month since hiring.

The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day of the week.

Which query can be used?

ASELECT emp_id, NEXT_DAY (MONTHS_BETWEEN (hire_date, SYSDATE), 6) FROM employees;

BSELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 'MONDAY') FROM employees;

CSELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY('MONDAY') FROM employees;

DSELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;

Show Answer

Question: 3

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS?

ACURRENT_TIMESTAMP returns the same date as CURRENT_DATE.

BCURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds.

CSYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server.

DSYSDATE can be used in expressions only if the default date format is DD-MON-RR.

ESYSDATE can be queried only from the DUAL table.

FCURRENT_DATE returns the current date and time as per the session time zone.

Show Answer

Question: 4

Examine this description of the PRODUCTS table:

q4_1Z0-071

You successfully execute this command:

q4_1Z0-071

Which two statements execute without errors?

q4_1Z0-071

AOption A

BOption B

COption C

DOption D

Show Answer

Question: 5

View the Exhibit and examine the structure of the PRODUCT table.

q5_1Z0-071

Which two tasks would require subqueries? (Choose two.)

Adisplay all products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable

Bdisplay the total number of products supplied by supplier 102 and have product status as 'OBSOLETE'

Cdisplay the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE.

Ddisplay suppliers whose PROD_LIST_PRICE is less than 1000

Edisplay the minimum PROD_LIST_PRICE for each product status

Show Answer

Oracle 1Z0-071 Quiz:15 Topic:10 Questions:71-75