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

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

1 User SCOTT wants to export his objects using Oracle Data Pump and executes the following command： $ expdp scott/tiger
directory = EXPORT_DIR
dumpfile = scott.dmp include = table
include = view："like ’%DEPARTMENTS%’"
content = DATA_ONLY
Which task would the command accomplish？（）

點擊查看答案

2 You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）

點擊查看答案

3 Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this situation？（）

點擊查看答案

4 You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）

點擊查看答案

5 You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）

點擊查看答案