Online Access Free Oracle.1z0-071.v2024-08-26.q188 Practice Test (Page 25)

1z0-071 Exam Question 116

Examine the structure of the MEMBERStable:

You want to display details of all members who reside in states starting with the letter A followed by exactly one character.
Which SQL statement must you execute?

A.SELECT * FROM MEMBERS WHERE state LIKE 'A_%';

B.SELECT * FROM MEMBERS WHERE state LIKE 'A_';

C.SELECT * FROM MEMBERS WHERE state LIKE '%A_';

D.SELECT * FROM MEMBERS WHERE state LIKE 'A%';

1z0-071 Exam Question 117

Evaluate the following two queries:

Which statement is true regarding the above two queries?

A.Performance would improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT column.

B.There would be no change in performance.

C.Performance would degrade in query 2.

D.Performance would improve in query 2.

1z0-071 Exam Question 118

View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTSand TIMEStables.

The PROD_IDcolumn is the foreign key in the SALEStable referencing the PRODUCTStable.
The CUST_IDand TIME_IDcolumns are also foreign keys in the SALEStable referencing the CUSTOMERS and TIMEStables, 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_SALEStable would not get created because the column names in the CREATETABLE command and the SELECTclause do not match.

B.The NEW_SALEStable would not get created because the DEFAULTvalue cannot be specified in the column definition.

C.The NEW_SALEStable would get created and all the FOREIGNKEYconstraints defined on the selected columns from the SALES table would be created on the corresponding columns in the NEW_SALES table.

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

1z0-071 Exam Question 119

Examine these SQL statements which execute successfully:

Which two statements are true after execution? (Choose two.)

A.The primary key constraint will be enabled and DEFERRED.

B.The primary key constraint will be enabled and IMMEDIATE.

C.The foreign key constraint will be enabled and IMMEDIATE.

D.The foreign key constraint will be disabled.

E.The foreign key constraint will be enabled and DEFERRED.

1z0-071 Exam Question 120