网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You are performing an incomplete recovery because certain important tables were deleted and purged from the Recycle Bin. In which mode will you perform the recovery？（）
A
MOUNT mode
B
RESTRICTED mode
C
OPEN mode
D
NOMOUNT mode
参考答案
参考解析
解析：
暂无解析
更多 “单选题You are performing an incomplete recovery because certain important tables were deleted and purged from the Recycle Bin. In which mode will you perform the recovery？（）A MOUNT modeB RESTRICTED modeC OPEN modeD NOMOUNT mode” 相关考题
考题
单选题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 return only the active transactions in all the undo segments in the database.C
It would return only the committed transactions in all the undo segments in the database. D
It would return both active and committed transactions in all the undo segments in the database.E
It would return information regarding the transactions that began and were committed in the last 30 minutes.
考题
单选题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 Manager RepositoryC
Automatic Workload Repository （AWR）D
Oracle 10g Enterprise Manager Grid ControlE
Automatic Database Diagnostic Monitor （ADDM）
考题
单选题You issue the following statement： SQL SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE； You receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）A
by using the DBMS_REPAIR packageB
by using the DBVERIFY utilityC
by using Block Media RecoveryD
by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command
考题
单选题You are creating a job class. You want access to the detailed information for all the runs of each job in the class and every operation performed on every job in the class. Which setting will you use for the LOGGING_LEVEL parameter？（）A
LOGGING_OFFB
LOGGING_RUNSC
LOGGING_FULLD
LOGGING_NULL
考题
单选题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 start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）A
Start the database in the MOUNT stage.B
Back up the control file to trace.C
Set the DBIDD
Issue the RECOVER DATABASE command.
考题
多选题An RMAN backup job fails， displaying the following error： ORA-19809： limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in the future？ （）Atake the backup of the flash recovery area less frequentlyBincrease the value of the UNDO_RETENTION initialization parameterCchange the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTODchange the backup retention policy to retain the backups for a smaller period of timeEincrease the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameterFincrease the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter
考题
单选题You are creating a job class. You have issued the following command to create the job class： SQL BEGIN DBMS_SCHEDULER.CREATE_JOB_CLASS（ JOB_CLASS_NAME = ’LOW_PRIORITY_CLASS’， RESOURCE_CONSUMER_GROUP = ’LOW_GROUP’， LOGGING_LEVEL = DBMS_SCHEDULER.LOGGING_FULL， LOG_HISTORY = 1200， COMMENTS = ’LOW JOB PRIORITY CLASS’）； END； SQL / What will be the result of the above command？（）A
The command will be executed successfully.B
The command will fail because RESOURCE_CONSUMER_GROUP is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.C
The command will fail because LOGGING_LEVEL is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.D
The command will fail because LOG_HISTORY is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.E
The command will fail because 1200 is an invalid value for the LOG_HISTORY parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
考题
单选题In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file： 1.RESTORE CONTROLFILE； 2.RESTORE DATABASE； 3.ALTER DATABASE MOUNT； 4.SQL ALTER TABLESPACE temp ADD TEMPFILE 5.ALTER DATABASE OPEN RESETLOGS； 6.RECOVER DATABASE； 7.STARTUP NOMOUNT； In what sequence would you use this process to perform the recovery？（）A
2， 7， 3， 5， 1， 6， 4B
2， 1， 7， 6， 3， 5， 4C
7， 1， 3， 2， 6， 5， 4D
7， 2， 3， 1， 4， 6， 5
考题
单选题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
MMANB
PMONC
MMOND
MMNL
考题
多选题What are the two advantages of RMAN Block Media Recovery （BMR） over file-level recovery？（）ABMR lowers the mean time to recover （MTTR）.BBMR supports point-in-time recovery of individual data blocks.CBMR enables you to use incremental backups for block recovery.DBMR enables recovery even when the database is not mounted or open.EBMR enables you to use proxy backups to perform block media recovery.FBMR enables increased availability of data during recovery because the data file requires a recovery can remain online.
考题
多选题You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re/x7fcreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re/x7fcreate the indexes？（）AONLINEBREVERSECPARALLELDCOMPRESSENOLOGGINGFCOMPUTE STATISTICS
考题
多选题Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）Abackup of offline tablespacesBbackup of readonly tablespacesCbackup of systemcritical tablespacesDbackup of online， locally managed tablespacesEbackup of read/write dictionarymanaged tablespaces
考题
多选题You want to migrate your existing non/x7fASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）Athe CONVERT command of RMANBData Pump Export and Import into the same databaseCconventional export and import into the same databaseDthe BACKUP DATABASE and RESTORE DATABASE commands of RMANEthe BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN
考题
单选题You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file： DB_BLOCK_CHECKING = TRUE； What will be the result of setting this parameter？（）A
Only data blocks of the SYSTEM tablespace will be checked.B
Only data blocks of the SYSAUX tablespace will be checked.C
A checksum will occur only on the checkpoint.D
A checksum will occur every time a block is modified.
考题
单选题In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective： DROP DISKGROUP dgroup1 EXCLUDING CONTENTS； What would be the result of this command？（）A
This command would result in an error because the disk group is not empty.B
The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.C
The command would result in the contents being moved to the parent disk group and dropping of the disk group.D
The command would result in the disk group being marked as INVALID because it cannot be dropped.E
The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.
考题
单选题In which situation will you run the script containing the following statement？（） CREATE CONTROLFILE REUSE DATABASE SALES NORESETLOGS ARCHIVELOG MAXLOGFILES 20 MAXLOGMEMBERS 3 MAXDATAFILES 30 MAXINSTANCES 10 MAXLOGHISTORY 1200 LOGFILE GROUP 1 （ ’/disk1/prod/orders/db/log1a.dbf’， ’/disk2/prod/orders/db/log1b.dbf’ ）SIZE 100K GROUP 2 （ ’/disk1/prod/orders/db/log2a.dbf’， ’/disk2/prod/orders/db/log2b.dbf’ ） SIZE 100K， DATAFILE ’/disk1/prod/orders/db/database1.dbf’， ’/disk2/prod/orders/db/file1.dbf ’；A
when all the control files are missing and only a binary backup of the current control file existsB
when a multiplexed copy of the current control file is missingC
when all the control files are missing and only an ASCII representation of the binary control file existsD
when the SPFILE is missing
考题
单选题At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）A
DBA_PENDING_TRANSACTIONSB
DBA_AUDIT_STATEMENTC
V$FLASHBACK_DATABASE_STATSD
FLASHBACK_TRANSACTION_QUERY
考题
单选题You are using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command： ALTER DISKGROUP dg3 REBALANCE POWER 0； What would be the result of this command？（）A
The rebalancing of the disk group would be stopped.B
The rebalancing of the disk group would be completed as fast as possible.C
The command would result in an error because the value of POWER cannot be 0.D
The rebalancing of the disk group would be completed without affecting the disk group DG3.E
The command would result in an error because the disk groups cannot be manually rebalanced.
考题
单选题In which scenario will you create a hash cluster？（）A
when you want the data to be returned automatically in chronological orderB
if the application uses queries joining tables only occasionallyC
if the queries against the clustered table use the equality operator （=） to retrieve the desired rowD
if the full table scan is executed often on only one of the clustered tables
考题
单选题You executed the following command in Recovery Manager （RMAN）： RMAN RESTORE CONTROLFILE; Which operation must you perform before this command is executed？（）A
back up the control file to traceB
bring database to the MOUNT stateC
open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD
set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
考题
多选题Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）Acontrol fileBall datafilesCpassword fileDonline redo log fileEarchive redo log fileFserver parameter fileGonly the SYSTEM datafile
考题
单选题In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB DB_CACHE_SIZE = 1GB SHARED_POOL_SIZE = 3GB STATISTICS_LEVEL = BASIC PGA_AGGREGATE_TARGET = 0 You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）A
The STATISTICS_LEVEL initialization parameter is set to BASICB
The PGA_AGGREGATE_TARGET initialization parameter is set to zero.C
The SGA_MAX_SIZE initialization parameter is set to less than 20 GBD
The DB_CACHE_SIZE initialization parameter is set to less than 5 GBE
The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.
考题
单选题You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface： SQL EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =’group1’， COMMENT = ’New Group’）； This command errorsout displaying the following message： ERROR at line 1： ORA-01031： insufficient privileges ORA-06512： at "SYS.DBMS_RMIN"， line 115 ORA-06512： at SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA-06512： at line 1 What action would you take to overcome this error？（）A
grant SYSDBA to the userB
grant SYSOPER to the userC
grant the RESOURCE role to the userD
use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the useE
grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package
考题
单选题You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） Which file will you check to view additional information regarding the cause of this error？（）A
the alert log file and the trace filesB
the redo log filesC
the control fileD
the change tracking file
考题
多选题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 database is in ARCHIVELOG mode and the tablespace is online.CThe database is in ARCHIVELOG mode and the tablespace is offline.DThe database is in NOARCHIVELOG mode and the tablespace is online.EThe database is in NOARCHIVELOG mode and the tablespace is offline.
考题
多选题You performed a backup of the flash recovery area by using the following command for the first time： RMAN BACKUP RECOVERY AREA; Which files in the flash recovery area are backed up？（）Aflashback logsBcurrent control fileCcontrol file autobackupsDincremental backup sets
考题
单选题Your database is running on the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）A
modify the HASH_AREA_SIZE initialization parameterB
modify the PGA_AGGREGATE_TARGET initialization parameterC
modify the WORK_AREASIZE_POLICY initialization parameterD
increase the value of the SGA_TARGET initialization parameterE
increase the value of the SGA_MAX_SIZE initialization parameterF
increase the value of the SORT_AREA_SIZE initialization parameter
考题
单选题A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）A
clear the redo log groupB
perform redo log file importC
perform an incomplete recoveryD
perform a redo log recovery using Recovery Manager （RMAN）E
shut down the database and open the database in the NOARCHIVELOG mode
热门标签
最新试卷