Which two tasks require subqueries?

• A.Display suppliers whose PROD_LIST_PRICE is less than 1000.
• B.Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable.
• C.Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE.
• D.Display the total number of products supplied by supplier 102 which have a product status of obsolete.
• E.Display the minimum PROD_LIST_PRICE for each product status.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the BRICKS table;

Examine the description of the BRICKS_STAGE table;

Which two queries execute successfully?

• A.SELECT brick_id,shape FROM bricks
  MINUS
  SELECT WEIGHT,COLOR from bricks_stage;
• B.select * from bricks
  MINUS
  select * from bricks_stage;
• C.SELECT shape,color FROM bricks
  MINUS
  SELECT color,shape FROM bricks_stage;
• D.SELECT shape,color FROM bricks
  MINUS
  SELECT WEIGHT,color FROM bricks_stage;
• E.SELECT shape,color,weight from bricks
  MINUS
  SELECT * FROM bricks_stage;

Comment: *

Name: *

Email: *

Verification: *

Examine these requirements:
1. Display book titles for books purchased before January 17, 2007 costing less than 500 or more than 1000.
2. Sort the titles by date of purchase, starting with the most recently purchased book.
Which two queries can be used?

• A.SELECT book_title FROM books WHERE (price< 500 OR >1000) AND (purchase date< '17-JAN-2007') ORDER BY purchase date DESC;
• B.SELECT book_title FROM books WHERE (price IN (500, 1000)) AND (purchase date < '17-JAN-2007') ORDER BY purchase_date ASC;
• C.SELECT book_title FROM books WHERE (price NOT BETWEEN 500 AND 1000) AND (purchase_date< '17-JAN-2007') ORDER BY purchase_date DESC;
• D.SELECT book_title FROM books WHERE (price BETWEEN 500 AND 1000) AND (purchase_date<'17-JAN-2007') ORDER BY purchase_date;

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true regarding savepoints? (Choose two.)

• A.Savepoints can be used for both DML and DDL statements.
• B.Savepoints are effective for both COMMIT and ROLLBACK.
• C.Savepoints are effective only for COMMIT.
• D.Savepoints may be used to ROLLBACK.
• E.Savepoints can be used for only DML statements.

Comment: *

Name: *

Email: *

Verification: *

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

The following query is written to retrieve all those product IDs from the SALEStable that have more than
55000 sold and have been ordered more than 10 items.

Which statement is true regarding this SQL statement?

• A.It produces an error because COUNT (*)should be specified in the SELECTclause also.
• B.It executes successfully but produces no result because COUNT(prod_id)should be used instead of COUNT(*).
• C.It produces an error because COUNT (*)should be only in the HAVING clause and not in the WHERE clause.
• D.It executes successfully and generates the required result.

Comment: *

Name: *

Email: *

Verification: *