当前分类： 1z0-043
问题：单选题You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does th...
查看答案
问题：单选题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...
问题：You have configured Automatic Shared Memory Management. Whic...
问题：单选题You want to rebuild a free list in the free lists of the EMPLOYEE table in the Scott schema. Which package will you use to accomplish this？（）A DBMS_REPAIRB DBMS_SCHDULERC DBMS_STATSD DBMS_RESOURCE_MANAGER...
问题：You are connected to Recovery Manager （RMAN） without a recov...
问题：In the parameter file of your production database， the CONTR...
问题：Twenty database users are connected to your database. Five o...
问题：单选题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....
问题：Exhibit， Viewing the Exhibit and examine the Flashback Datab...
问题：In your database， all the tablespaces are locally managed. Y...
问题：You are performing a block media recovery on the tools01.dbf...
问题：单选题You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）A The time when the last flashback operation in your database was performed...
问题：单选题You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that coordinates the sizing of the memory components？（）A MMA...
问题：While creating a scheduler window using the DBMS_SCHEDULER p...
问题：多选题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 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 Recovery Manager （RMAN）， you set the retention policy to ...
问题：多选题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...
问题：单选题View the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？"） in the Flashback Database architecture.（）A DBWnB RVWRC ARCHD RECOE TRWR...
问题：单选题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...
