Oracle 1Z0-071 Quiz 66 Topic 17 Questions 326-330

Question: 1

Examine the structure of the MEMBERS table: (Choose the best answer.)

q1_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?

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: 2

View and Exhibit and examine the structure and data in the INVOICE table. (Choose two.)

q2_1Z0-071

Which two statements are true regarding data type conversion in query expressions?

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

Question: 3

Examine the structure of the EMPLOYEES table. (Choose the best answer.)

q3_1Z0-071

You must display the details of employees who have manager with MANAGER_ID 100, who were hired in the past 6 months and who have salaries greater than 10000.

ASELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000UNION ALL SELECT last_name, hire_date, salaryFROM employeesWHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id = 100)INETRSECTSELECT last_name, hire_date, salaryFROM employees WHERE hire_date > SYSDATE- 180;

BSELECT last_name, hire_date, salaryFROM employeesWHERE manager_id = (SELECT employee_id FROM employees WHERE employee_id = 100)UNION ALL(SELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE -180INTERSECTSELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000);

CSELECT last_name, hire_date, salaryFROM employeesWHERE manager_id = (SELECT employee_id FROM employees WHERE employee_id = '100')UNIONSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE -180INTERSECTSELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000;

D(SELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000UNION ALLSELECT last_name, hire_date, salaryFROM employeesWHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id = 100))UNIONSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE -180;

Show Answer

Question: 4

Examine the structure of the PROMOTIONS table: (Choose the best answer.)

q4_1Z0-071

Management requires a report of unique promotion costs in each promotion category.

Which query would satisfy this requirement?

ASELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1

BSELECT promo_category, DISTINCT promo_cost FROM promotions

CSELECT DISTINCT promo_cost, promo_category FROM promotions

DSELECT DISTINCT promo_cost, DISTINCT promo_category FROM promotions;

Show Answer

Question: 5

You must create a table for a banking application. (Choose the best answer.)

One of the columns in the table has these requirements:

1: A column to store the duration of a short team loan

2: The data should be stored in a format supporting DATE arithmetic with DATE datatypes without using conversion functions.

3: The maximum loan period is 30 days.

4: Interest must be calculated based on the number of days for which the loan remains unpaid.

Which data type would you use?

ADate

BNumber

CTimestamp

DInterval day to second

EInterval year to month

Show Answer

Oracle 1Z0-071 Quiz:66 Topic:17 Questions:326-330