Which three object types support deferred segment creation? (Choose three.)

• A.clustered tables
• B.index organized tables
• C.temporary tables
• D.external tables
• E.partitioned tables
• F.heap organized tables

Comment: *

Name: *

Email: *

Verification: *

A user complains about poor database performance. You suspect that the user's session is waiting for an event to complete.
You want to verify this.
Which two views may reveal for what the user's session is currently waiting? (Choose two.)

• A.V$SESSION_WAIT
• B.V$SESSION_EVENT
• C.V$SESSION_WAIT_CLASS
• D.V$SYSTEM_EVENT
• E.V$SESSION

Comment: *

Name: *

Email: *

Verification: *

Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)

• A.SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;
• B.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;
• C.SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100
  "DUES AMOUNT" FROM transactions;
• D.SELECT customer_id AS `CUSTOMER-ID', transaction_date AS DATE, amount + 100 `DUES AMOUNT' FROM transactions;
• E.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about interval data types?

• A.INTERVAL year to month columns only support monthly Intervals within a single year.
• B.INTERVAL year to month columns only support monthly intervals within a range of years.
• C.The year field in an interval year to month column must be a positive value.
• D.The value in an interval day to SECOND column can be copied into an interval year to month column.
• E.INTERVAL day to second columns support fractions of seconds.
• F.INTERVAL year TO month columns support yearly intervals.

Comment: *

Name: *

Email: *

Verification: *

You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE '/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)

• A.It uses the database default blocksize
• B.It must be smaller than the smallest BIGFILE tablespace
• C.Any data files added to the tablespace must have a size of 5 gigabytes
• D.Free space is managed using freelists
• E.It is a locally managed tablespace

Comment: *

Name: *

Email: *

Verification: *