Oracle 1Z0-071 Quiz 12 Topic 11 Questions 56-60

Question: 1

Which two are true about a SQL statement using SET operators such as UNION?

AThe number, but not names, of columns must be identical for all SELECT statements in the query.

BThe data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

CThe data type group of each column returned by the second query must match the data type group of the corresponding column returned by the first query.

DThe names and number of columns must be identical for all SELECT statements in the query.

EThe data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.

Show Answer

Question: 2

Evaluate these commands which execute successfully:

q2_1Z0-071

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?

ASequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times.

BAny user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ.

CColumn ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO.

DIf sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS.

ESequence ORD_SEQ is guaranteed not to generate duplicate numbers.

Show Answer

Question: 3

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.

The variables used in your query are never undefined in your session?

Which query can be used?

q3_1Z0-071

AOption A

BOption B

COption C

DOption D

EOption E

Show Answer

Question: 4

Which three actions can you perform by using the ORACLE_DATAPUMP access driver?

ARead data from a table in the database and insert it into an external table.

BRead data from an external table and load it into a table in the database.

CCreate a directory object for an external table.

DCreate a directory object for a flat file.

EExecute DML statements on an external table.

FQuery data from an external table.

Show Answer

Question: 5

Examine this SQL statement:

q5_1Z0-071

Identify three order by clauses, any one of which can complete the query successfully.

AORDER BY CUST_NO

BORDER BY 2, 1

CORDER BY 2, cust_id

DORDER BY 'Last Name'

EORDER BY 'CUST NO'

Show Answer

Oracle 1Z0-071 Quiz:12 Topic:11 Questions:56-60