Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener byusing the command:LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance()
相似题目
-
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 want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this?()
-
Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?()
-
Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command: LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance()
-
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?()
-
Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byissuing the following command:lsnrctl > STOPWhat happens to the sessions that are presently connected to the database Instance?()
-
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option? ()
-
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option? ()
-
our 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 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?()
-
In your database, UNDO_RETENTION has been set to 600 sec and UNDO tablespace is configured for RETENTION GUARANTEE. Which statement regarding RETENTION GUARANTEE is true? ()
-
One of the tablespaces is readonly in your database. The loss of all control files forced you to recreate the control file. Which operation do you need to perform after recreating the control file and opening the database?()
-
You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?()
-
You are managing an Oracle Database 11g database. The database is open, and you plan to performRecovery Manager (RMAN) backups. Which three statements are true about these backups()
-
You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups()
-
The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct?()
-
Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause. Which components are backed up when this option is specified?()
-
Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command: RESTORE CONTROLFILE FROM AUTOBACKUP; Which of the following statements is true?()
-
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this?()
-
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option?()
-
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?()
-
Upon hearing the abandon ship signal,you put on your life jacket and report to your station. After the cover is removed you board your open lifeboat boat. The FIRST thing to do is to().
-
Your database is5GB and contain satablenamed Sales History.Salesinformationisfrequentlyinsertedandupdated.Youdiscoverthatexcessivepagesplittingisoccurring.Youneed toreducetheoccurr enceofpagesplittinginthe Sales History table.Whichcodesegmentshouldyou use?()
-
You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode.The following steps must be performed in the correct sequence to do this:Choose the correct sequence.()
推荐题目
- 多发性肌炎的下列哪几项表述是正确的()
- 必效散5功效与作用
- 电力电池室水平安装的走线架距地高度不宜低于()。
- 出版活动具有的特征是()。
- 在洛伍德学校,谁曾经给予简爱帮助?
- ()是分析异步电动机运行情况的一个重要参数。转子转速越接近磁场转速,则转差率越()。对应于最大转矩处的转差率称为临界转差率。
- 市盈率反映投资股票的成本。()
- 全口义齿初戴时,下列哪项不是选磨的主要原因()
- 惩罚感是指人们感受到的一种情绪体验,想去惩罚群体中“逃避责任的人”。()
- 男孩七岁,因突然高热来看急诊,他母亲诉说儿子颈项强直,嗜睡,胸腹部出现红疹,逐渐融合成一片片淤斑,并出现喷射状呕吐。腰穿刺检查显示脑脊液浑浊,有大量中性粒细胞和格兰阴性菌,最可能感染的病原菌是()