Online Access Free 1z0-061 Practice Test

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

Examine the following two SQL statements:

Which statement is true regarding the above two SQL statements?

• A.statement 1 and statement 2 execute successfully and give the same output
• B.statement 1 and statement 2 execute successfully and give a different output
• C.statement 2 gives an error, statement 1 executes successfully
• D.statement 1 gives an error, statement 2 executes successfully

View the Exhibit and examine the structure of the PROMOTIONS table. Evaluate the following SQL statement:

The above query generates an error on execution.
Which clause in the above SQL statement causes the error?

• A.SELECT
• B.GROUP BY
• C.WHERE
• D.ORDER BY

Examine the structure of the sales table:

Evaluate the following create table statement:

Which two statements are true about the creation of the SALES1 table?

• A.The SALES1 table is created with no rows but only a structure.
• B.The SALES1 table would not be created because of the invalid where clause.
• C.The SALES1 table would have primary key and unique constraints on the specified columns.
• D.The SALES1 table would not be created because column-specified names in the select and create table clauses do not match,
• E.The SALES1 table would have not null and unique constraints on the specified columns.

View the Exhibit and examine the data in the PROMO_NAME and PROMO_END_DATE columns of the promotions table, and the required output format.

Which two queries give the correct result?

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

View the Exhibit and examine the structure of CUSTOMERS table.

Evaluate the following query:

Which statement is true regarding the above query?

• A.It executes successfully.
• B.It produces an error because conditions on the CUST_CREDIT_LIMIT column are not valid.
• C.It produces an error because the condition on the CUST_FIRST_NAME column is not valid.
• D.It produces an error because the condition on the CUST_CITY column is not valid.