1Z0-042單項選擇題每日一練(2019.01.22)

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

1 In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）

點擊查看答案

2 You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）

點擊查看答案

3 You work as a database administrator for Supportcenter.cn. In your production database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task？（）

點擊查看答案

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 Certkiller .com. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows：
ERROR at Line 1：
ORA-10635： Invalid segment ortablespacetype What could be the reason？（）

點擊查看答案

广告位招租联系QQ:5245112（WX同号）

关注公众号"赞题库"联系在线客服

湘公网安备 43010202000353号湘ICP备14005140号-2

客服中心

扫一扫免费做题