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

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 contents of the oraInst.loc file to verify the steps performed by OUI.
• B.Compare the contents of the installActions.log file with that of the response file.
• C.Refer to the alert log file for information regarding the actions performed by OUI during installation.
• D.Compare the contents of the install.log file with the response file.

You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings, you find that the following parameter has been set in the parameter file of the database:
REMOTE_OS_AUTHENT = TRUE
What could have been the reason to set this parameter as TRUE?

• A.to enable the administration of the operating system from a remote client
• B.to enable operating system authentication for a remote client
• C.to allow the start up and shut down of the database from a remote client
• D.to disable the administration of the operating system from a remote client
• E.to restrict the scope of administration to identical operating systems

Which two statements are true regarding the database in ARCHIVELOG mode? (Choose two.)

• A.Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
• B.Archiving information is written to the data files and redo log files.
• C.You can perform complete database backups without closing the database.
• D.All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.
• E.You have to shut down the database to perform the backups.

In the middle of a transaction, a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario? (Choose two.)

• A.Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.
• B.PMON rolls back the transaction and releases the locks.
• C.The transaction is rolled back by the next session that refers to any of the blocks updated by the failed transaction.
• D.SMON rolls back the transaction and releases the locks.
• E.Event Viewer gives more details on the failure.
• F.The alert log file gives detailed information about the failure.

The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year-end tax and interest calculation process, all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200,000, and then send an alert message to the administrator. Which method would you suggest to the bank for achieving this task?

• A.performing standard database auditing to audit SQL statements with granularity level set to ACCESS
• B.implementing fine-grained auditing with audit condition and event handler
• C.performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDED
• D.implementing value-based auditing by using triggers