网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）
A
restore the tablespace from the backup； there is no need to apply the redo information
B
restore the full database to recover the data up to the point when you performed the backup
C
restore the tablespace from the backup and then perform a recovery using the backup control file
D
restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied
参考答案
参考解析
解析：
暂无解析
更多 “单选题You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）A restore the tablespace from the backup； there is no need to apply the redo informationB restore the full database to recover the data up to the point when you performed the backupC restore the tablespace from the backup and then perform a recovery using the backup control fileD restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied” 相关考题
考题
单选题You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX： SQL ALTER INDEX EMP_NO_INDX REBUILD ONLINE； Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（）A
Index-organized tableB
Mapping TableC
Clustered TableD
Journal Table
考题
单选题You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX： SQL ALTER INDEX EMP_NO_INDX REBUILD ONLINE； Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（）A
Index-organized tableB
Mapping TableC
Clustered TableD
Journal Table
考题
单选题Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived， and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery： RMAN RUN { 2 SET UNTIL SEQUENCE 230 THREAD 1; 3 ALTER DATABASE MOUNT; 4 RESTORE DATABASE; 5 RECOVER DATABASE; 6 ALTER DATABASE OPEN RESETLOGS; 7 }; With reference to this scenario， which statement is true？（）A
RMAN recovers up to log sequence 230， but not including 230.B
RMAN returns an error because the log sequence number mentioned in the command should be 229.C
RMAN returns an error because the log sequence number mentioned in the command may never be missing.D
RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.
考题
单选题In which scenario will you perform a cancel-based recovery？（）A
when a tablespace is dropped and you have only RMAN-based backup of the databaseB
when a table is dropped and stored in the Recycle BinC
when you are required to recover an existing table to its previous stateD
when a tablespace is dropped and you have only a user-managed full backup of the database
考题
单选题The database is running in ARCHIVELOG mode and the FORMAT option is not configured in RMAN for disk backups. You configured the flash recovery area location and size by using the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization parameters. Which statement is correct in this scenario？（）A
If the FORMAT option to the RMAN BACKUP command is specified， then RMAN creates backup pieces and image copies in the flash recovery area with names in the Oracle Managed Files （OMF） format.B
If any local destinations for LOG_ARCHIVE_DEST_n are set， then archived redo logs are stored in these destinations as well as in the flash recovery area.C
If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST initialization parameter， then the RMAN backup of Oracle managed datafiles （OMF） only will go to the flash recovery area by default.D
If no other destination is configured for recovery files， then RMAN places the control file autobackups in the flash recovery area by default.
考题
单选题You want to create a consumer group， GROUP1， and you execute the following command in the command/x7fline interface： SQL EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =’group1’， COMMENT = ’New Group’）; This command errors out displaying the following message： ERROR at line 1： ORA/x7f29371： pending area is not active ORA/x7f06512： at "SYS.DBMS_RMIN"， line 115 ORA/x7f06512： at "SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA/x7f06512： at line 1 What action would you take to overcome this error？（）A
create the Pending Area before creating the consumer groupB
activate the Pending Area before creating the consumer groupC
increase the size of the large pool to accommodate the Pending AreaD
increase the size of the shared pool to accommodate the Pending AreaE
increase the size of the database buffer cache to accommodate the Pending Area
考题
单选题The warning level threshold value for a tablespace， DATA1， is set to 60% and the critical level threshold value is set to 80%. The tablespace， DATA1， is infrequently used and is not a part of the production environment. You issued the following command： SQL EXECUTE DBMS_SERVER_ALERT.SET_THRESHOLD （dbms_server_alert.tablespace_pct_full， dbms_server_alert.operator_ge，80， dbms_server_alert.operator_ge，90， 1，1，NULL， dbms_server_alert.object_type_tablespace，’DATA’）； What will be the result of the command？（）A
The command will be executed successfully only if the tablespace DATA1 is a dictionary-managed tablespace.B
The total numbers of alerts that you receive every day will be reduced.C
The total number of alerts that you receive every day will be increased.D
No more data will be added to the DATA1 tablespace if 80% of the space allocated to the DATA1 tablespace is used.
考题
单选题You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）A
The index tablespace contains bitmap indexes.B
The index tablespace contains more than one data file.C
The index tablespace supports only complete recovery.D
The index tablespace is not a dictionary-managed tablespace.E
There is a dependency relationship between a table and its indexes.
考题
单选题You enabled the flashback logging feature， but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area？（）A
The location used for control files.B
The location used for redo log files.C
The location set by using $ORACLE_BASED
The location set by using $ORACLE_HOMEE
The location set by using CORE_DUMP_DESTF
The location set by using BACKGROUND_DUMP_DEST
考题
多选题Which six files are maintained in the Flash Recovery Area？（）Acontrol fileBRMAN filesCpassword fileDparameter fileEflashback logsFdata file copiesGcore dump filesHarchived log filesIRMAN recovery scriptsJcontrol file autobackpus
考题
单选题Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available.What would you do in this scenario？（）A
recovery cannot be performed because a backup was not performed after the last incomplete recoveryB
restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on TuesdayC
restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on SundayD
restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
考题
单选题You are working as a DBA in an organization. The flash recovery area files are created in ’+disk1’. You want to create new flash recovery area files in the ’+disk2’ location. The new location of the flash recovery area files should be written in the control file and the spfile.Which command will you issue to change the location of the flash recovery area files？（）A
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ；B
ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH；C
ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’；D
ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’；
考题
单选题You have been assigned to manage a set of databases. The previous DBA did not leave you notes regarding the structure of each of the databases. While analyzing an instance， you notice that the system identifier （SID） for the instance is set to ’+ASM’. What is the purpose of this instance？（）A
This instance is being used to manage the operating system files.B
This instance is being used to manage the files of other databases.C
This instance is being used to manage the instances of other databases.D
This instance is being used to manage the background processes of other instances.
考题
单选题You issued the following command at the UNIX environment： % setenv ORA_SDTZ ’OZ_TZ’ What will be the impact of issuing the above command？（）A
The operating system local time zone will be set for a user session using the operating system environment variable.B
The database local time zone will be set for a user session using the operating system environment variable.C
The operating system local time zone will be set for the database using the operating system environmentD
The database local time zone will be set for the database using the operating system environment variable.
考题
单选题You are working as a DBA in an organization. The flash recovery area files are created in ’+disk1’. You want to create new flash recovery area files in the ’+disk2’ location. The new location of the flash recovery area files should be written in the control file and the spfile.Which command will you issue to change the location of the flash recovery area files？（）A
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ；B
ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH；C
ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’；D
ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’；
考题
单选题You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry： ASM_DISKSTRING = /devices/* What could be the reason for this setting？（）A
to enable the ASM instance to identify the alert log fileB
to enable the ASM instance to identify the server parameter fileC
to enable the ASM instance to define the locations for Oracle Managed Files （OMF）D
to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory
考题
单选题You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this？（）A
enable index monitoring and query the DBA_OBJECTS viewB
enable index monitoring and query the DBA_INDEXES viewC
enable index monitoring and query the V$OBJECT_USAGE viewD
enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
考题
单选题You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）A
by using the Flashback Database featureB
by using RMAN incomplete recoveryC
by performing a user-managed incomplete recoveryD
by dropping and re-creating the index tablespace
考题
单选题You are maintaining your Oracle10g database in the UNIX environment. An application requires one of the user sessions to exist in the operating system local time zone. You decide to set the time zone for a session using the operating system environment variable. Which command will you issue？（）A
setenv ORA_SDTZ ’DB_TZ’B
setenv ORA_SDTZ ’+10：00’C
setenv ORA_SDTZ ’OS-TZ’D
setenv ORA_SDTZ ’Europe/London’
考题
多选题In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN RESTORE CONTROLFILE； Which two operations do you need to perform after restoring the control file from backup？（）Ashut down and restart the instanceBadd new tempfiles to the temporary tablespaces after recoveryCperform a media recovery and open the database with the RESETLOGS optionDperform a media recovery and bring the database to NOARCHIVELOG mode
考题
单选题You are managing a database for which incremental backups can be very time consuming. In order to perform optimized incremental backups you enable the block change tracking feature.How would you instruct RMAN to use the block change tracking feature when performing incremental backups？（）A
You need to mention it with every BACKUP command.B
The block change tracking feature is used automatically by RMAN.C
You need to configure it using the CONFIGURE command.D
You need to set the necessary initialization parameters to direct RMAN to use the feature.
考题
单选题You execute the following command to start an Automatic Storage Management （ASM） instance： SQLSTARTUP； In which of the following modes will the ASM instance start？（）A
OPENB
MOUNTC
NORMALD
NOMOUNT
考题
单选题In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query？（）A
hash clustersB
index clustersC
partitioned tablesD
index-organized table （IOT）
考题
单选题You execute the following RMAN commands in the order shown below： BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do？（）A
create a backup of the database and recover all corrupted blocks found in the backupB
run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the databaseC
run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the viewD
run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the viewE
run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired
考题
单选题You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）A
You must use automatic undo management in the database.B
You must configure OMF in your database.C
You must configure ASM for storing the datafiles.D
You must multiplex the online redo log file.
考题
单选题You have created a resource plan， PROD_DB_PLAN， that uses the RATIO policy. The following consumer groups and their respective plan directives have been assigned to this resource plan： Consumer group HIGH_CG with CPU_P1 as 10. Consumer group MEDIUM_CG with CPU_P1 as 5. Consumer group LOW_CG with CPU_P1 as 2. Consumer group OTHER_GROUPS with CPU_P1 as 1. Which statement is correct in this scenario？（）A
The CPU allocation would be equal between the HIGH_CG and MEDIUM_CG consumer groups if there are no sessions existing for the LOW_CG and OTHER_GROUPS consumer groups.B
The members of the HIGH_CG consumer group would get 10% of the CPU.C
The plan PROD_DB_PLAN can have subplans.D
The CPU allocation for the consumer groups would be based on the ratio defined for the CPU_P1.
考题
多选题In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup？（）Ashut down and restart the instanceBadd new tempfiles to the temporary tablespaces after recoveryCperform a media recovery and open the database with the RESETLOGS optionDperform a media recovery and bring the database to NOARCHIVELOG mode
考题
单选题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 backup after seven days？（）A
The backup would be marked as invalid.B
The backup would be marked as obsolete.C
The backup would be removed from the media.D
The backup would be removed from the RMAN repository.
热门标签
最新试卷
