Free Oracle 1Z0-071 Exam Questions

Become Oracle Certified with updated 1Z0-071 exam questions and correct answers

Page: 1 / 113

Total 561 Questions | Updated On: Apr 03, 2026

Add To Cart

Question 1

Evaluate the following SQL statement:

Which statement is true regarding the outcome of the above query?

A : It executes successfully and displays rows in the descending order of PROMO_CATEGORY.

B : It produces an error because positional notation cannot be used in the ORDER BY clause with SET operators.

C : It executes successfully but ignores the ORDER BY clause because it is not located at the end of the compound statement.

D : It produces an error because the ORDER BY clause should appear only at the end of a compound query-that is, with the last SELECT statement.

Answer: D

Question 2

Which three statements are true regarding subqueries? (Choose three.)

A : The ORDER BY Clause can be used in a subquery.

B : A subquery can be used in the FROM clause of a SELECT statement.

C : If a subquery returns NULL, the main query may still return rows.

D : A subquery can be placed in a WHERE clause, a GROUP BY clause, or a HAVING clause.

E : Logical operators, such as AND, OR and NOT, cannot be used in the WHERE clause of a subquery.

Answer: A,B,C

Question 3

Which two are true about multiple table INSERT statements?

A : They always use subqueries.

B : They can transform a row from a source table into multiple rows in a target table.

C : The conditional INSERT FIRST statement always inserts a row into a single table.

D : The conditional INSERT ALL statement inserts rows into a single table by aggregating source rows.

E : The unconditional INSERT ALL statement must have the same number of columns in both the source and target tables.

Answer: B,E

Question 4

Which two are true about using constraints?

A : A FOREIGN KEY column in a child table and the referenced PRIMARY KEY column in the parenttable must have the same names.

B : A table can have multiple PRIMARY KEY and multiple FOREIGN KEY constraints.

C : A table can have only one PRIMARY KEY and one FOREIGN KEY constraint.

D : PRIMARY KEY and FOREIGNY constraints can be specified at the column and at the table level

E : A table can have only one PRIMARY KEY but may have multiple FOREIGN KEY constraints.

F : NOT NULL can be specified at the column and at the table level.

Answer: D,E

Question 5

Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the creation and storage of data in the above table

structure? (Choose two.)

A : The CUST_STATUS column would store exactly one character

B : The TRANS_VALIDITY column would have a maximum size of one character.

C : The CUST_CREDIT_LIMIT column would be able to store decimal values.

D : The CUST_STATUS column would give an error.

E : The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds.

F : The TRANS_VALIDITY column would give an error.

Answer: A,C

Page: 1 / 113

Total 561 Questions | Updated On: Apr 03, 2026

Add To Cart