Oracle 1Z0-071 Quiz 61 Topic 4 Questions 301-305

Question: 1

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

q1_1Z0-071

You have to generate a report that displays the promo named start data for all promos that started after that last promo in the 'INTTERNET' category.

ASelect promo_name, promo_being_date FROM promoptions
WHERE promo_being_data > ANY (SELCT promo_being-date
FROM promotions
WHERE promo_category = 'INTERNET'

BSELECT promo_neme, promo_being_date FROM promotions
WHERE promo_being_date > All (SELECT promo_beinjg-date
FROM promotions
WHERE promo_category ='INTERNET' );

CSELECT promo-name, promo-being _date FROM promotions
Where promo_being_data >ALL (SELECT MAX (promo_being-date)
FROM promotions ) AND
Promo-category ='INTERNET';

DSELECT promo-name, promo-being_date FROM promotion
WHERE promo-being-date IN (SELECT promo_biing_date
FROM promotions
WHERE promo_category='INTYERNET');

Show Answer

Question: 2

View the Exhibit and examine the details of the PRODUCT_INFORMATION table.

q2_1Z0-071

You have the requirement to display PRODUCT_NAME and LIST_PRICE from the table where the CATEGORYJD column has values 12 or 13, and the SUPPLIER_ID column has the value 102088. You executed the following SQL statement:

SELECT product_name, list_price

FROM product_information

WHERE (category_id = 12 AND category_id = 13) AND supplier_id = 102088;

Which statement is true regarding the execution of the query?

AIt would not execute because the entire WHERE clause is not enclosed within parentheses.

BIt would execute but would return no rows.

CIt would not execute because the same column has been used twice with the AND logical operator.

DIt would execute and return the desired.

Show Answer

Question: 3

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

You want to display all employees and their managers having 100 as the MANAGER_ID. You want the output in two columns: the first column would have the LAST_NAME of the managers and the second column would have LAST_NAME of the employees.

q3_1Z0-071

Which SQL statement would you execute?

ASELECT m.last_name 'Manager', e.last_name 'Employee'
FROM employees m JOIN employees e
ON m.employee_id = e.manager_id
WHERE m.manager_id=100;

BSELECT m.last_name 'Manager', e.last_name 'Employee'
FROM employees m JOIN employees e
ON m.employee_id = e.manager_id
WHERE e.managerjd=100;

CSELECT m.last_name 'Manager', e.last_name 'Employee'
FROM employees m JOIN employees e
ON e.employee_id = m.manager_id
WHERE m.manager_id=100;

DSELECT m.last_name 'Manager', e.last_name 'Employee'
FROM employees m JOIN employees e
WHERE m.employee_id = e.manager_id AND e.managerjd=100;

Show Answer

Question: 4

Which statement is true regarding the default behaviour of the ORDER by clause?

ANumeric values are displayed in descending order if they have decimal positions.

BOnly columns that are specified in the SELECT list can be used in the ORDER by clause.

CIn a character sort, the values are case-sensitive.

DNULLs are not including in the sort operation

Show Answer

Question: 5

Evaluate this query:

SQL> SELECT TRUNC(ROUND(156.00,-1),-1)

FROM DUAL;

What will be the result?

A16

B100

C160

D150

E200

Show Answer

Oracle 1Z0-071 Quiz:61 Topic:4 Questions:301-305