Online Access Free 1z1-061 Exam Questions

Evaluate the following query:

What would be the outcome of the above query?

• A.It executes successfully and introduces an 's at the end of each PROMO_NAME in the output.
• B.It produces an error because flower braces have been used.
• C.It produces an error because the data types are not matching.
• D.It executes successfully and displays the literal "{'s start date was \} * for each row in the output.

Which statement is true regarding sub queries?

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

View the Exhibit and examine the description of SALES and PROMOTIONS tables.

You want to delete rows from the sales table, where the PROMO_NAME column in the promotions table has either blowout sale of everyday low prices as values.
Which three delete statements are valid?

• A.Option B
• B.Option C
• C.Option A
• D.Option D

View the Exhibit and examine the structure and data in the INVOICE table.

Which two statements are true regarding data type conversion in expressions used in queries? (Choose two.)

• A.CONCAT (inv_amt, inv_date): requires explicit conversion
• B.inv_date = '15-february-2008': uses implicit conversion
• C.inv_date > '01-02-2008': uses implicit conversion
• D.inv_amt ='0255982': requires explicit conversion
• E.inv_no BETWEEN '101' AND '110': uses implicit conversion

SLS is a private synonym for the SH.SALES table.
The user SH issues the following command:
DROP SYNONYM sls;
Which statement is true regarding the above SQL statement?

• A.The synonym would be dropped and the packages referring to the synonym would be dropped.
• B.Only the synonym would be dropped.
• C.The synonym would be dropped and any PUBLIC synonym with the same name becomes invalid.
• D.The synonym would be dropped and the corresponding table would become invalid.