Free Oracle 1Z0-071 Exam Dumps and 1Z0-071 Exam Questions

Question No: 71

MultipleChoice

Which three statements are true about external tables?

Options

AThey can be used In queries containing sorts.

BThey can be used in queries containing Joins.

CThey can be indexed.

DDML statements can modify them.

EThey can be temporary tables.

FTheir metadata Is stored In the database.

Question No: 72

MultipleChoice

Examine the data in the NEW_EMPLOYEES table:

Update existing employee details in the EMPLOYEES table with data from the NEW_EMPLOYEES table.

2. Add new employee details from the NEW_EMPLOYEES table to the EMPLOYEES table.

Which statement will do this?

A)

B)

C)

D)

Options

AOption A

BOption B

COption C

DOption D

Question No: 73

MultipleChoice

Examine the description of the CUSTOMERS table:

Which two statements will do an implicit conversion?

Options

ASELECT FROM + customers WHERE TO-CHAR (customer_id) = '0001';

BSELECT FROM + customers WHERE (customer_id) = 0001;

CSELECT FROM + customers WHERE (customer_id) = '0001';

DSELECT FROM + customers WHERE insert_date = DATE '2019-01-01';

ESELECT FROM + customers WHERE insert_date = '01-JAN-19';

Question No: 74

MultipleChoice

Examine these statements:

Which two are true?

Options

ABoth foreign key constraint definition must be removed from the CREATE statements, and be added with ALTER TABLE statements once both tables are created, for the two CREATE TABLE statements to execute successfully in the order shown.

BThe MGR column In the DEPT table will not be able to contain null values.

CThe DEPTNO column in the EMP table will be able to contain null values.

DThe DEPT_FKEY constraint definition must be removed from the CREATE TABLE DEPT statement. and the added with an D. ALTER statement once both tables are created, for the two CREATE TABLE statements to execute successfully in the order shown.

EThe create TABLE EMP statement must precede the create table DEPT statement for all three statements to execute successfully.

FAll three statements execute successfully in the order shown.

Question No: 75

MultipleChoice

Examine the data in the ORDERS table:

Examine the data in the INVOICE table:

Examine this query:

Which three rows will it return?

Options

A3 <null>

B3 01-JAN-2019

C5 01-MAR-2019

D1 <null>

E4 01-FEB-2019

F5 <null>

G2 <null>