Oracle 1Z0-071 Quiz 16 Topic 13 Questions 76-80

Question: 1

Which three are true about multitable INSERT statements?

AThey can be performed on external tables using SQL* Loader.

BThey can be performed on relational tables.

CThey can be performed only by using a subquery.

DThey can insert each computed row into more than one table.

EThey can be performed on views.

FThey can be performed on remote tables.

Show Answer

Question: 2

Examine the description of the SALES table:

q2_1Z0-071

The SALES table has 55,000 rows.

Examine this statement:

q2_1Z0-071

Which two statements are true?

ASALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table.

BSALES1 is created with 55,000 rows.

CSALES1 has PRIMARY KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.

DSALES1 is created with no rows.

ESALES1 is created with 1 row.

Show Answer

Question: 3

Which CREATE TABLE statement is valid?

q3_1Z0-071

AOption A

BOption B

COption C

DOption D

Show Answer

Question: 4

Examine these statements executed in a single Oracle session:

q4_1Z0-071

Which three statements are true?

AThe code for pen is 1.

BThere is no row containing pencil.

CThe code for fountain pen is 3.

DThe code for pen is 10.

EThere is no row containing fountain pen.

FThere is no row containing pen.

Show Answer

Question: 5

Which two are true about dropping columns from a table?

AA column drop is implicitly committed.

BA column that is referenced by another column in any other table cannot be dropped.

CA column can be removed only if it contains no data.

DMultiple columns can be dropped simultaneously using the ALTER TABLE command.

EA column must be set as unused before it is dropped from a table.

FA primary key column cannot be dropped.

Show Answer

Oracle 1Z0-071 Quiz:16 Topic:13 Questions:76-80