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

Question 251

Which two are true about scalar subquery expressions?

A.You cannot correlate them with a table in the parent statement

B.You can use them as a default value for a column.

C..You must enclose them in parentheses.

D.They can return at most one row.

E.They can return two columns.

Question 252

View the exhibit and examine the descriptions of the DEPTand LOCATIONStables.

You want to update the CITYcolumn of the DEPTtable for all the rows with the corresponding value in the CITYcolumn of the LOCATIONStable for each department.
Which SQL statement would you execute to accomplish the task?

A.UPDATE dept d
SET city = ANY (SELECT city
FROM locations l)

B.UPDATE dept d
SET city = ALL (SELECT city
FROM locations l
WHERE d.location_id = l.location_id);

C.UPDATE dept d
SET city = (SELECT city
FROM locations l
WHERE d.location_id = l.location_id);

D.UPDATE dept d
SET city = (SELECT city
FROM locations l)
WHERE d.location_id = l.location_id;

Question 253

Which two statements are true about views?

A.Views can be indexed.

B.The with check clause prevents certain rows from being displayed when querying the view.

C.Views can be updated without the need to re-grant privileges on the view.

D.Tables in the defining query of a view must always exist in order to create the view.

E.The with check clause prevents certain rows from being updated or inserted in the underlying table through the view.

Question 254

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

A.Rolling back to a SAVEPOINTcan undo a DELETEstatement

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 CREATE INDEX statement

E.Only one SAVEPOINTmay be issued in a transaction

Question 255

Examine the description of the transactions table:
Which two SQL statements execute successfully?

A.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount+100 "DUES" from transactions;

B.SELECT customer_id AS 'CUSTOMER-ID',transaction_date AS DATE, amount+100 'DUES' from transactions;

C.SELECT customer_id CUSTID, transaction_date TRANS_DATEamount+100 DUES FROM transactions;

D.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount+100 DUES FROM transactions;

E.SELECT customer id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount+100 "DUES AMOUNT" FROM transactions;

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

Latest Upload: 252PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 362Nokia.4A0-113.v2026-05-01.q69; 397EC-COUNCIL.312-49v11.v2026-04-30.q214; 312Microsoft.MB-820.v2026-04-30.q101; 248Salesforce.MC-202.v2026-04-30.q57; 276BICSI.INSTC_V8.v2026-04-29.q53; 411NMLS.MLO.v2026-04-28.q82; 277NCARB.Project-Management.v2026-04-28.q27; 494EMC.D-AV-DY-23.v2026-04-27.q184; 1304ServiceNow.CSA.v2026-04-27.q483

Question 251

Question 252

Question 253

Question 254

Question 255

Download PDF File