Free Access Oracle.1z1-071.v2025-05-13.q352 Practice Test (Page 33)

Question 156

Examine these statements:

Which two are true?

A.Both foreign key constraint definition must be removed from the CREATE statements, and be added with ALTER TABLE statements once both tables are created, for the two CREATE TABLE statements to execute successfully in the order shown.

B.The create TABLE EMP statement must precede the create table DEPT statement for all three statements to execute successfully.

C.The DEPTNO column in the EMP table will be able to contain null values.

D.All three statements execute successfully in the order shown.

E.The MGR column In the DEPT table will not be able to contain null values.

F.The DEPT_FKEY constraint definition must be removed from the CREATE TABLE DEPT statement. and the added with an D. ALTER statement once both tables are created, for the two CREATE TABLE statements to execute successfully in the order shown.

Question 157

Choose the best answer.
Examine the description of the EMPLOYEES table:

Which query is valid?

A.SELECT dept_id,AVG(MAX(salary)) FROM employees GROUP BY dapt_id;

B.SELECT dept_id,MAX(AVG(salary)) FROM employees GROUP BY dept_id;

C.SELECT depe_id,join_date,SUM(salary) FROM employees GROUP BY dept_id:

D.SELECT dept_id, join_date,SUM(salary) FROM employees GROUP BY dept_id, join_date;

Question 158

Which three statements are correct regarding indexes? (Choose three.)

A.A non-deferrable PRIMARY KEYor UNIQUE KEYconstraint in a table automatically attempts to creates a unique index.

B.Indexes should be created on columns that are frequently referenced as part of any expression.

C.When a table is dropped, the corresponding indexes are automatically dropped.

D.For each DML operation performed, the corresponding indexes are automatically updated.

Question 159

Examine the structure of the MEMBERStable.

Which query can be used to display the last names and city names only for members from the states MO and MI?

A.SELECT last_name, city FROM members WHERE state LIKE 'M%';

B.SELECT last_name, city FROM members WHERE state IN ('MO', 'MI');

C.SELECT DISTINCT last_name, city FROM members WHERE state ='MO' OR state
='MI';

D.SELECT last_name, city FROM members WHERE state ='MO' AND state ='MI';

Question 160

Examine the structure of the EMPLOYEES table:

There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID.
You want to display the name, joining date, and manager for all employees. Newly hired employees are yet to be assigned a department or a manager. For them, 'No Manager' should be displayed in the MANAGER column.
Which SQL query gets the required output?

A.SELECT e.last_name, e.hire_date, NVL(m.last_name, 'No Manager') ManagerFROM employees e RIGHT OUTER JOIN employees mON (e.manager_id = m.employee_id);

B.SELECT e.last_name, e.hire_date, NVL(m.last_name, 'No Manager') ManagerFROM employees e JOIN employees mON (e.manager_id = m.employee_id);

C.SELECT e.last_name, e.hire_date, NVL(m.last_name, 'No Manager') ManagerFROM employees e NATURAL JOIN employees mON (e.manager_id = m.employee_id).

D.SELECT e.last_name, e.hire_date, NVL(m.last_name, 'No Manager') ManagerFROM employees e LEFT OUTER JOIN employees mON (e.manager_id = m.employee_id);

Other Version: 4631Oracle.1z1-071.v2022-04-30.q200; 36Oracle.Prepawayete.1z1-071.v2022-01-25.by.lauren.209q.pdf

Latest Upload: 257PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 370Nokia.4A0-113.v2026-05-01.q69; 403EC-COUNCIL.312-49v11.v2026-04-30.q214; 321Microsoft.MB-820.v2026-04-30.q101; 253Salesforce.MC-202.v2026-04-30.q57; 297BICSI.INSTC_V8.v2026-04-29.q53; 424NMLS.MLO.v2026-04-28.q82; 283NCARB.Project-Management.v2026-04-28.q27; 502EMC.D-AV-DY-23.v2026-04-27.q184; 1329ServiceNow.CSA.v2026-04-27.q483

Question 156

Question 157

Question 158

Question 159

Question 160

Download PDF File