1Z1-182 試験問題を無料オンラインアクセス

Which two tasks can be performed in the NOMOUNT state?

• A.Full database recovery.
• B.Renaming data files.
• C.Enabling online redo log archiving.
• D.Creating a database.
• E.Re-creating control files.

Examine this command: ALTER DATABASE MOVE DATAFILE '/u01/sales01.dbf' TO '/u02/sales02.dbf'; Which two statements are true?

• A.It overwrites any existing file with the name sales02.dbf in /u02 by default.
• B.Compressed objects in sales01.dbf will be uncompressed in sales02.dbf after the move.
• C.DML may be performed on tables with one or more extents in this data file during the execution of this command.
• D.The "TO" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.
• E.Tables with one or more extents in this data file may be queried during the execution of this command.

Which two are benefits of external tables?

• A.The results of a complex join or aggregating function or both can be unloaded to a file for transportation to other systems.
• B.They can be queried while the database is in the MOUNT state like dynamic performance views.
• C.They support DELETEs, which transparently deletes records in the file system as if they were table rows.
• D.They support UPDATEs, which transparently updates records in the file system as if they were table rows.
• E.They can be queried, transformed, and joined with other tables without having to load the data first.

Which three are benefits of using temp UNDO when performing DML on global temporary tables?

• A.It reduces I/Os to the SYSTEM tablespace.
• B.It reduces the amount of UNDO stored in the UNDO tablespace.
• C.It permits DML on global temporary tables even if the database is opened read-only.
• D.It reduces the amount of redo generated.
• E.It reduces I/Os to the SYSAUX tablespace.

Which three statements are true about UNDO and REDO?

• A.Both REDO and UNDO can be multiplexed.
• B.REDO is used for instance recovery.
• C.REDO is used for read consistency.
• D.REDO is used for ROLLBACK.
• E.UNDO is used for read consistency.
• F.UNDO is used for some flashback operations.