Oracle 1Z0-071 Quiz 81 Topic 1 Questions 401-405

Question: 1

Examine the structure proposed for the TRANSACTIONS table:

q1_1Z0-071

Which two statements are true regarding the storage of data in the above table structure? (Choose two.)

AThe CUST_CREDIT_VALUE column would allow storage of positive and negative integers.

BThe TRANS_VALIDITY column would allow storage of a time interval in days, hours, minutes, and seconds.

CThe CUST_STATUS column would allow storage of data up to the maximum VARCHAR2 size of 4,000 characters.

DThe TRANS_DATE column would allow storage of dates only in the dd-mon-yyyy format.

Show Answer

Question: 2

Which two queries return the string Hello! we're ready?

ASELECT q'! Hello! We're ready! 'FROM DUAL;

BSELECT 'Hello! We're ready 'FROM |DUAL;

CSELECT q'[Hello! We're ready]'FROM DUAL;

DSELECT 'Hello! we\ re ready' ESCAPE'N'FROMDUAL:

ESELECT 'Hello! We're ready' FROM DUAL;

Show Answer

Question: 3

Evaluate the following SQL statement:

SQL> select cust_id, cust_last_name "Last name"

FROM customers

WHERE country_id = 10

UNION

SELECT cust_id CUST_NO, cust_last_name

FROM customers

WHERE country_id = 30

Identify three ORDER BY clauses either one of which can complete the query.

AORDER BY 'Last name'

BORDER BY 2, cust_id

CORDER BY CUST_NO

DORDER BY 2, 1

EORDER BY 'CUST_NO'

Show Answer

Question: 4

Which two statements are true about Data Manipulation Language (DML) statements?

AAn INSERT INTO...VALUES.. statement can add multiple rows per execution to a table.

BAn UPDATE... SET... statement can modify multiple rows based on multiple conditions on a table.

CA DELETE FROM..... statement can remove rows based on only a single condition on a table.

DAn INSERT INTO... VALUES..... statement can add a single row based on multiple conditions on a table.

EA DELETE FROM..... statement can remove multiple rows based on multiple conditions on a table.

FAn UPDATE....SET.... statement can modify multiple rows based on only a single condition on a table.

Show Answer

Question: 5

Evaluate the following statement.

INSERT ALL

WHEN order_total < 10000 THEN

INTO small_orders

WHEN order_total > 10000 AND order_total < 20000 THEN

INTO medium_orders

WHEN order_total > 200000 AND order_total < 20000 THEN

INTO large_orders

SELECT order_id, order_total, customer_id

FROM orders;

Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?

AThey are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.

BThey are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.

CThey are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.

DThe insert statement would give an error because the ELSE clause is not present for support in case none of WHEN clauses are true.

Show Answer

Oracle 1Z0-071 Quiz:81 Topic:1 Questions:401-405