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

The employee IDs of employees who have made sales in the company are transferred from the EMPLOYEES table to the BONUS table with a default bonus value. Later, the human resources department decides to give bonuses to employees as per the following conditions:
1.Employees with a salary of $8,000 or less should receive a bonus.
2.Employees who have not made sales get a bonus of 1% of their salary.
3.Employees who already made sales get an increase in their bonus equal to 1% of their salary.
What would you do to implement these changes in one step?

• A.Use the MERGE statement.
• B.Use a correlated UPDATE statement.
• C.Use a multitable insert operation.
• D.Use SQL*Loader utility.

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

User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to? (Choose two.)

• A.ROW EXCLUSIVE lock for the row being updated
• B.shared row-exclusive lock for the row being updated
• C.null lock on the row being updated
• D.exclusive table-level lock for the table containing the row
• E.ROW SHARE lock for the row being updated
• F.null lock on the table containing the row
• G.a shareable table lock for the table containing the row

The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task, SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this change to the table affect the index?

• A.The index becomes invalid after the update.
• B.An update in a leaf row takes place.
• C.A row in the leaf block of the index for the key value is deleted and inserted.
• D.The leaf block containing the row to be updated is marked as invalid.

You specified segment space management as automatic for a tablespace. What effect would this have on space management?

• A.The segment would be managed by the freelists.
• B.Extents would be managed by the freelists.
• C.The segment would be managed by bitmaps.
• D.Free space would be managed by the data dictionary.