QUESTION: 243

Examine these statements executed in a single Oracle session:

Which three statements are true?

The code for pen is 1.
There is no row containing pencil.
The code for fountain pen is 3.
The code for pen is 10.
There is no row containing fountain pen.
There is no row containing pen.

Answer(s): A,B,C

Show Answer Next Question

QUESTION: 242

The SALES table has columns PROD_ID and QUANTITY_SOLD of data type NUMBER.

Which two queries execute successfully?

SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING COUNT(*) >10;
SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY prod_id HAVING COUNT(*) >10;
SELECT COUNT (prod_id) FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;
SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY COUNT(*) >10;
SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold > 55000;

Answer(s): A,C

Show Answer Next Question

QUESTION: 241

Which CREATE TABLE statement is valid?

Option A
Option B
Option C
Option D

Answer(s): D

Show Answer Next Question

Examine the description of the CUSTOMERS table:

CUSTNO is the PRIMARY KEY.

You must determine if any customers’ details have been entered more than once using a different CUSTNO, by listing all duplicate names.

Which two methods can you use to get the required result?