Question 1

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

CUSTOMER_VU is a view based on CUSTOMERS_BR1 table which has the same structure as

CUSTOMERS table.

CUSTOMERS need to be updated to reflect the latest information about the customers.

What is the error in the following MERGE statement?

Options :

A : The CUSTOMER_ID column cannot be updated.

B : The INTO clause is misplaced in the command.

C : The WHERE clause cannot be used with INSERT.

D : CUSTOMER_VU cannot be used as a data source.

Answer: A

Question 2

You execute these commands:

SQL> DEFINE hiredate = '01-APR -2011';

SQL> SELECT employee_id, first_name, salary FROM employees WHERE hire date > &hiredate AND manager_id >&mgr_id;

For which substitution variables will you be prompted?

Options :

A : none

B : &hiredate and &mgr_id

C : only &hiredate

D : only &mgr_id

Answer: D

Question 3

Which statement falls to execute successfully?

Options :

A :

SELECT *

FROM employees e

JOIN department d

WHERE e.department_id=d.department_id

AND d.department_id=90;

B :

SELECT *

FROM employees e

JOIN departments d

ON e.department_id=d.department_id

WHERE d.department_id=90;

C :

SELECT *

FROM employees e

JOIN departments d

ON e.department_id=d.department_id

AND d.department_id=90;

D :

SELECT *

FROM employees e

JOIN departments d

ON d.departments_id=90

WHERE e.department_id=d.department_id;

Answer: A

Question 4

Which three statements are true regarding single-row functions? (Choose three.)

Options :

A : The data type returned, can be different from the data type of the argument that is referenced.

B : They can return multiple values of more than one data type.

C : They can accept only one argument.

D : They can be nested up to only two levels.

E : They can be used in SELECT, WHERE, and ORDER BY clauses.

F :

They can accept column names, expressions, variable names, or a user-supplied constants as arguments.

Answer: A,E,F

Question 5

Examine the description of the CUSTOMERS table:

Which two SELECT statements will return these results:

CUSTOMER_ NAME

--------------------

Mandy

Mary

Options :

A : SELECT customer_ name FROM customers WHERE customer_ name LIKE ' % a % ’ ;

B : SELECT customer_ name FROM customers WHERE customer name LIKE 'Ma%' ;

C : SELECT customer_ name FROM customers WHERE customer_ name='*Ma*';

D : SELECT customer_ name FROM customers WHERE UPPER (customer_ name ) LIKE 'MA*. ;

E : SELECT customer_ name FROM customers WHERE customer name LIKE 'Ma*';

F : SELECT customer_ name FROM customers WHERE UPPER (customer name) LIKE 'MA&';

G : SELECT customer_ name FROM customers WHERE customer_ name KIKE .*Ma*';

Answer: B,D

Confidently Practice Online with Free 1Z0-071 Exam Cram

Buying Options: