当前分类： 1z0-043
问题：You are connected to Recovery Manager （RMAN） without a recov...
查看答案
问题：单选题The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Whic...
问题：单选题By using the transaction identifier provided by （） for a particular row change， you can use theFlashback Transaction Query to see the operation performed by the transaction.A Flashback TableB Flashback DatabaseC Flashback Versions QueryD the RMAN REPOR...
问题：You have created a job class， CUST_JOB_1， with two jobs， CUS...
问题：单选题The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）A The Oracle database will check all data blocks by going through th...
问题：单选题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 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 the parameter file of the production database， the BACKGR...
问题：单选题You executed the following code： BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE （ NAME = ’JOB_A’， ATTRIBUTE = ’JOB_PRIORITY’， VALUE = 7）； END； / After analyzing the above code， what conclusion will you draw？（）A The code will be executed successfull...
问题：In your database， all the tablespaces are locally managed. Y...
问题：多选题You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT requir...
问题：多选题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...
问题：In Recovery Manager （RMAN）， you set the retention policy to ...
问题：单选题The SPFILE for your database contains the following parameter settings： SGA_TARGET = 1000M DB_CACHE_SIZE = 512M SHARED_POOL_SIZE = 128M LOG_BUFFER = 10M DB_8K_CACHE_SIZE = 50M What is the total memory that can be distributed across the auto...
问题：You are maintaining the PROD database of NetFx Corporation. ...
问题：You are maintaining the database of a company. The listener ...
问题：You are using an Automatic Storage Management （ASM） instance...
问题：In which of the following scenarios is a tablespace recovery...
问题：You are performing a block media recovery on the tools01.dbf...
问题：The database is currently running in the NOARCHIVELOG mode. ...
