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

Comment: *

Name: *

Email: *

Verification: *

Examine this command:
CREATE UNDO TABLESPACE undotbs01
DATAFILE 'undotbs_01.dbf'
SIZE 100M
AUTOEXTEND ON;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

• A.Add the SEGMENT SPACE MANAGEMENT AUTO clause
• B.Add the ONLINE clause
• C.Add the NOLOGGING clause
• D.Make certain that the database operates in automatic undo management mode
• E.Set UNDO_TABLESPACE to UNDOTBS01

Comment: *

Name: *

Email: *

Verification: *

You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command:
Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)

• A.You can reattach to it and monitor it
• B.It is paused and can be resumed
• C.It continues to run in the background
• D.It terminates
• E.You can no longer monitor it

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about views in an Oracle database? (Choose three.)

• A.Data Manipulation Language (DML) can always be used on views
• B.Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• C.The WITH CHECK clause prevents certain rows from being displayed when querying the view
• D.Tables in the defining query of a view must always exist in order to create the view
• E.Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• F.The WITH CHECK clause prevents certain rows from being updated or inserted
• G.Views can be updated without the need to re-grant privileges on the view

Comment: *

Name: *

Email: *

Verification: *

Examine this command:
SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT
Which two statements are true?

• A.Queries and DML statements are allowed on ORDERS while the shrink is executing.
• B.The shrink operation causes rows to be moved to empty space starting from the beginning of the orders segment.
• C.Dependent indexes become UNUSABLE.
• D.The high-water mark (HWM) of orders is adjusted.
• E.Only queries are allowed on ORDERS while the shrink is executing.
• F.The shrink operation causes rows to be moved to empty space starting toward the end of the orders segment.

Comment: *

Name: *

Email: *

Verification: *