网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
What are the prerequisites for performing flashback transactions? （）(Choose all that apply)
A
Supplemental log must be enabled
B
Supplemental log must be enabled for the primary key
C
Undo retention guarantee for the database must be configured
D
”EXECUTE “ permission on the DBMS_FLASHBACK package must be granted to the user
参考答案
参考解析
解析：
暂无解析
更多 “多选题What are the prerequisites for performing flashback transactions? （）(Choose all that apply)ASupplemental log must be enabledBSupplemental log must be enabled for the primary keyCUndo retention guarantee for the database must be configuredD”EXECUTE “ permission on the DBMS_FLASHBACK package must be granted to the user” 相关考题
考题
单选题Which components are needed for successful and most efficient recovery.（）A
The backup RB3 and the current online redo log filesB
the backup RB2 and the archived redo log files after the log sequence number 15622C
Backup R81 and the archived redo log hies after the log sequence number 12871D
The backup RB3 and the archived redo log files after the log sequence number 16721
考题
多选题When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? （）(Choose two.)AIt produces less accurate results of the comparison analysis.BIt automatically calls the SQL Tuning Advisor for recommendations.CIt shortens the time of execution and reduces the impact on system resources.DOnly the changes in the execution plan, and not performance regression, are detected.
考题
单选题When creating a SQL tuning set，which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values？（）A
Filter versionsB
Filter loadsC
Filter tasksD
Filter options
考题
单选题You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. Thebackups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure,you lost your production database completely along with the recovery catalog database.You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task: 1) Restore an autobackup of the server parameter file. 2) Restore the control file 3) Start the target database instance 4) Mount the database 5) Restore the data files 6) Open the database with RESETLOGS option 7) Recover the data files 8) Set DBID for the target database Which option illustrates the correct sequence that you must use?（）A
8，1，3，2，4，5，7，6B
1，8，3，4，2，5，7，6C
1，3，4，2，8，5，6，7D
1，3，2，4，6，5，7，8
考题
单选题A schedule defined entirely within the confines of a Scheduler job object is known as a （n） （）A
Fixed scheduleB
Inline scheduleC
Stored scheduleD
Hard-coded scheduleE
None of the above
考题
单选题The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）A
Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfilesB
Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGSC
Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfileD
Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.
考题
单选题Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment， you performed the workload capture on the production database to record the peak workload. You set up the test RAC databaseand want to replay the recorded workload on the testmachine. Note the following steps that you may require to replay the database workload： 1） Preprocess the captured workload. 2） Restart the database in RESTRICTED mode. 3） Set up the Replay Clients. 4） Restore the test database to the point when the capture started. 5） Remap connections. Arrange the steps required in the correct sequence to accomplish this task on the test machine.（）A
1，4，5，3 （2 is not required.）B
1，4，3，5 （2 is not required.）C
1，2，4，5 （3 is not required.）D
2，1，5，3，4 E
1，2，4，5，3
考题
单选题Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）A
Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.B
Just back up the database datafiles without shutting down the database.C
You will have to wait until you can shut down the database to perform the backup.D
Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.E
Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backup
热门标签
最新试卷