1z1-061 무료 덤프문제 온라인 액세스

Evaluate this SQL statement:
SELECT e.emp_name, d.dept_name
FROM employees e
JOIN departments d
USING (department_id)
WHERE d.department_id NOT IN (10, 40)
ORDER BY dept_name;
The statement fails when executed. Which change fixes the error?

• A.replace the condition"d.department_id NOT IN (10, 40)"in the WHERE clause with"d.department_id <> 10 AND d.department_id <> 40"
• B.remove the table alias from the SELECT clause
• C.prefix the column in the USING clause with the table alias
• D.prefix the column in the ORDER BY clause with the table alias
• E.remove the table alias prefix from the WHERE clause
• F.remove the ORDER BY clause

Which two statements are true regarding the ORDER BY clause? (Choose two.)

• A.It cannot be used in a SELECT statement containing a HAVING clause.
• B.It is executed first in the query execution.
• C.You can specify a combination of numeric positions and column names in this clause.
• D.You cannot specify a column name followed by an expression in this clause.
• E.It must be the last clause in the SELECT statement.

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command?

• A.It fails because no SQL *Loader data file location is specified.
• B.It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
• C.It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
• D.It fails because no SQL *Loader control file location is specified.

A SELECT statement can be used to perform these three functions:
Which set of keywords describes these capabilities?

• A.difference, projection, join
• B.intersection, projection, join
• C.selection, intersection, join
• D.difference, projection, product
• E.selection, projection, join

Which statement is true regarding the COALESCE function?

• A.It returns the highest NOT NULL value in the list for all rows.
• B.It requires that all expressions in the list must be of the same data type.
• C.It can have a maximum of five expressions in a list.
• D.It requires that at least one of the expressions in the list must have a NOT NULL value.