Oracle 1Z0-071 Quiz 37 Topic 4 Questions 181-185

Question: 1

Which two statements are true regarding working with dates? (Choose two.)

AThe RR date format automatically calculates the century from the SYSDATE function but allows the session user to enter the century.

BThe RR date format automatically calculates the century from the SYSDATE function and does not allow a session user to enter the century.

CThe default internal storage of dates is in character format.

DThe default internal storage of dates is in numeric format.

Show Answer

Question: 2

View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.

q2_1Z0-071

You executed this UPDATE statement:

q2_1Z0-071

Which statement is true regarding the execution? (Choose the best answer.)

AIt would not execute because a subquery cannot be used in the WHERE clause of an UPDATE statement.

BIt would not execute because two tables cannot be referenced in a single UPDATE statement.

CIt would execute and restrict modifications to the columns specified in the SELECT statement.

DIt would not execute because a SELECT statement cannot be used in place of a table name.

Show Answer

Question: 3

View the Exhibit and examine the structure of the PRODUCTS table.

q3_1Z0-071

You must display the category with the maximum number of items.

You issue this query:

q3_1Z0-071

What is the result?

AIt generates an error because = is not valid and should be replaced by the IN operator.

BIt executes successfully but does not give the correct output.

CIt executes successfully and gives the correct output.

DIt generate an error because the subquery does not have a GROUP BY clause.

Show Answer

Question: 4

Examine the structure of the MEMBERS table:

q4_1Z0-071

Examine the SQL statement:

SQL > SELECT city, last_name LNAME FROM MEMBERS ORDER BY 1, LNAME DESC;

What would be the result execution? (Choose the best answer.)

AIt displays all cities in descending order, within which the last names are further sorted in descending order.

BIt fails because a column alias cannot be used in the ORDER BY clause.

CIt fails because a column number and a column alias cannot be used together in the ORDER BY clause.

DIt displays all cities in ascending order, within which the last names are further sorted in descending order.

Show Answer

Question: 5

View and Exhibit and examine the structure and data in the INVOICE table.

q5_1Z0-071

Which two statements are true regarding data type conversion in query expressions? (Choose two.)

Ainv_date = '15-february-2008' :uses implicit conversion

Binv_amt = '0255982' : requires explicit conversion

Cinv_date > '01-02-2008' : uses implicit conversion

DCONCAT(inv_amt, inv_date) : requires explicit conversion

Einv_no BETWEEN '101' AND '110' : uses implicit conversion

Show Answer

Oracle 1Z0-071 Quiz:37 Topic:4 Questions:181-185