Oracle 1Z0-071 Quiz 1 Topic 16 Questions 1-5

Question: 1

Which three statements are true about external tables?

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.

Show Answer

Question: 2

Examine the data in the NEW_EMPLOYEES table:

q2_1Z0-071

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)

q2_1Z0-071

B)

q2_1Z0-071

C)

q2_1Z0-071

D)

q2_1Z0-071

AOption A

BOption B

COption C

DOption D

Show Answer

Question: 3

Examine the description of the CUSTOMERS table:

q3_1Z0-071

Which two statements will do an implicit conversion?

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';

Show Answer

Question: 4

Examine these statements:

q4_1Z0-071

Which two are true?

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.

Show Answer

Question: 5

Examine the data in the ORDERS table:

q5_1Z0-071

Examine the data in the INVOICE table:

q5_1Z0-071

Examine this query:

q5_1Z0-071

Which three rows will it return?

A3 <null>

B3 01-JAN-2019

C5 01-MAR-2019

D1 <null>

E4 01-FEB-2019

F5 <null>

G2 <null>

Show Answer

Oracle 1Z0-071 Quiz:1 Topic:16 Questions:1-5