Free Access Oracle.1z0-071.v2022-08-30.q239 Practice Test (Page 8)

Question 31

Examine the structure of the BOOKS_TRANSACTIONS table:

Examine the SQL statement:

Which statement is true about the outcome?

A.It displays details for members who have borrowed before today with RM as TRANSACTION_TYPE and the details for members A101 or A102.

B.It displays details only for members who have borrowed before today with RM as TRANSACTION_TYPE.

C.It displays details for members who have borrowed before today's date with either RM as TRANSACTION_TYPE or MEMBER_ID as A101 and A102.

D.It displays details for only members A101 and A102 who have borrowed before today with RM TRANSACTION_TYPE.

Question 32

Which three privileges can be restricted to a subset of columns in a table? (Choose three.)

A.UPDATE

B.DELETE

C.INDEX

D.REFERENCES

E.SELECT

F.INSERT

G.ALTER

Question 33

Which two statements are true regarding roles? (Choose two.)

A.A role can be granted to itself.

B.A role can be granted to PUBLIC.

C.A user can be granted only one role at any point of time.

D.The REVOKE command can be used to remove privileges but not roles from other users.

E.Roles are named groups of related privileges that can be granted to users or other roles.

Question 34

Which three are true about scalar subquery expressions?

A.They can be nested.

B.They cannot be used in the values clause of an insert statement*

C.A scalar subquery expression that returns zero rows evaluates to null.

D.They cannot be used in group by clauses.

E.They can be used as default values for columns in a create table statement.

F.A scalar subquery expression that returns zero rows evaluates to zoro

Question 35

View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables.

The PROD_ID column is the foreign key in the SALES table referencing the PRODUCTS table.
The CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.
Examine this command:
CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE)
AS
SELECT prod_id, cust_id, time_id
FROM sales;
Which statement is true?

A.The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.

B.The NEW_SALES table would get created and all the NOT NULL constraints defined on the selected columns from the SALES table would be created on the corresponding columns in the NEW_SALES table.

C.The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.

D.The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the selected columns from the SALES table would be created on the corresponding columns in the NEW_SALES table.

Other Version: 2208Oracle.1z0-071.v2025-03-22.q314; 5995Oracle.1z0-071.v2024-10-24.q196; 2444Oracle.1z0-071.v2023-10-02.q276; 2331Oracle.1z0-071.v2023-05-08.q154; 6174Oracle.1z0-071.v2022-09-21.q298; 24718Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 144HRCI.aPHRi.v2025-12-22.q195; 107APICS.CSCP.v2025-12-22.q352; 107SAP.C_SIGPM_2403.v2025-12-22.q25; 114Nutanix.NCP-CI-Azure.v2025-12-22.q27; 106EMC.D-PEMX-DY-23.v2025-12-22.q45; 113SAP.C_S4CS_2502.v2025-12-22.q29; 115ISA.ISA-IEC-62443.v2025-12-22.q112; 175HashiCorp.HCVA0-003.v2025-12-20.q102; 127SAP.C_SAC_2501.v2025-12-20.q21; 112Snowflake.DAA-C01.v2025-12-20.q172

Question 31

Question 32

Question 33

Question 34

Question 35

Download PDF File