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

Evaluate the following SQL statement:

Which statement is true regarding the above query if one of the values generated by the subquery is null?

• A.It ignores the null value and generates output for the other values produced by the subquery.
• B.It generates output for null as well as the other values produced by the subquery.
• C.It produces an error.
• D.It executes but returns no rows.

Which statement is true regarding sub queries?

• A.=ANY and =ALL operators have the same functionality in multiple- row subqueries.
• B.The NOT IN operator is equivalent to IS NULL with single- row subqueries.
• C.The LIKE operator cannot be used with single- row subqueries.
• D.The NOT operator can be used with IN, ANY, and ALL operators in multiple- row subqueries.

View the Exhibit and examine the data in the costs table.

You need to generate a report that displays the IDs of all products in the costs table whose unit price is at least 25% more than the unit cost. The details should be displayed in the descending order of 25% of the unit cost.
You issue the following query:

Which statement is true regarding the above query?

• A.It executes and produces the required result.
• B.It produces an error because the DESC option cannot be used with an expression in the order by clause.
• C.It produces an error because an expression cannot be used in the order by clause.
• D.It produces an error because the expression in the ORDER by clause should also be specified in the SELECT clause.

Which two are true about aggregate functions? (Choose two.)

• A.You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
• B.You can use aggregate functions on a table, only by grouping the whole table as one single group.
• C.You cannot group the rows of a table by more than one column while using aggregate functions.
• D.You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
• E.You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
• F.You can use aggregate functions in any clause of a SELECT statement.

Which two statements complete a transaction? (Choose two)

• A.ROLLBACK TO SAVEPOINT C;
• B.DELETE employees;
• C.Select MAX(sal)FROM employeesWHERE department_id = 20;
• D.ALTER TABLE employeesSET UNUSED COLUMN sal;
• E.GRANT SELECT ON employees TO SCOTT;
• F.DESCRIBE employees;