Oracle 1Z0-071 Quiz 5 Topic 1 Questions 21-25

Question: 1

Which two are true about constraints?

AA constraint can be disabled even if the constrained column contains data.

BConstraints are enforced only during insert operations.

CA column with a FOREIGN key constraint can never contain a null value.

DA column with a unique constraint can contain a null value.

EAll constraints can be defined at the table or column level.

Show Answer

Question: 2

Examine the description of the EMPLOYEES table:

q2_1Z0-071

You write this falling statement:

SELECT dept-no AS department_id MAX (salary) AS max-sal

FROM employees

WHERE salary > 10000

GROUP BY department_id

ORDER BY max-sal:

Which clause causes the error?

AWHERE

BSELECT

CORDER BY

DGROUP BY

Show Answer

Question: 3

Which two are true about savepoints?

AAfter issuing a savepoint, you cannot roll back the complete transaction.

BYou can commit updates done between two savepoints without committing other updates In the current transaction.

CAfter issuing a savepoint, you can roll back to the savepoint name within the current transaction.

DThey make uncommitted updates visible to other sessions owned by the? same user.

EA rollback to savepoint command issued before the start of a transaction results In an error.

FThey make uncommitted updates visible to sessions owned by other users.

Show Answer

Question: 4

Examine the description of the EMPLOYERS table:

q4_1Z0-071

Examine these requirements:

Disable the manager ID and salary of the lowest paid employees for that manager.

Exclude anyone whose manager is not known.

Exclude any managers where the minimum salary is 6000 or less.

Sort the output by minimum salary with the highest salary shown first.

Which statement will do this?

ASELECT manager_id, MTN(salary)
FROM employees
WHERE manager_ id IS NOT NULL
GROUP BY manager_id
HAVING MlN (salary) > 6000
ORDER BV MlN (salary);

BSELECT managar_id, MIN (salary)
FROM employees
HAVING MIN(salary) > 6000
WHERE manager_id IS NOT NULL
GROUP BY manager_id
ORDER BY MTN(salary) DESC;

CSELECT manager_id, HTN(salary)
FROM employees
WHERE manager_id IS NOT NULL
HAVING MIN (salary) > 6000
GROUP BY manager_id
ORDEU BY MIN (salary) DESC;

DSELECT manager_id, MIN(salary)
FROM employees
WHERE manager_id IS NOT NULL
AND MIN(salary) > 6000
GROUP BY manager_id
ORDER BY MlN (salary) DESC;

Show Answer

Question: 5

Examine the contents of the EMP table:

q5_1Z0-071

What is the result?

q5_1Z0-071

AIt will return the six employees earning the highest salaries. In descending order.

BIt will return the six employees earning the lowest salaries. In ascending order.

CIt will return the five employee's earning the lowest salaries. In ascending order.

DIt will return the five employees earning the highest salaries. In descending order.

Show Answer

Oracle 1Z0-071 Quiz:5 Topic:1 Questions:21-25