网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use?()
A
LogMiner
B
The DBNEWID utility
C
The DBVERIFY utility
D
The ANALYZE command
E
The RMAN REPORT command
F
The RMAN CROSSCHECK command.
G
The RMAN BLOCKRECOVER command.
参考答案
参考解析
解析:
暂无解析
更多 “单选题You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use?()A LogMinerB The DBNEWID utilityC The DBVERIFY utilityD The ANALYZE commandE The RMAN REPORT commandF The RMAN CROSSCHECK command.G The RMAN BLOCKRECOVER command.” 相关考题
考题
多选题In your production database, you have multiple resource plan directives that refer to the consumer group DB_GRP. Which two statements are correct?()AThe parallel degree limit for DB_GRP will be the minimum of all the incoming values.BThe parallel degree limit for DB_GRP will be the maximum of all the incoming values.CThe maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.DIf a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time, then that session would not execute if the active session pool for the new consumer group was full.EIf a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time, then that session would execute even if the active session pool for the new consumer group was full.
考题
单选题You issued the following RMAN command: RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON; What is NOT an impact of using the above command?()A
When a successful backup is recorded in the RMAN repository, then a backup of the current control file is performed.B
When a structural change is made to the database, then a backup of the current control file is performed.C
When a successful backup is performed in the RMAN repository, then a backup of the spfile is performed.D
When a structural change is made to the database, then a backup of the alert log file will be performed.
考题
单选题You query the ORDERS table and discover that order number 1101 is missing. One of your reports, generated at 5:00 A.M. on April 23, 2005 using Oracle Reports, includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated?()A
Flashback TableB
Flashback QueryC
Flashback Version QueryD
Flashback Transaction Query
考题
单选题You work as a database administrator at Certkiller .com. In your production database there is a job, CALC_STAT, which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. You want the task to be generic, thereby allowing users to modify the attributes of the task at run time without affecting the original task.Which component of Oracle Scheduler must you define to achieve this?()A
WindowB
ProgramC
Job classD
Window group
考题
单选题In an Oracle 10g database, the in/x7fmemory statistics are gathered at regular intervals and used to perform growth/x7ftrend 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)
考题
单选题By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify: a) A list of changes made along with the transaction identifier of each change. b) The necessary SQL statements to undo the erroneous changes. Which option would you choose?()A
RMAN only.B
Flashback Table only.C
Flashback Version Query only.D
Flashback Database and Flashback Transaction Query.E
Flashback Version Query and Flashback Transaction Query.
考题
多选题You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()AFlashback logs are not archived.BFlashback logs are maintained in redo log files.CFlashback logs are maintained in the Flash Recovery Area.DFlashback logs are used to maintain Flashback Database related errors.EFlashback logs need to be cleared manually after you disable Flashback Database.
热门标签
最新试卷