问题:You observe that database performance has degraded over a pe...
查看答案
问题:单选题One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file. Which operation do you need to perform after re-creating the control file and opening the database?()A drop and re-create the...
问题:The Database Resource Manager is not currently active in you...
问题:You have created a job class, CUST_JOB_1, with two jobs, CUS...
问题:单选题You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6:00 P.M. on Monday, you issue the following command: RMANBACKUP DATABASE; At 8:00 A.M. on Tuesday, you are unable to st...
问题:The DB_BLOCK_CHECKINGinitialization parameter is set to TRUE...
问题:In which of the following scenarios is a tablespace recovery...
问题:单选题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...
问题:单选题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....
问题:多选题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...
问题:多选题The loss of which two types of files may require a recovery with the RESETLOGS option?()Acontrol filesBpassword fileCarchived log filesDsystem-critical data files for which all the redo entries are presentEnon-system-critical data files for which all t...
问题:In your database, all the tablespaces are locally managed. Y...
问题:单选题In an Oracle 10g database, the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics?()A Recovery catalogB Oracle Enterprise Man...
问题:You are performing a block media recovery on the tools01.dbf...
问题:You execute the following command to create two consumer gro...
问题:You are upgrading to the Oracle 10g Database and will use th...
问题:You are connected to Recovery Manager (RMAN) without a recov...
问题:You are maintaining the PROD database of NetFx Corporation. ...
问题:多选题You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP; How does RMAN find the control file autobackup?()ABy using the trace file.BBy using the alert log file.CBy using the datab...
问题:In Recovery Manager (RMAN), you set the retention policy to ...