Which three statements are true about the DESCRIBEcommand? (Choose three.)

• A.It displays the NOT NULLconstraint for any columns that have that constraint
• B.It displays all constraints that are defined for each column
• C.It displays the PRIMARY KEYconstraint for any column or columns that have that constraint
• D.It can be used only from SQL*Plus
• E.It can be used from SQL Developer
• F.It can be used to display the structure of an existing view

Comment: *

Name: *

Email: *

Verification: *

Examine the data in the ORD_ITEMS table:

Evaluate this query:

Which statement is true regarding the result?

• A.It displays the item nos with their average quantity where the average quantity is more than double the minimum quantity of that item in the table.
• B.It returns an error because all the aggregate functions used in the HAVINGclause must be specified in the SELECT list.
• C.It displays the item nos with their average quantity where the average quantity is more than double the overall minimum quantity of all the items in the table.
• D.It returns an error because the HAVINGclause should be specified after the GROUP BYclause.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the SALES and PRODUCTS tables. (Choose two.)

In the SALES table, PROD_ID is the foreign key referencing PROD_ID in the PRODUCTS table. You must list each product ID and the number of times it has been sold.
Examine this query which is missing a JOIN operator:

Which two JOIN operations can be used to obtain the required output?

• A.LEFT OUTER JOIN
• B.JOIN
• C.FULL OUTER JOIN
• D.RIGHT OUTER JOIN

Comment: *

Name: *

Email: *

Verification: *

Which two are true about global temporary tables?

• A.They can be created only by a user with the DBA role,but can be accessed by all users who can create a session.
• B.If the ON COMMIT clause Is transaction-specific, all rows in the table are deleted alter each COMMIT or ROLLBACK.
• C.Their data is always stored in the default temporary tablespace of the user who created them.
• D.If the ON COMMIT clause is session-specific,the table is dropped when the session is terminated.
• E.Indexes can be created on them.
• F.Backup and recovery operations are available for these tables.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the MEMBERS table.

Which query can be used to display the last names and city names only for members from the states MO and MI?

• A.SELECT last_name, city FROM members WHERE state LIKE 'M%';
• B.SELECT DISTINCT last_name, city FROM members WHERE state ='MO' OR state ='MI';
• C.SELECT last_name, city FROM members WHERE state IN ('MO', 'MI');
• D.SELECT last_name, city FROM members WHERE state ='MO' AND state ='MI';

Comment: *

Name: *

Email: *

Verification: *