Online Access Free 1Z0-072 Practice Test

Yom database is in ARCHIEVELOG mode. The USER)! tablespace is online in read write and no error conditions exists for any of its data files.
You want to take USER01 offline so that all existing transactions involving objects in it can complete. What must yon do?

• A.Change its state to read only, and then take it offline with the immediate option.
• B.Take it offline with the immediate option.
• C.Take it offline with the normal option.
• D.Take it offline with the temporary option.
• E.Change its state to read only, and then take it offline with the temporary option.
• F.Change its state to read only, and then take it offline with the normal option.

A database is configured to use automatic undo management with temporary undo enabled. An update is executed on a heap-organized table stored in the TBS1 tablespace. Where is the undo stored?

• A.in the SYSAUX tablespace
• B.in the undo tablespace
• C.in rollback segments
• D.in the temporary tablespace
• E.in the redo logs

TBS1 is a permanent user-defined tablespace created with Oracle Managed Files (OMF).
Examine this command:
DROP TABLESPACE tbs1;
Which is required to ensure that TBS1 is dropped and its datafiles are deleted from their file system?

• A.DB_CREATE_FILE_DEST must refer to an Oracle Automatic Storage Management (ASM)disk group.
• B.Objects in TBS1 must not be in use when the command is executed.
• C.TBS1 must not contain any temp files.
• D.The INCLUDING CONTENTS AND DATAFILES clause must be added to the command.
• E.TBS1 must be placed in READ ONLY state.

Which two are true about conventional path SQL load? (Choose two.)

• A.It does not generate UNDO.
• B.It locks objects being processed.
• C.It cannot load data into clustered tables.
• D.It always generates redo.
• E.It enforces referential integrity constraints.

In a database, the default temporary tablespace is TEMP and USER1's default tablespace is DATA.
Examine these parameters:

Which tablespace stores UNDO generated by USER1's DML on temporary tables?

• A.DATA
• B.SYSTEM
• C.TEMP
• D.UNDOTBS1
• E.SYSAUX