Free Oracle 1Z0-071 Practice Exams Questions 2026 - TheExamsLabs

Start Preparation with the Latest and Real 100% Free Oracle Database 12c 1Z0-071 Exam Dumps Questions Practice 2026

Page: 1 / 113

Total 561 Questions | Updated On: May 24, 2026

Add To Cart

Question 1

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

Question 2

Which two are true about external tables that use the ORACLE _DATAPUMP access driver?

A : Creating an external table creates a directory object.

B : When creating an external table, data can be selected only from a table whose rows are stored in database blocks.

C : When creating an external table, data can be selected from another external table or from a table whose rows are stored in database blocks.

D : Creating an external table creates a dump file that can be used by an external table in the same or a different database.

E : Creating an external table creates a dump file that can be used only by an external table in the same database.

Answer: B,D

Question 3

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 4

Examine this description of the PRODUCTS table:

You successfully execute this command:

Which two statements execute without errors?

A :

B :

C :

D :

Answer: B

Question 5

Evaluate the following SQL statements that are issued in the given order:

CREATE TABLE emp

(emp_no NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY,

ename VARCHAR2(15),

salary NUMBER (8,2),

mgr_no NUMBER(2) CONSTRAINT emp_mgr_fk REFERENCES emp(emp_no));

ALTER TABLE emp

DISABLE CONSTRAINT emp_emp_no_pk CASCADE;

ALTER TABLE emp

ENABLE CONSTRAINT emp_emp_no_pk;

What would be the status of the foreign key EMP_MGR_PK?

A : It would remain disabled and can be enabled only by dropping the foreign key constraint and recreating it.

B : It would remain disabled and has to be enabled manually using the ALTER TABLE command.

C : It would be automatically enabled and immediate.

D : It would be automatically enabled and deferred.

Answer: B

Page: 1 / 113

Total 561 Questions | Updated On: May 24, 2026

Add To Cart