Examine the data in the COLORStable:

Examine the data in the BRICKStable:

Which two queries return all the rows from COLORS? (Choose two.)

• A.
• B.
• C.
• D.
• E.

Comment: *

Name: *

Email: *

Verification: *

Examine the commands used to createDEPARTMENT_DETAILS andCOURSE_DETAILS:

You want to generate a list of all department IDs along with any course IDs that may have
been assigned to them.
Which SQL statement must you use?
A)

B)

C)

D)

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

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the details of PRODUCT_INFORMATIONtable.
PRODUCT_NAME CATEGORY_ID SUPPLIER_ID
Inkjet C/8/HQ 12 102094
Inkjet C/4 12 102090
LaserPro 600/6/BW 12 102087
LaserPro 1200/8/BW 12 102099
Inkjet B/6 12 102096
Industrial 700/ID 12 102086
Industrial 600/DQ 12 102088
Compact 400/LQ 12 102087
Compact 400/DQ 12 102088
HD 12GB /R 13 102090
HD 10GB /I 13 102071
HD 12GB @7200 /SE 13 102057
HD 18.2GB @10000 /E 13 102078
HD 18.2GB @10000 /I 13 102050
HD 18GB /SE 13 102083
HD 6GB /I 13 102072
HD 8.2GB@5400 13 102093
You have the requirement to display PRODUCT_NAMEfrom the table where the CATEGORY_IDcolumn has values 12or 13, and the SUPPLIER_IDcolumn has the value 102088. You executed the following SQL statement:
SELECT product_name
FROM product_information
WHERE (category_id = 12 AND category_id = 13) AND supplier_id = 102088; Which statement is true regarding the execution of the query?

• A.It would execute but the output would return no rows.
• B.It would execute and the output would display the desired result.
• C.It would not execute because the same column has been used in both sides of the ANDlogical operator to form the condition.
• D.It would not execute because the entire WHEREclause condition is not enclosed within the parentheses.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the CUSTOMERS table:
Which three statements will do an implicit conversion?

• A.SELECT * FROM customers WHERE insert_date'01-JAN-19';
• B.SELECT * FROM customers WHERE TO_DATE(insert_date)=DATE'2019-01-01';
• C.SELECT * FROM customers WHERE TO_CHAR(customer_id)='0001';
• D.SELECT * FROM customers WHERE customer_id=0001;
• E.SELECT * FROM customers WHERE customer_id='0001';
• F.SELECT * FROM customers WHERE insert_date=DATE'2019-01-01';

Comment: *

Name: *

Email: *

Verification: *

You execute the SQL statement:

What is the outcome?

• A.It succeeds and CITY can contain only 'SEATTLE' or null for all rows.
• B.It fails because the condition for the CNAMES constraint is not valid.
• C.It fails because the NOT NULL and DEFAULT options cannot be combined for the same column.
• D.It succeeds and an index is created for CITIZEN_ID.

Comment: *

Name: *

Email: *

Verification: *