Free Access Oracle.1z0-071.v2022-08-30.q239 Practice Test (Page 44)

Question 211

Which two statements are true regarding a SAVEPOINT? (Choose two.)

A.Only one SAVEPOINTmay be issued in a transaction

B.A SAVEPOINTdoes not issue a COMMIT

C.Rolling back to a SAVEPOINT can undo a TRUNCATEstatement

D.Rolling back to a SAVEPOINTcan undo a DELETEstatement

E.Rolling back to a SAVEPOINTcan undo a CREATE INDEX statement

Question 212

You execute the SQL statement:

What is the outcome?

A.It fails because the condition for the CNAMESconstraint is not valid.

B.It succeeds and an index is created for CITIZEN_ID.

C.It It succeeds and CITYcan contain only 'SEATTLE'or null for all rows.

D.It fails because the NOT NULL and DEFAULToptions cannot be combined for the same column.

Question 213

Examine the structure of the EMPLOYEES table.

You must display the details of employees who have manager with MANAGER_ID 100, who were hired in the past 6 months and who have salaries greater than 10000.

A.(SELECT last_name, hire_date, salary
FROM employees
WHERE salary > 10000
UNION ALL
SELECT last_name, hire_date, salary
FROM employees
WHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id = 100)) UNION SELECT last_name, hire_date, salary
FROM employees
WHERE hire_date > SYSDATE -180;

B.SELECT last_name, hire_date, salary
FROM employees
WHERE manager_id = (SELECT employee_id FROM employees WHERE employee_id = 100) UNION ALL (SELECT last_name, hire_date, salary
FROM employees
WHERE hire_date > SYSDATE -180
INTERSECT
SELECT last_name, hire_date, salary
FROM employees
WHERE salary > 10000);

C.SELECT last_name, hire_date, salary
FROM employees
WHERE manager_id = (SELECT employee_id FROM employees WHERE employee_id = '100') UNION SELECT last_name, hire_date, salary
FROM employees
WHERE hire_date > SYSDATE -180
INTERSECT
SELECT last_name, hire_date, salary
FROM employees
WHERE salary > 10000;

D.SELECT last_name, hire_date, salary
FROM employees
WHERE salary > 10000
UNION ALL
SELECT last_name, hire_date, salary
FROM employees
WHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id = 100) INETRSECT SELECT last_name, hire_date, salary
FROM employees
WHERE hire_date > SYSDATE- 180;

Question 214

View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index-organized table. (Choose two.)

Evaluate this SQL statement:
ALTER TABLE emp
DROP COLUMN first_name;
Which two statements are true?

A.The drop of the FIRST_NAME column can be rolled back provided the SET UNUSED option is added to the SQL statement.

B.The FIRST_NAME column would be dropped provided at least one column remains in the table.

C.The FIRST_NAME column can be dropped even if it is part of a composite PRIMARY KEY provided the CASCADE option is added to the SQL statement.

D.The FIRST_NAME column would be dropped provided it does not contain any data.

Question 215

Which two tasks can be performed by using Oracle SQL statements? (Choose two.)

A.changing the password for an existing database user

B.connecting to a database instance

C.querying data from tables in different databases

D.starting up a database instance

E.executing operating system (OS) commands in a session

Other Version: 4124Oracle.1z0-071.v2025-03-22.q314; 7454Oracle.1z0-071.v2024-10-24.q196; 3660Oracle.1z0-071.v2023-10-02.q276; 3039Oracle.1z0-071.v2023-05-08.q154; 7492Oracle.1z0-071.v2022-09-21.q298; 25883Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 121Adobe.AD0-E911.v2026-09-12.q35; 117Google.ADP.v2026-09-11.q22; 130AIChE.CCPSC.v2026-09-11.q41; 130Scrum.PSPO-III.v2026-09-10.q23; 220Scrum.PSPO-I.v2026-09-09.q157; 188ScaledAgile.SAFe-SPC.v2026-09-08.q108; 147Oracle.1Z0-1033-26.v2026-09-08.q43; 220Pegasystems.PEGACPSSA25V1.v2026-09-08.q144; 166BCI.CBCI.v2026-09-07.q89; 208Salesforce.Plat-Admn-202.v2026-09-07.q170

Question 211

Question 212

Question 213

Question 214

Question 215

Download PDF File