Online Access Free 1Z0-042 Exam Questions

What are the consequences of executing the SHUTDOWN ABORT command? (Choose two.)

• A.The database files are synchronized.
• B.Database buffers and redo buffers are not written to the disk.
• C.The database undergoes automatic media recovery during the next startup.
• D.Uncommitted changes are not rolled back.
• E.The database is closed, but the instance is still started.

Because of a power outage, instance failure has occurred. From what point in the redo log does recovery begin and where does it end?

• A.current redo log and inactive redo log
• B.beginning of redo log to end of redo log
• C.checkpoint position to end of redo log
• D.beginning of redo log to checkpoint position
• E.all redo logs before the point of last commit

You are working on an online transaction processing (OLTP) system. You notice that a PL/SQL procedure got executed twice at 2:00 p.m. This has incorrectly updated the EMP_SAL table. How would you revert the table to its state at 2:00 p.m.?

• A.Perform point-in-time recovery to 2:00 p.m.
• B.Use Flashback Table feature to revert the changes.
• C.Issue the rollback statement with system change number (SCN).
• D.Restore the entire database from the recent backup and open it.

Which two statements are true regarding a PL/SQL package body? (Choose two.)

• A.It cannot be created without a package specification.
• B.It can be changed and recompiled without making the package specification invalid.
• C.It can contain only the subprograms defined in the package specification.
• D.It cannot invoke subprograms defined in other packages.

You created a response file and want to check it before starting installations in silent mode. You started installation of Oracle software in interactive mode by providing the response file. In the middle of the installation, you realize that the behavior of the Oracle Universal Installer (OUI) is not consistent with the response file. What action would you take to detect the cause of this behavior?

• A.Refer to the alert log file for information regarding the actions performed by OUI during installation.
• B.Compare the contents of the installActions.log file with that of the response file.
• C.Compare the contents of the install.log file with the response file.
• D.Refer to the contents of the oraInst.loc file to verify the steps performed by OUI.