1Z0-042 무료 덤프문제 온라인 액세스

Which statement is true about the loss of system-critical data files in ARCHIVELOG mode?

• A.The data files can be recovered to the time of the most recent backup.
• B.The data file is taken offline automatically; the database remains open.
• C.The data files can be recovered till the last committed transaction.
• D.The data files can be recovered without shutting down the database.

Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option. Which statement is correct in this scenario?

• A.The operation would fail if tbs_1 were a read/write tablespace.
• B.The operation would fail if tbs_1 were the default tablespace for the database.
• C.If the above operation were successful, instance recovery would be required to bring the tablespace online.
• D.The operation would fail if tbs_1 were a read-only tablespace.
• E.If the above operation were successful, media recovery would be required to bring the tablespace online.

Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct? (Choose two.)

• A.If the tablespace is in the NOLOGGING mode, no operation on the tablespace will generate redo.
• B.The tablespace will be in the NOLOGGING mode by default, if not specified while creating a tablespace.
• C.The tablespace-level logging attribute can be overridden by logging specifications at the table, index, materialized view, materialized view log, and partition levels.
• D.This clause is not valid for a temporary or undo tablespace.

Which two statements regarding archive log destinations are true? (Choose two.)

• A.A maximum of 10 destinations can be specified.
• B.The archive logs must be written to all the destinations.
• C.The archiving information can be traced to the alert log file whenever the archiving to a destination is successful.
• D.The archive log files can be written only to local destinations.
• E.The number of archiving destinations must be equal to the number of archive processes (ARCn).

You want to refer the employee personal information stored in operating system(OS) files in EMPLOYEE table. You plan to add a new column to EMPLOYEE table to achieve this. Which data type would you use for the new column?

• A.LONG RAW
• B.BLOB
• C.CLOB
• D.BFILE