网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）
A
Restore the backup control file and open the database with RESETLOGS option.
B
Perform point-in-time recovery because flashback cannot be performed again on this table
C
Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
D
Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
参考答案
参考解析
解析：
暂无解析
更多 “单选题You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）A Restore the backup control file and open the database with RESETLOGS option.B Perform point-in-time recovery because flashback cannot be performed again on this tableC Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571D Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571” 相关考题
考题
单选题You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task？（）A
Set metric thresholdB
Implement Database Resource ManagerC
Enable resumable timeout for user sessionsD
Add directives to Automatic Database Diagnostic Monitor （ADDM）
考题
单选题You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur？（）A
The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.B
The job affinity is to a service and one node in that service is unavailable.C
The job affinity is to an instance and that instance is unavailable.D
There is no service affinity.E
None of the above.
考题
单选题Which of the following advisors is run in every maintenance window by the auto-task system?（）A
The Memory AdvisorB
The SQL Tuning AdvisorC
The Undo AdvisorD
The SQL Access Advisor
考题
单选题You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you are asked to change the retention period from 5 years to 3 years. To accomplish this, you issued the following command: ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEARS; What is the outcome of this command?（）A
The command produces an error because the retention period cannot be reducedB
All historical data older than 3 years is purged from the flashback archive FLA1C
All historical data is retained but the subsequent flashback data archives are maintained for only 3 yearsD
All historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time
考题
多选题Which two changes and their effect on the system can be tested by using the Database Replay feature？（）Amultiplexing of the control fileBadding the redo log member to the databaseCdatabase and operating system upgradesDchanging the database storage to ASM-managed storage
考题
单选题When manually configuring the SGA，which of the following parameter changes requires an instance restart to take effect？（） "First Test， First Pass" - www.lead2pass.com 97 Oracle 1Z0-053 ExamA
DB_CACHE_SIZEB
SHARED_POOL_SIZEC
LARGE_POOL_SIZED
JAVA_POOL_SIZEE
SGA_MAX_SIZEF
SORT_AREA_SIZE
考题
多选题In which situations will the ASM metadata backup help you recover the ASM disk in a disk group？（）Awhen one or more file directory paths are accidentally deleted from an ASM disk groupBwhen one of the disks in a disk group is accidentaly unpluggedCwhen the data file on an ASM disk group gets corruptedDwhen one or more disks in an ASM disk group are lost
考题
单选题Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）A
Perform Export before TSPITR and Import after TSPITRB
Move objects to another schema that has the same tablespace assignedC
Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D
Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
考题
单选题View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management （ASM）. Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size？（）A
Because the FRA disk group will not support dynamic rebalancingB
Because the FRA disk group is not configured to support mirroringC
Because disks in the FRA disk group are not formatted at this stageD
Because the FRA disk group will support only a single size of allocation unit
考题
单选题Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature？（）A
RSTLNEB
NLSRTLC
LISTENERD
NLSSORTE
Linguistic sorts
考题
单选题Which statements about the MEMORY_TARGET initialization parameter are true?（） (Choose all that apply.)A
MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zeroB
MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not setC
MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.D
MEMORY_TARGET is static and cannot be modified without shutting down the instance
考题
多选题Which three statements are true about persistent configuration？（）AA user cannot set privileges on the persistent lightweight jobsBPersistent lightweight jobs generate a large amount of metadataCIt is possible to create fully self-contained persistent lightweight jobsDThe use of a template is mandatory to create persistent lightweight jobsEPersistent lightweight jobs are useful when users need to create a large number of jobs in a short time
考题
多选题Which two commands never trigger an implicit rebalancing within the disk group?（） (Choose two.)AALTER DISKGROUP misc MOUNT;BALTER DISKGROUP misc DROP DISK misc2;CALTER DISKGROUP misc CHECK ALL NOREPAIR;DALTER DISKGROUP misc RESIZE ALL SIZE 1023m;EALTER DISKGROUP dgroupA ADD DISK '/devices/A*';
考题
单选题You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours： ALTER DISKGROUP dg01 SET ATTRIBUTE ’disk_repair_time’ = ’5h’； To which disks in the disk group will the new value be applicable？（）A
all disks in the disk groupB
all disks that are currently in OFFLINE modeC
all disks that are not currently in OFFLINE modeD
all disks in the disk group only if all of them are ONLINE
考题
单选题Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?（）A
Segment AdvisorB
SQL Access AdvisorC
Undo AdvisorD
SQL Tuning Advisor
考题
单选题You have lost all your SYSTEM tablespace datafiles （system_01.dbf and system_02.dbf） nd the database has crashed. What would be the appropriate order of operations to correct the situation？（） a. Mount the database with the startup mount command. b. Take the SYSTEM datafile offline with the alter database command. c. Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs. d. Restore all SYSTEM tablespace-related datafiles from backup media. e. Issue the recover tablespace SYSTEM command. f. Issue the recover datafile SYSTEM_01.dbf command. g. Open the database with the alter database open command. h. Open the database with the alter database open resetlogs command.A
a， c， f， gB
b， d， e， hC
a， b， c， f， gD
d， a， e， gE
b， c， f， e， g
考题
单选题Examine the following ALTER command: SQL ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?（）A
It cancels all pending disk drops within the disk groupB
It restores disks that are being dropped as the result of a DROP DISKGROUP operationC
It mounts disks in the disk group for which the drop-disk operation has already been completedD
It restores all the dropped disks in the disk group for which the drop-disk operation has already been completedE
It adds previously dropped disks back into the disk group
考题
多选题You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)AYou must configure block change tracking fileBYou must have first level 1 backups for RMAN to restore blocksCYou must ensure that the SALES database is mounted or openDYou must have full or level 0 backups for RMAN to restore blocksEYou must take the tools01.dbf data file offline before you start a block media recovery
考题
多选题Identify three key features of ASM.（）Afile stripingBallocation unit mirroringCautomatic disk rebalancingDautomatic file size incrementEautomatic undo management
考题
多选题Which two statements about the SQL Management Base （SMB） are true？（）AIt contains only SQL profiles generated by SQL Tuning Advisor.BIt stores plans generated by the optimizer using a stored outline.CIt is part of the data dictionary and stored in the SYSAUX tablespace.DIt is part of the data dictionary and stored in the SYSTEM tablespace.EIt contains the statement log，the plan history，plan baselines，and SQL profiles.
考题
单选题In what state are the datafiles of a tablespace after a TSPITR has been successfully completed？（）A
The datafiles have an ONLINE status.B
The datafiles have an OFFLINE status.C
The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.D
The datafiles have an OFFLINE status and are in hot backup mode for an online backup.E
The datafiles are in STANDBY mode.
考题
单选题Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?（）A
The RMAN backup fails because the TOOLS tablespace is read-onlyB
The RMAN skips the backup of the tablespace because backup optimization is enabledC
The RMAN makes backup because optimization can be enabled only for backups to diskD
The RMAN makes the backup because no backup of the tablespace exists within the seven day window
考题
多选题Which of the following are correct about block media recovery？（）APhysical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTIONBLogical corruptions are repairable by BMRCPhysical corruptions are repairable by BMRDRMAN can use any backup for a BMR restoreEARCHIVELOG mode is not required if you have both a full and incremental backup for restore
考题
单选题You plan to set up the Automatic Workload Repository （AWR） baseline metric thresholds for a moving window baseline. Which action would you take before performing this task？（）A
Compute the baseline statistics.B
Take an immediate AWR snapshot.C
Decrease the window size for the baseline.D
Decrease the expiration time for the baseline.
考题
单选题Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（）A
shutdown restore datafile 4； recover datafile 4； alter database open；B
Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；C
Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；D
Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；E
Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；
考题
多选题You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? （）(Choose two.)ABackup compression should be enabledBParallelism for the channel should be set to 2CAll the files must be backed up as backup setsDThe backup may be stored either on disk or on media with media manager
考题
单选题Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement？（）A
NLS_LANGB
NLS_COMPC
NLS_SORTD
None of the above
热门标签
最新试卷