Oracle 1Z0-071 Quiz 39 Topic 10 Questions 191-195

Question: 1

View the Exhibit and examine the data in the PRODUCTS table.

q1_1Z0-071

You must display product names from the PRODUCTS table that belong to the 'Software/other' category with minimum prices as either $2000 or $4000 and with no unit of measure.

You issue this query:

q1_1Z0-071

Which statement is true?

AIt executes successfully but returns no result.

BIt executes successfully and returns the required result.

CIt generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.

DIt generates an error because the condition specified for the PROD_CATEGORY column is not valid.

Show Answer

Question: 2

Examine the structure of the EMPLOYEES table.

q2_1Z0-071

You must display the maximum and minimum salaries of employees hired 1 year ago.

Which two statements would provide the correct output? (Choose two.)

ASELECT MIN(Salary) minsal, MAX(salary) maxsalFROM employeesWHERE hire_date < SYSDATE-365GROUP BY MIN(salary), MAX(salary);

BSELECT minsal, maxsalFROM (SELECT MIN(salary) minsal, MAX(salary) maxsalFROM employeesWHERE hire_date < SYSDATE-365)GROUP BY maxsal, minsal;

CSELECT minsal, maxsalFROM (SELECT MIN(salary) minsal, MAX(salary) maxsalFROM employeesWHERE hire_date < SYSDATE-365GROUP BY MIN(salary), MAX(salary));

DSELECT MIN(Salary), MAX(salary)FROM (SELECT salary FROMemployeesWHERE hire_date < SYSDATE-365);

Show Answer

Question: 3

Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)

AThe nested query executes after the outer query returns the row.

BThe nested query executes first and then the outer query executes.

CThe outer query executes only once for the result returned by the inner query.

DEach row returned by the outer query is evaluated for the results returned by the inner query.

Show Answer

Question: 4

Which two statement are true regarding table joins available in the Oracle Database server? (Choose two.)

AYou can use the ON clause to specify multiple conditions while joining tables.

BYou can explicitly provide the join condition with a NATURAL JOIN.

CYou can use the JOIN clause to join only two tables.

DYou can use the USING clause to join tables on more than one column.

Show Answer

Question: 5

You issued this command:

SQL > DROP TABLE employees;

Which three statements are true? (Choose three.)

ASequences used in the EMPLOYEES table become invalid.

BIf there is an uncommitted transaction in the session, it is committed.

CAll indexes and constraints defined on the table being dropped are also dropped.

DThe space used by the EMPLOYEES table is always reclaimed immediately.

EThe EMPLOYEES table can be recovered using the ROLLBACK command.

FThe EMPLOYEES table may be moved to the recycle bin.

Show Answer

Oracle 1Z0-071 Quiz:39 Topic:10 Questions:191-195