1Z0-042報關(guān)編碼每日一練(2020.03.29)

來源：考試資料網(wǎng)

1 What are the consequences of executing the SHUTDOWN ABORT command？（）

2 You work as a database administrator for Certkiller .com. In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）

點擊查看答案

3 As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）

點擊查看答案

4 You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）

點擊查看答案

5 You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）

點擊查看答案