QUESTION 25

QUESTION 26 Which three statements are true about roles?

QUESTION 27 Which three statements are true about Data Manipulation Language (DML)?

QUESTION 29 Which two statements are true about INTERVAL data types?

QUESTION 30Which two statements are true about Enterprise Manager (EM) Express?

QUESTION 31 The ORDERS table has a column ORDER_DATE of data type DATE. The default display format for a date is DD-MON-RR. Which two WHERE conditions demonstrate the correct usage of conversion functions?

QUESTION 32 Which three statements are true regarding the UNION and UNION ALL operators?

QUESTION 33 Examine the description of the PRODUCT STATUS table: The STATUS column contains the values 'IN STOCK' or 'OUT OF STOCK' for each row . Which two queries will execute successfully?

QUESTION 34 Examine this description of the BOOKS table containing 100 rows:

QUESTION 35 Which two statements are true about UNDO and UNDO tablespaces?

QUESTION 36 Which three statements are true about data block storage in an Oracle Database?

QUESTION 37 While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system. The database was then opened. Which two statements are true?

QUESTION 38 Which two statements are true about space-saving features in an Oracle Database? (Choose two .)

QUESTION 39 Which two statements are true about the PMON background process? (Choose two .)

QUESTION 41 The ORCL database has RESUMABLE TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA. U1 executes this command : SQL> CREATE TABLE t1 AS (SELECT object_name , sharing , created FROM dba_objects); U1 complains that the command is taking too long to execute. In the alert log, the database administrator ( DBA) finds this: 2017-03-06T12:15:17 . 183438+05:30 statement in Resumable session ‘ User U1( 136) , Session 1 , Instance 1 ’ was suspended due to ORA-01536: space quota exceeded for tablespace ‘ DATA ’ Which are three actions any one of which the DBA could take to resume the session? (Choose three .)