Which three statements are true reading subqueries? (Choose three.)

• A.A Main query can have many subqueries.
• B.Only one column or expression can be compared between the subquery and main query.
• C.A subquery can have more than one main query.
• D.The subquery and main query must retrieve date from the same table.
• E.The subquery and main query can retrieve data from different tables.
• F.Multiple columns or expressions can be compared between the subquery and main query.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about rollbacks?

• A.Data Control L anguage (DCL) statements, such as GRANT and REVOKE, can be rolled back.
• B.A transaction interrupted by a system failure is automatically rolled back.
• C.If the ROLLBACK statement is used without TO SAVEPOINT, then all savepoints in the transaction are deleted .
• D.The ROLLBACK statement does not release locks resulting from table updates.
• E.Data consistency is not guaranteed after a rollback.

Comment: *

Name: *

Email: *

Verification: *

The sales table has columns prod_id and quantity_sold of data type number. Which two queries execute successfully?

• A.SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY prod_id HAVING COUNT(*) > 10;
• B.SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold > 55000;
• C.SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND
  COUNT(*) > 10 GROUP BY COUNT(*) > 10;
• D.SELECT prod Id FROH sales NHERE quantity sold > 55000 3RODI BY prod_id HAVING COUNT(*) > 10;
• E.SELECT COUNT(prod_id) FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index-organized table. (Choose two.)

Evaluate this SQL statement:
ALTER TABLE emp
DROP COLUMN first_name;
Which two statements are true?

• A.The FIRST_NAME column can be dropped even if it is part of a composite PRIMARY KEY provided the CASCADE option is added to the SQL statement.
• B.The FIRST_NAME column would be dropped provided it does not contain any data.
• C.The FIRST_NAME column would be dropped provided at least one column remains in the table.
• D.The drop of the FIRST_NAME column can be rolled back provided the SET UNUSED option is added to the SQL statement.

Comment: *

Name: *

Email: *

Verification: *

See the Exhibit and Examine the structure of the CUSTOMERS table:

Using the CUSTOMERS table, you need to generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should have the message "Not Available" displayed.
Which SQL statement would produce the required result?

• A.SELECT NVL(cust_credit_limit,'Not Available')*.15 "NEW CREDIT" FROM customers;
• B.SELECT NVL(cust_credit_limit*.15,'Not Available') "NEW CREDIT" FROM customers;
• C.SELECT TO_CHAR(NVL(cust_credit_limit*.15,'Not Available')) "NEW CREDIT" FROM customers;
• D.SELECT NVL(TO_CHAR(cust_credit_limit*.15),'Not Available') "NEW CREDIT" FROM customers;

Comment: *

Name: *

Email: *

Verification: *