当前分类： 1z0-043
问题：单选题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...
查看答案
问题：单选题A media failure has occurred. This has resulted in all the members of the next log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）A The database allows only q...
问题：You are connected to Recovery Manager （RMAN） without a recov...
问题：单选题You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back...
问题：多选题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...
问题：单选题Matthew has recently joined NetFx Corporation as a junior-level Database Administrator （DBA）. He is asked by his supervisor to verify the database for data block corruptions. He uses the DBVERIFY utility and finds that two data blocks are corrupted in ...
问题：单选题In which scenario will you issue the following command？（） SQL RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING BACKUP CONTROLFILE；A when all the control files are missing and only a binary backup of the current control file exists...
问题：A user executes a query on the EMP table， which contains tho...
问题：单选题You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）A It would return information regarding only the last committed transaction.B It would...
问题：单选题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....
问题：多选题You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD. The default format of which two data types would be affected by this setting？ （）ADATEBTIMESTAMPCINTERVAL YEAR TO MONTHDINTERVAL DAY TO SECONDETIMESTAMP...
问题：多选题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 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...
问题：单选题Your system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object...
问题：In your production database you want to use an Automatic Sto...
问题：What purpose would you achieve by enabling the block change ...
问题：In your database， all the tablespaces are locally managed. Y...
问题：In Recovery Manager （RMAN）， you set the retention policy to ...
问题：单选题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...
问题：You are performing a block media recovery on the tools01.dbf...
