Online Access Free 1z1-061 Exam Questions

Evaluate the following SQL statement:

Which statement is true regarding the outcome of the above query?

• A.It produces an error because positional notation cannot be used in the order by clause with set operators.
• B.It executes successfully and displays rows in the descending order of PROMO_CATEGORY.
• C.It produces an error because the order by clause should appear only at the end of a compound query-that is, with the last select statement.
• D.It executes successfully but ignores the order by clause because it is not located at the end of the compound statement.

The DBA issues this SQL command:
CREATE USER Scott
IDENTIFIED by tiger;
What privileges does the user Scott have at this point?

• A.All the privileges of a default user.
• B.Only the CONNECT privilege.
• C.No privileges.
• D.Only the SELECT privilege.

You want to write a query that accepts user input for columns and conditions every time it is executed.
The user needs to be promoted only once for the table input.
Which query provides the required result?

• A.SELECT &col1, col2FROM &&tableWHERE &condition = &cond;
• B.SELECT &col1, col2FROM "&&table"WHERE &condition = &cond;
• C.SELECT &col1, col2FROM &&tableWHERE &condition = &&cond;
• D.SELECT &col1, 'col2'FROM &tableWHERE &&condition = '&cond';

View the Exhibit and examine the structure of the CUSTOMERS table.
You want to generate a report showing the last names and credit limits of all customers whose last names start with A, B, or C, and credit limit is below 10, 000.
Evaluate the following two queries:

Which statement is true regarding the execution of the above queries?

• A.Only the second query gives the correct result.
• B.Both execute successfully and give the same result.
• C.Only the first query gives the correct result.
• D.Both execute successfully but do not give the required result.

For which action can you use the TO_DATE function?

• A.Convert any date to a character literal
• B.Convert any character literal to a date
• C.Convert any numeric literal to a date
• D.Convert any date literal to a date
• E.Format '10-JAN-99' to 'January 10 1999'