Free Access Oracle.1z1-071.v2022-04-30.q200 Practice Test (Page 30)

Question 141

Examine the description of the EMP_DETAILS table given below:

Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL TABLE?

A.You can alter the table to include the NOT NULL constraint on the EMP_IMAGE column.

B.An EMP_IMAGE column cannot be included in the ORDER BY clause.

C.You cannot add a new column to the table with LONG as the data type.

D.An EMP_IMAGE column can be included in the GROUP BY clause.

Question 142

View the Exhibit and examine the data in EMPand DEPTtables.

In the DEPTtable, DEPTNOis the PRIMARY KEY.
In the EMPtable, EMPNOis the PRIMARY KEYand DEPTNOis the FOREIGN KEYreferencing the DEPTNO column in the DEPTtable.
What would be the outcome of the following statements executed in the given sequence?
DROP TABLE emp;
FLASHBACK TABLE emp TO BEFORE DROP;
INSERT INTO emp VALUES (2, 'SCOTT', 10);
INSERT INTO emp VALUES (3, 'KING', 55);

A.Only the SECOND INSERTstatement would succeed because all the constraints except referential integrity constraints that reference other tables are retrieved automatically after the table is flashed back.

B.Both the INSERTstatements would fail because the constraints are automatically retrieved when the table is flashed back.

C.Both the INSERTstatements would succeed because none of the constraints on the table are automatically retrieved when the table is flashed back.

D.Only the first INSERTstatement would succeed because all constraints except the primary key constraint are automatically retrieved after a table is flashed back.

Question 143

View the exhibit and examine the structure of the EMPLOYEES table.

You want to select all employees having 100 as their MANAGER_ID manages and their manager.
You want the output in two columns: the first column should have the employee's manager's LAST_NAME and the second column should have the employee's LAST_NAME.
Which SQL statement would you execute?

A.SELECT m.last_name "Manager", e.last_name "Employee"FROM employees m JOIN employees eON m.employee_id = e.manager_idWHERE m.manager_id=100;

B.SELECT m.last_name "Manager", e.last_name "Employee"FROM employees m JOIN employees eWHERE m.employee_id = e.manager_id AND e.manager_id=100

C.SELECT m.last_name "Manager", e.last_name "Employee"FROM employees m JOIN employees eON m.employee_id = e.manager_idWHERE e.manager_id=100;

D.SELECT m.last_name "Manager", e.last_name "Employee"FROM employees m JOIN employees eON e.employee_id = m.manager_idWHERE m.manager_id=100;

Question 144

SCOTTis a user in the database.
Evaluate the commands issued by the DBA:

Which statement is true regarding the execution of the above commands?

A.Statement 3 would not execute because role and system privileges cannot be granted together in a single GRANTstatement.

B.Statement 2 would not execute because system privileges and object privileges cannot be granted together in a single GRANTcommand.

C.Statement 1 would not execute because the IDENTIFIED BY <password>clause is missing.

D.Statement 1 would not execute because the WITH GRANToption is missing.

Question 145

Examine the description of the PROMOTIONStable:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)
SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM

A.SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;

B.ORDER BY 1;
SELECT promo_cost, promo_category FROM promotions ORDER BY 1;

C.promotions ORDER BY 1;
SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

D.SELECT DISTINCT promo_cost ||' in '|| DISTINCT promo_category FROM promotions

Other Version: 1039Oracle.1z1-071.v2025-05-13.q352; 36Oracle.Prepawayete.1z1-071.v2022-01-25.by.lauren.209q.pdf

Latest Upload: 105OCEG.GRCP.v2025-09-11.q211; 104HP.HPE0-V27.v2025-09-11.q78; 118Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 164TheSecOpsGroup.CNSP.v2025-09-08.q20; 223CFAInstitute.ESG-Investing.v2025-09-08.q173; 158PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 149Salesforce.Data-Architect.v2025-09-05.q216; 144Adobe.AD0-E605.v2025-09-05.q50

Question 141

Question 142

Question 143

Question 144

Question 145

Download PDF File