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

Question 96

Which three statements are true? (Choose three.)

A.The data dictionary is created and maintained by the database administrator.

B.Data dictionary views consist of joins of dictionary base tables and user-defined tables.

C.The usernames of all users including database administrators are stored in the data dictionary.

D.The USER_CONS_COLUMNS view should be queried to find the names of columns to which constraints apply.

E.Both USER_OBJECTS and CAT views provide the same information about all objects that are owned by the user.

F.Views with the same name but different prefixes, such as DBA, ALL and USER, reference the same base tables from the data dictionary.

Question 97

View the Exhibit and examine the structure of the PRODUCT_INFORMATION table.

You want to see the product names and the date of expiration of warranty for all the products, if the product is purchased today. The products that have no warranty should be displayed at the top and the products with maximum warranty period should be displayed at the bottom.
Which SQL statement would you execute to fulfill this requirement?

A.SELECT product_name, SYSDATE+warranty_period AS "Warranty expire date"FROM product_informationORDER BY SYSDATE

B.SELECT product_name, SYSDATE+warranty_period AS "Warranty expire date"FROM product_informationORDER BY SYSDATE+warranty_period

C.SELECT product_name, SYSDATE+warranty_period AS "Warranty expire date"FROM product_informationWHERE warranty_period > SYSDATE

D.SELECT product_name, SYSDATE+warranty_period AS "Warranty expire date"FROM product_informationORDER BY SYSDATE-warranty_period

Question 98

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 fail because the VALUES clause is not required with the subquery.

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

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

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

Question 99

Evaluate the following statement.
INSERT ALL
WHEN order_total < 10000 THEN
INTO small_orders
WHEN order_total > 10000 AND order_total < 20000 THEN
INTO medium_orders
WHEN order_total > 200000 AND order_total < 20000 THEN
INTO large_orders
SELECT order_id, order_total, customer_id
FROM orders;
Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?

A.They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.

B.They are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.

C.They are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.

D.The insert statement would give an error because the ELSE clause is not present for support in case none of WHEN clauses are true.

Question 100

Evaluate the following SQL commands:

The command to create a table fails. Identify the reason for the SQL statement failure.

A.You cannot use the BETWEEN clause in the condition of a CHECK constraint.

B.You cannot use SYSDATE in the condition of a CHECK constraint.

C.You cannot use the NEXTVAL sequence value as a DEFAULT value for a column.

D.You cannot use ORD_NO and ITEM_NO columns as a composite primary key because ORD_NO is also the FOREIGN KEY.

Other Version: 2208Oracle.1z0-071.v2025-03-22.q314; 5996Oracle.1z0-071.v2024-10-24.q196; 2444Oracle.1z0-071.v2023-10-02.q276; 2333Oracle.1z0-071.v2023-05-08.q154; 6181Oracle.1z0-071.v2022-09-21.q298; 4978Oracle.1z0-071.v2022-08-30.q239; 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; 128SAP.C_SAC_2501.v2025-12-20.q21; 112Snowflake.DAA-C01.v2025-12-20.q172

Question 96

Question 97

Question 98

Question 99

Question 100

Download PDF File