Free Access Oracle.1z0-071.v2025-03-22.q314 Practice Test (Page 7)

Question 26

Examine the description of the EMPLOYEES table:

Which statement will fail?

A.SELECT department_id, COUNT (*)
FROM employees
HAVING department_ id <> 90 AND COUNT(*) >= 3
GROUP BY department_id;

B.SELECT department_id, COUNT (*)
FROM employees
WHERE department_ id <> 90 AND COUNT(*) >= 3
GROUP BY department_id;

C.SELECT department_id, COUNT(*)
FROM employees
WHERE department_id <> 90 HAVING COUNT(*) >= 3
GROUP BY department_id;

D.SELECT department_id, COUNT(*)
FROM employees
WHERE department_id <> 90 GROUP BY department_id
HAVING COUNT(*) >= 3;

Question 27

Which two are true about external tables that use the ORACLE _DATAPUMP access driver?

A.Creating an external table creates a directory object.

B.When creating an external table, data can be selected only from a table whose rows are stored in database blocks.

C.When creating an external table, data can be selected from another external table or from a table whose rows are stored in database blocks.

D.Creating an external table creates a dump file that can be used by an external table in the same or a different database.

E.Creating an external table creates a dump file that can be used only by an external table in the same database.

Question 28

Examine the description of the EMPLOYEES table:

Which two queries return rows for employees whose manager works in a different department?

A.SELECT emp.*
FROM employees emp
WHERE NOT EXISTS (
SELECT NULL
FROM employees mgr
WHERE emp.manager id = mgr.employee_ id
AND emp.department_id<>mgr.department_id
);

B.SELECT emp. *
FROM employees emp
RIGHT JOIN employees mgr
ON emp.manager_ id = mgr. employee id
AND emp. department id <> mgr.department_ id
WHERE emp. employee_ id IS NOT NULL;

C.SELECT emp.*
FROM employees emp
LEFT JOIN employees mgr
ON emp.manager_ id = mgr.employee_ id
AND emp. department id < > mgr. department_ id;

D.SELECT emp. *
FROM employees emp
WHERE manager_ id NOT IN (
SELECT mgr.employee_ id
FROM employees mgr
WHERE emp. department_ id < > mgr.department_ id
);

E.SELECT emp. *
FROM employees emp
JOIN employees mgr
ON emp. manager_ id = mgr. employee_ id
AND emp. department_ id<> mgr.department_ id;

Question 29

An Oracle database server session has an uncommitted transaction in progress which updated 5000 rows in a table.
In which three situations does the transact ion complete thereby committing the updates?

A.When a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session

B.When a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT

C.When a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user, then issues a COMMIT

D.When the session logs out is successfully

E.When a CREATE INDEX statement is executed successfully in same session

F.When a COMMIT statement is issued by the same user from another session in the same database instance

Question 30

Which three statements are true about GLOBAL TEMPORARY TABLES?

A.A GLOBAL TEMPORARY TABLE can have only one index.

B.A GLOBAL TEMPORARY TABLE can have multiple indexes.

C.A GLOBAL TEMPORARY TABLE can be referenced in the defining query of a view.

D.A trigger can be created on a GLOBAL TEMPORARY TABLE.

E.A GLOBAL TEMPORARY TABLE cannot have a PUBLIC SYNONYM.

F.Data Manipulation Language (DML) on GLOBAL TEMPORARY TABLES generates no REDO.

Other Version: 7352Oracle.1z0-071.v2024-10-24.q196; 3577Oracle.1z0-071.v2023-10-02.q276; 2936Oracle.1z0-071.v2023-05-08.q154; 7363Oracle.1z0-071.v2022-09-21.q298; 6088Oracle.1z0-071.v2022-08-30.q239; 25794Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 175NAHQ.CPHQ.v2026-09-03.q481; 113SAP.C-S4CPB-2602.v2026-09-02.q7; 109Cisco.700-805.v2026-09-02.q86; 161MSSC.CLT-4.0.v2026-09-02.q43; 126Fitness.NCSF-CPT.v2026-09-02.q18; 174Google.Generative-AI-Leader.v2026-09-02.q77; 139PECB.ISO-14001-Lead-Auditor.v2026-09-01.q39; 126Google.GCP-DE.v2026-09-01.q27; 161Cisco.300-820.v2026-09-01.q105; 154Cisco.500-220.v2026-09-01.q72

Question 26

Question 27

Question 28

Question 29

Question 30

Download PDF File