You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()
![](/upload/20220827/c85071da6ff0aadc10ebce6c25bb4f0d.png)
相似题目
-
You work as a database administrator for Certkiller .com. In the middle of a transaction, a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario?()
-
You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go? ()
-
You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing?()
-
You work as a database administrator for Certkiller .com. According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?()
-
You work as a database administrator for Certkiller .com. The UNDO_RETENTION parameter in your database is set to 1000 and undoretention is not guaranteed. Which statement regarding retention of undo data is correct?()
-
You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN; What two actions are performed as a result of this command?()
-
You work as a database administrator for Certkiller .com. While granting a role,SELECT_CATALOG_ROLE, to a user, Certkiller, using Oracle Enterprise Manager 10g Database Control, you have cleared the DEFAULT check box. What will be the result?()
-
You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting?()
-
You work as a database administrator for Supportcenter.cn. On a Monday morning, you find the database instance aborted. After inspecting the alert log file, you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true?()
-
You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1,What is the effect of this command?()
-
You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting?()
-
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) to perform backups in your databases. Which four backup operations can be performed using RMAN?()
-
You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case?()
-
You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this? ()
-
You work as a database administrator for Certkiller .com. In your database server, the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve?()
-
You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing?()
-
You work as a database administrator for Supportcenter.cn. While granting a role, SELECT_CATALOG_ROLE, to a user, SupportCenter, using Oracle Enterprise Manager 10g Database Control, you have cleared the DEFAULT check box. What will be the result?()
-
You are working on a database that must be functioning 24 hours a day, 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups()
-
You work as a database administrator for Certkiller .com. On a Monday morning, you find the database instance aborted. After inspecting the alert log file, you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true?()
-
You work as a database administrator for Certkiller .com. You received the following error while working on your database: ORA-01555: snapshot too old In which situation would you receive such an error?()
-
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case? ()
-
You work as a database administrator for Certkiller .com. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users? ()
-
You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this?()
-
You work as a database administrator for Supportcenter.cn. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users?()
推荐题目
- 女孩一岁半。因发热、5d,咳嗽3d,纳差,大便每天4~5次,稀,无脓血,用青霉素肌内注射3d热不退转来。体检:体温40℃,神志清,精神萎,面色略苍白,咽红,心脏无异常,两肺呼吸音粗,有少许干啰音,腹软,肝肋下4cm,脾肋下3cm,软。血象:白细胞数17.8×10/L,中性粒细胞0.72,淋巴细胞0.28,嗜酸性粒细胞计数为O,X线胸片示两肺纹理增粗。应做的首要检查是()
- 关于数据集中系统的错账调整,表述不正确的是().
- 《汉书》采用的编写体例是()
- 企业对人员素质的要求包括()。
- 与低压交流电弧为光源的原子发射光谱法相比,火焰原子发射光谱法的光源温度较(),因此它的激发能量较(),但由于火焰燃烧较(),所以后者测定的稳定性较好,准确度较高。
- 关于对比剂的叙述,错误的是()
- 用户在呼叫建立过程中所处的不同阶段共出现()个稳定状态。
- 维生素A原
- 2015年,中央财政共安排转移支付资金53.16亿元,支持少数民族地区(),丰富少数民族地区群众精神文化生活。
- 【单选题】MRI检查患者应取下所佩戴的哪类物品