当前分类： 1z0-043
问题：单选题Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back t...
查看答案
问题：You are connected to Recovery Manager （RMAN） without a recov...
问题：Users in your production database complain that they are get...
问题：You are performing a block media recovery on the tools01.dbf...
问题：多选题You have created a job class， CUST_JOB_1， with two jobs， CUST_JOB_1_A and CUST_JOB_1_B. Which two statements are true？ （）AThe member jobs would get dropped when the job class is dropped.BBoth the jobs would be executed concurrently.CThe member jobs wou...
问题：You are maintaining your database in Oracle10g. You are perf...
问题：单选题In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead. What kind of database structure would you ...
问题：单选题A junior level Database Administrator erroneously deleted the database alert log while users were accessing the database. Which action should you take to recover the alert log？（）A Do nothing.B Restart the database.C Perform recovery on the database....
问题：In Recovery Manager （RMAN）， you set the retention policy to ...
问题：多选题You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）； Which two statements are correct？ （）AThe FLASHBACK TABLE statement will not be written to the alert log file.BThe EMP table that was dropped by mi...
问题：单选题In which of the following scenarios is a tablespace recovery required？（）A when recovering a lost read-only tablespace from a read-only tablespace backupB when recovering a lost read-only tablespace from a read-write tablespace backup when the databas...
问题：单选题You defined the Recovery Manager （RMAN） retention policy to recovery window of 7 days by executing the following command： RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS； When a backup is performed， what would be the status of this backu...
问题：Your Oracle Database 10g is online when you execute the foll...
问题：多选题For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）AUPDATE TABLEBCREATE CLUSTERCTRUNCATE TABLEDALTER TABLE MOVEEINSERT INTO···VALUESFALTER TABLE···DROP COLUMNGALTER TABLE···DROP PARTITION...
问题：多选题You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN BACKUP TABLESPACE DETTBS; Under which conditions would this command execute successfully？ （）AThe database is in NOMOUNT state.BThe databa...
问题：单选题You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）A You must enable the row movement on the SCOTT.EMP ...
问题：单选题You defined the Recovery Manager （RMAN） retention policy to recovery window of 7 days by executing the following command： RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; When a backup is performed， what would be the status of this backu...
问题：In your database， all the tablespaces are locally managed. Y...
问题：单选题You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting？（）A The SQL trace facility will generate the performance statistics for all the SQL statements fo...
