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

Question 31

You must find the number of employees whose salary is lower than employee 110.
Which statement fails to do this?

A.SELECT COUNT (* )
FROM employees e
WHERE e. salary < (SELECT a. salary FROM employees a WHERE e. employee_ id = 110);

B.SELECT COUNT (*)
FROM employees
JOIN employees a
ON e. salary<
a. salary
WHERE a. employee_ id= 110;

C.SELECT COUNT (*)
FROM employees e
JOIN (SELECT salary FROM employees WHERE employee_ id= 110) a
ON e. salary< a. salary;

D.SELECT COUNT (* )
FROM employees
WHERE salary < (SELECT salary FROM employees WHERE employee id =
110) ;

Question 32

Which statement is true about transactions?

A.A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINTforms a single transaction.

B.Each Data Definition Language (DDL) statement executed forms a single transaction.

C.A set of DDL statements executed in a sequence ending with a COMMITforms a single transaction.

D.A combination of DDL and DML statements executed in a sequence ending with a COMMITforms a single transaction.

Question 33

Which two are true about granting privileges on objects?

A.An object privilege can be granted to other users only by the owner of that object.

B.An object privilege can be granted to a role only by the owner of that object.

C.A table owner must grant the REFERENCESprivilege to allow other users to create FOREIGN KEY constraints using that table.

D.The owner of an object acquires all object privileges on that object by default.

E.The WITH GRANT OPTIONclause can be used only by DBA users.

Question 34

Examine the description or the BOOKS_TRANSACTIONS table:

FOR customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

A.SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
FROM customers
WHERE cust income_level !=NULL
AND cust credit_level !=NULL;

B.SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
FROM customers
WHERE cust income_level IS NOT NULL
AND due_amount IS NOT NULL;

C.SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
FROM customers
WHERE cust income_level <> NULL
AND due_amount <> NULL;

D.SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
FROM customers
WHERE cust_income_level IS NOT NULL
AND cust_credit_limit IS NOT NULL;

E.SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
FROM customers
WHERE cust income_level !=NULL
AND due_amount !=NULL;

Question 35

View the exhibit and examine the ORDERStable.
ORDERS
Name Null? Type
ORDER ID NOT NULL NUMBER(4)
ORDATE DATE DATE
CUSTOMER ID NUMBER(3)
ORDER TOTAL NUMBER(7,2)
The ORDERStable contains data and all orders have been assigned a customer ID. Which statement would add a NOTNULLconstraint to the CUSTOMER_IDcolumn?

A.ALTER TABLE orders
MODIFY CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);

B.ALTER TABLE orders
MODIFY customer_id CONSTRAINT orders_cust_nn NOT NULL (customer_id);

C.ALTER TABLE orders
ADD CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);

D.ALTER TABLE orders
ADD customer_id NUMBER(6)CONSTRAINT orders_cust_id_nn NOT NULL;

Other Version: 963Oracle.1z0-071.v2026-09-25.q398; 7740Oracle.1z0-071.v2024-10-24.q196; 3841Oracle.1z0-071.v2023-10-02.q276; 3232Oracle.1z0-071.v2023-05-08.q154; 7742Oracle.1z0-071.v2022-09-21.q298; 6403Oracle.1z0-071.v2022-08-30.q239; 26060Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 166PaloAltoNetworks.SSE-Engineer.v2026-10-17.q44; 272Cisco.300-420.v2026-10-17.q324; 199Salesforce.MCE-Con-201.v2026-10-15.q108; 181EMC.NCA.v2026-10-15.q25; 281Apple.Apple-Device-Support.v2026-10-15.q159; 187F5.F5CAB3.v2026-10-14.q47; 188Oracle.1Z0-1048-25.v2026-10-14.q67; 265Cisco.300-730.v2026-10-14.q199; 258Salesforce.Sales-Admn-202.v2026-10-14.q160; 174ServSafe.ServSafe-Manager.v2026-10-13.q32

Question 31

Question 32

Question 33

Question 34

Question 35

Download PDF File