搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement：       SQL>ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’；  What will be the outcome of this statement？（）  

A、 The statement will deactivate DAY_PLAN.

B、 The statement will activate DAY_PLAN as the top plan.

C、 The statement will activate MANAGERS_PLAN as the top plan.

D、 The statement will return an error because MANAGERS_PLAN is not the top plan.

查看正确答案
更多“The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement：       SQL>ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’；  What will be the outcome of this statement？（）  ”相关的问题
第1题
[单选题] Due to media failure you lost one of the data files belonging to the USERS tablespace， and the tablespace is not available to use. Which statement regarding the status of the database is true？（）

A、The database remains open.  B、The database gets dismounted.  C、The database becomes read only.  D、The database instance gets aborted.  E、The database gets shut down automatically.  F、The status of the database depends on the status of the USERS tablespace.  

点击查看答案
第2题
[单选题] You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you must make sure that suspect pages can be detected in the database. So what action should you perform to achieve this goal?（）

A、For the database, you should turn on the TRUSTWORTHY database option  B、For the database, the PAGE_VERIFY database option should be set to CHECKSUM  C、For the database, the database compatibility level option should be set to 10  D、For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION.   

点击查看答案
第3题
[单选题] While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）

A、configure the database to run in ARCHIVELOG mode  B、configure the Flash Recovery Area to enable automatic database backup  C、schedule the database backup using DBMS_JOB package after creating the database  D、schedule the database backup using Recovery Manager （RMAN）commands after creating the database  E、schedule the database backup using Database Configuration Assistant （DBCA）while creating the database  

点击查看答案
第4题
[] A junior level Database Administrator erroneously deleted the database alert log while users were accessing the database. Which action should you take to recover the alert log？（）  

A、A. Do nothing.  B、B. Restart the database.  C、C. Perform recovery on the database.  D、D. Restore the alert log from the last backup.  

点击查看答案
第5题
[] 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？（）

A、A.Execute the ALTER DATABASE ARCHIVELOG statement  B、B.Select ARCHIVELOG option in the database control and restart the database to apply the changes.  C、C.Shut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.  D、D.Shut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.  

点击查看答案
第6题
[单选题] If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode， what will be the result when you issue the command alter database archivelog？（）  

A、 The alter database archivelog command will fail  B、 The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode  C、 The alter database archivelog command will succeed  D、 The alter database archivelog command will ask if you want to make the database consistent first  E、 There is no alter database archivelog command. The correct command is alter database alterlogging  

点击查看答案
第7题
[] While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention. What should you do to achieve the objective？（）

A、A.configure the database to run in ARCHIVELOG mode  B、B.configure the Flash Recovery Area to enable automatic database backup  C、C.schedule the database backup using DBMS_JOB package after creating the database  D、D.schedule the database backup using Recovery Manager （RMAN） commands after creating the database  E、E.schedule the database backup using Database Configuration Assistant （DBCA） while creating the database  

点击查看答案
第8题
[单选题] RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）

A、’SQL ALTER DATABASE OPEN’；  B、SQL ALTER DATABASE ’OPEN’；  C、OPEN DATABASE；  D、DATABASE OPEN  

点击查看答案
第9题
[单选题] You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）

A、The database would open normally.  B、The database would not open， and it would stop at mount stage.  C、The database would open after automatically performing instance recovery.  D、The database would not open， and you have to perform database recovery to open it.  

点击查看答案
第10题
[单选题] You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）

A、When the instance is started   B、When the database is mounted   C、When the database is opened   D、When the database is closed  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服