View the Exhibit and examine the structure of the EMPtable 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_NAMEcolumn can be dropped even if it is part of a composite PRIMARY KEYprovided the CASCADEoption is added to the SQL statement.
• B.The FIRST_NAMEcolumn would be dropped provided at least one column remains in the table.
• C.The FIRST_NAMEcolumn would be dropped provided it does not contain any data.
• D.The drop of the FIRST_NAMEcolumn can be rolled back provided the SET UNUSEDoption is added to the SQL statement.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true regarding the COUNT function? (Choose two.)

• A.A SELECT statement using COUNT function with a DISTINCT keyword cannot have a WHERE clause
• B.COUNT(*) returns the number of rows including duplicate rows and rows containing NULL value in any of the columns
• C.COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column
• D.The COUNT function can be used only for CHAR, VARCHAR2 and NUMBER data types
• E.COUNT(cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID column

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the BOOKS_ TRANSACTIONS table:
Examine the SQL statement:
Which statement is true about the outcome?

• A.It displays details for members who have borrowed before today with RM as TRANSACTION_TYPE and the details for members A101 or A102.
• B.It displays details for members who have borrowed before today's date with either RM as TRANSACTION_TYPE or MEMBER_ID as A101 and A102.
• C.It displays details for only members A101and A102 who have borrowed before today with RM as TRANSACTION_TYPE.
• D.It displays details only for members who have borrowed before today with RM as TRANSACTION_TYPE.

Comment: *

Name: *

Email: *

Verification: *

View the exhibits and examine the structures of the COSTSand PROMOTIONStables.


Evaluate the following SQL statement:
SQL> SELECT prod_id FROM costs
WHERE promo_id IN (SELECT promo_id FROM promotions
WHERE promo_cost < ALL
( SELECT MAX(promo_cost) FROM promotions
GROUP BY (promo_end_date-
promo_begin_date)));
What would be the outcome of the above SQL statement?

• A.It displays prod IDs in the promos with the lowest cost in the same time interval.
• B.It displays prod IDs in the promos with the highest cost in the same time interval.
• C.It displays prod IDs in the promo with the lowest cost.
• D.It displays prod IDs in the promos which cost less than the highest cost in the same time interval.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the BOOKS_TRANSACTIONS table:

Examine this partial SQL statement:
SELECT * FROM books_transactions
Which two WHERE conditions give the same result?

• A.WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN ('A101', 'A102');
• B.WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' AND member_id = 'A101' OR member_id = 'A102');
• C.WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' OR member_id IN ('A101', 'A102'));
• D.WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' AND (member_id = A101' OR member_id = 'A102'));
• E.WHERE (borrowed_date = SYSDATE AND transaction_type = 'RM') OR member_id IN ('A101', 'A102');

Comment: *

Name: *

Email: *

Verification: *