Which three statements are true regarding indexes?

• A.When a table is dropped and is moved to the RECYCLE BIN, all Indexes built on that table are permanently dropped.
• B.A table belonging to one user can have an index that belongs to a different user,
• C.An update to a table can result in updates to any or all of the table's indexes.
• D.A UNIQUE index can be altered to be non-unique.
• E.A SELECT statement can access one or more indices without accessing any tables.
• F.An update to a table can result in no updates to any of the table's indexes.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure in the DEPARTMENTS tables. (Choose two.)

Examine this SQL statement:
SELECT department_id "DEPT_ID", department_name, 'b' FROM
departments
WHERE departments_id=90
UNION
SELECT department_id, department_name DEPT_NAME, 'a' FROM
departments
WHERE department_id=10
Which two ORDER BY clauses can be used to sort output?

• A.ORDER BY 'b';
• B.ORDER BY DEPT_NAME;
• C.ORDER BY 3;
• D.ORDER BY DEPT_ID;

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the BOOKS_TRANSACTIONStable:

You want to display the member IDs, due date, and late fee as $2 for all transactions.
Which SQL statement must you execute?
SELECT member_id AS MEMBER_ID, due_date AS DUE_DATE, $2 AS LATE_FEE FROM

• A.BOOKS_TRANSACTIONS;
  SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", '$2' AS "LATE FEE"
• B.BOOKS_TRANSACTIONS;
• C.BOOKS_TRANSACTIONS;
  SELECT member_id 'MEMBER ID', due_date 'DUE DATE', '$2 AS LATE FEE' FROM
• D.FROM BOOKS_TRANSACTIONS;
  SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", $2 AS "LATE FEE" FROM

Comment: *

Name: *

Email: *

Verification: *

Which three are true about the CREATE TABLEcommand? (Choose three.)

• A.It can include the CREATE..INDEXstatement for creating an index to enforce the primary key constraint
• B.It implicitly executes a commit
• C.A user must have the CREATE ANY TABLEprivilege to create tables
• D.It implicitly rolls back any pending transactions
• E.The owner of the table should have space quota available on the tablespace where the table is defined
• F.The owner of the table must have the UNLIMITED TABLESPACEsystem privilege

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the description of SALES and PROMOTIONS tables.

You want to delete rows from the SALES table, where the PROMO_NAME column in the PROMOTIONS table has either blowout sale or everyday low price as values.
Which three DELETE statements are valid? (Choose three.)

• A.DELETEFROM salesWHERE promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'blowout sale')OR promo_name = 'everyday low price');
• B.DELETEFROM salesWHERE promo_id = (SELECT promo_idFROM promo_name = 'blowout sale')AND promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'everyday low price')FROM promotionsWHERE promo_name = 'everyday low price');
• C.DELETEFROM salesWHERE promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'blowout sale')OR promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = 'everyday low price')
• D.DELETEFROM salesWHERE promo_id IN (SELECT promo_idFROM promotionsWHERE promo_name IN = 'blowout sale','everyday low price'));

Comment: *

Name: *

Email: *

Verification: *