Free Access Oracle.1z0-071.v2022-02-20.q161 Practice Test (Page 14)

Question 61

You issue this command which succeeds:
SQL> DROP TABLE products;
Which three statements are true? (Choose three.)

A.Table data is deleted but the table structure is retained.

B.Any uncommitted transaction in the session is committed.

C.Table data and the table structure are deleted.

D.All existing views and synonyms that refer to the table are invalidated but retained.

E.All the table's indexes if any exist, are invalidated but retained.

Question 62

View the Exhibit and examine the description for the SALES and CHANNELS tables.

You issued this SQL statement:

Which statement is true regarding the result? (Choose the best answer.)

A.The statement will execute and a new row will be inserted in the SALES table.

B.The statement will fail because the VALUES clause is not required with the subquery.

C.The statement will fail because the subquery in the VALUES clause is not enclosed within single quotation marks.

D.The statement will fail because a subquery cannot be used in a VALUES clause.

Question 63

You need to display the date 11-oct-2007 in words as 'Eleventh of October, Two Thousand Seven'.
Which SQL statement would give the required result?

A.SELECT TO_CHAR (TO_DATE ('11-oct-2007'), 'fmDdspth of month, year')FROM DUAL

B.SELECT TO_CHAR ('11-oct-2007', 'fmDdspth "of" Month, Year')FROM DUAL

C.SELECT TO_DATE (TO_CHAR ('11-oct-2007'), 'fmDdspth "of" Month, Year'))FROM DUAL

D.SELECT TO_CHAR (TO_DATE ('11-oct-2007'), 'fmDdthsp "of" Month, Year')FROM DUAL

Question 64

The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues this GRANT command:
GRANT ALL
ON orders, order_items
TO PUBLIC;
What must be done to fix the statement?

A.PUBLIC should be replaced with specific usernames.

B.ALL should be replaced with a list of specific privileges.

C.WITH GRANT OPTION should be added to the statement.

D.Separate GRANT statements are required for the ORDERS and ORDER_ITEMS tables.

Question 65

The PRODUCTStable has the following structure.

Evaluate the following two SQL statements:
SQL>SELECT prod_id, NVL2 (prod_expiry_date, prod_expiry_date + 15, ' ') FROM products; SQL>SELECT prod_id, NVL (prod_expiry_date, prod_expiry_date + 15) FROM products; Which statement is true regarding the outcome?

A.Both the statements execute and give different results

B.Only the second SQL statement executes successfully

C.Both the statements execute and give the same result

D.Only the first SQL statement executes successfully

Other Version: 4126Oracle.1z0-071.v2025-03-22.q314; 7455Oracle.1z0-071.v2024-10-24.q196; 3660Oracle.1z0-071.v2023-10-02.q276; 3039Oracle.1z0-071.v2023-05-08.q154; 7492Oracle.1z0-071.v2022-09-21.q298; 6205Oracle.1z0-071.v2022-08-30.q239; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 124Adobe.AD0-E911.v2026-09-12.q35; 117Google.ADP.v2026-09-11.q22; 130AIChE.CCPSC.v2026-09-11.q41; 130Scrum.PSPO-III.v2026-09-10.q23; 220Scrum.PSPO-I.v2026-09-09.q157; 188ScaledAgile.SAFe-SPC.v2026-09-08.q108; 147Oracle.1Z0-1033-26.v2026-09-08.q43; 220Pegasystems.PEGACPSSA25V1.v2026-09-08.q144; 166BCI.CBCI.v2026-09-07.q89; 212Salesforce.Plat-Admn-202.v2026-09-07.q170

Question 61

Question 62

Question 63

Question 64

Question 65

Download PDF File