Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

• A.Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
• B.Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
• C.Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO
• D.If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
• E.Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ

Comment: *

Name: *

Email: *

Verification: *

In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.
What will happen when the next update is attempted by any transaction?

• A.It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
• B.It succeeds and the generated undo is stored in SYSAUX.
• C.It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace
  'UNDOTBS1'".
• D.It succeeds and the generated undo is stored in SYSTEM.
• E.It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the PROMOTIONS table:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)

• A.SELECT DISTINCT promo_category || ` has ` || promo_cost AS COSTS FROM promotions ORDER BY 1;
• B.SELECT DISTINCT promo_cost || ' in ` || DISTINCT promo_category FROM promotions ORDER BY 1;
• C.SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
• D.SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
• E.SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;

Comment: *

Name: *

Email: *

Verification: *

The stores table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months. Which where clause can be used?

• A.WHERE ADD_MONTHS<start_date, 25) <= SYSDATE
• B.WHERE TO_XUMBER(start_date - SYSDATE) <= 25
• C.WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25
• D.WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25

Comment: *

Name: *

Email: *

Verification: *

In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

• A.Revoke the CREATE SESSION privilege from other users
• B.Revoke the CREATE SESSION privilege from user HR
• C.Log in to the database instance
• D.Grant the CREATE SESSION privilege with ADMIN OPTION to other users
• E.Execute DDL statements in the HR schema
• F.Execute DML statements in the HR schema

Comment: *

Name: *

Email: *

Verification: *