Which two statements are true regarding multiple-row subqueries? (Choose two.)

• A.They should not be used with the NOT IN operator in the main query if NULL is likely to be a part of the result of the subquery.
• B.They always contain a subquery within a subquery.
• C.They use the < ALL operator to imply less than the maximum.
• D.They can be used to retrieve multiple rows from a single table only.
• E.They can contain group functions.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the data in the PRODUCTS table.

You must display product names from the PRODUCTS table that belong to the 'Software/other' category with minimum prices as either $2000 or $4000 and with no unit of measure.
You issue this query:

Which statement is true?

• A.It executes successfully and returns the required result.
• B.It executes successfully but returns no result.
• C.It generates an error because the condition specified for the PROD_CATEGORY column is not valid.
• D.It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.

Comment: *

Name: *

Email: *

Verification: *

You execute the following commands:

For which substitution variables are you prompted for the input?

• A.None, because no input required
• B.Both the substitution variables 'hiredate' and 'mgr_id\
• C.Only 'hiredate'
• D.Only 'mgr_id'

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the SALES table:

The SALES table has 55,000 rows.
Examine this statement:

Which two statements are true?

• A.SALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table.
• B.SALES1 is created with no rows.
• C.SALES1 is created with 55,000 rows.
• D.SALES1 is created with 1 row.
• E.SALES1 has PRIMARY KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true? (Choose three.)

• A.The data dictionary is created and maintained by the database administrator.
• B.Data dictionary views consist of joins of dictionary base tables and user-defined tables.
• C.The usernames of all users including database administrators are stored in the data dictionary.
• D.The USER_CONS_COLUMNS view should be queried to find the names of columns to which constraints apply.
• E.Both USER_OBJECTS and CAT views provide the same information about all objects that are owned by the user.
• F.Views with the same name but different prefixes, such as DBA, ALL and USER, reference the same base tables from the data dictionary.

Comment: *

Name: *

Email: *

Verification: *