Oracle 1Z0-071 Quiz 54 Topic 10 Questions 266-270

Question: 1

Which task can be performed by using a single Data Manipulation Language (DML) statement?

Aadding a column constraint while inserting a row into a table

Badding a column with a default value while inserting a row into a table

Cremoving all data from a single column on which a unique constraint is defined

Dremoving all data only from a single column on which a primary key constraint is defined

Show Answer

Question: 2

Examine the structure of the BOOKS_TRANSACTIONS table:

q2_1Z0-071

You want to display the member IDs, due date, and late fee as $2 for all transactions.

Which SQL statement must you execute?

ASELECT member_id AS MEMBER_ID, due_date AS DUE_DATE, $2 AS LATE_FEE FROM BOOKS_TRANSACTIONS;

BSELECT member_id 'MEMBER ID', due_date 'DUE DATE', '$2 AS LATE FEE' FROM BOOKS_TRANSACTIONS;

CSELECT member_id AS 'MEMBER ID', due_date AS 'DUE DATE', '$2' AS 'LATE FEE' FROM BOOKS_TRANSACTIONS;

DSELECT member_id AS 'MEMBER ID', due_date AS 'DUE DATE', $2 AS 'LATE FEE' FROM BOOKS_TRANSACTIONS;

Show Answer

Question: 3

In which three situations does a transaction complete? (Choose three.)

Awhen a PL/SQL anonymous block is executed

Bwhen a DELETE statement is executed

Cwhen a ROLLBACK command is executed

Dwhen a data definition language (DDL) statement is executed

Ewhen a TRUNCATE statement is executed after the pending transaction

Show Answer

Question: 4

View the exhibit and examine the data in ORDERS_MASTER and MONTHLY_ORDERS tables.

q4_1Z0-071

Evaluate the following MERGE statement:

MERGE_INTO orders_master o

USING monthly_orders m

ON (o.order_id = m.order_id)

WHEN MATCHED THEN

UPDATE SET o.order_total = m.order_total

DELETE WHERE (m.order_total IS NULL)

WHEN NOT MATCHED THEN

INSERT VALUES (m.order_id, m.order_total);

What would be the outcome of the above statement?

AThe ORDERS_MASTER table would contain the ORDER_IDs 1, 2, 3 and 4.

BThe ORDERS_MASTER table would contain the ORDER_IDs 1, 2 and 4.

CThe ORDERS_MASTER table would contain the ORDER_IDs 1, 2 and 3.

DThe ORDERS_MASTER table would contain the ORDER_IDs 1 and 2.

Show Answer

Question: 5

Evaluate the following SQL statement:

SELECT product_name || 'it's not available for order'

FROM product_information

WHERE product_status = 'obsolete';

You received the following error while executing the above query:

ERROR

ORA-01756: quoted string not properly terminated

What would you do to execute the query successfully?

ARemove the single quotation marks enclosing the character literal string in the SELECT clause

BUse the escape character to negate the single quotation mark within the literal character string in the SELECT clause

CEnclose the character literal string in the SELECT clause within double quotation marks

DUse the Oracle (q) operator and delimiter to allow the use of a single quotation mark within the literal character string in the SELECT clause

Show Answer

Oracle 1Z0-071 Quiz:54 Topic:10 Questions:266-270