You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL> shutdown immediate; What is the result of executing this command?（）
A. All the instances, including the ASM instance, are shut down in the ABORT mode
B. The ASM instance is shut down, but the other instances are still running
C. The ASM instance is still functional, but the other instances are shut down
D. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
E. HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode
F. HRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode
查看答案
相关试题
换一换
Have&8194;you&8194;ever&8194;traveled&8194;on&8194;____&8194;train？&8194;
A.&8194;the&8194; B.&8194;a&8194;’&8194; C.&8194;an&8194; D.&8194;/
答案
You want to create a WebLogic domain in a production environment. Which three actions should you perform?（）
A.Use a multinode WebLogic domain. B.Use a single-node WebLogic domain. C.Use clusters. D.Refrain from using clusters. E.Install WeLogic in production mode with CA signed certificates.
答案
For real time event processing, which three clients can you use?（）
A.Java B.++ C.NET D.REST
答案
You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）
A.Average row size B.Last analyzed date C.Size of table in bytes D.Size of table in database blocks E.Number of free blocks in the free list F.Number of extents present in the table.
答案
You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）
A.verage row size B.Last analyzed date C.Size of table in bytes D.Size of table in database blocks E.Number of free blocks in the free list F.Number of extents present in the table.
答案
In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）
A.average row size B.last analyzed date C.size of table in bytes D.size of table in database blocks E.number of free blocks in the free list F.number of extents present in the table
答案
In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）
A.average row size B.last analyzed date C.size of table in bytes D.size of table in database blocks E.number of free blocks in the free list F.number of extents present in the table
答案
You have been asked to create three users， PUB1， PUB2 and PUB3， for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users， which method can you use for granting the required privileges？（）
A.grant CONNECT role to all of the three users B.grant RESOURCE role to all of the three users C.grant both CONNECT and RESOURCE role to all of the three users D.execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three users E.create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users
答案
Your application requires that you programmatically manipulate a nonquery record group. Which three built-ins can you use?（）
A.REATE_GROUP B._GROUP_NOW C.POPULATE_GROUP D._GROUP_COLUMN E.REATE_GROUP_FROM_QUERY
答案
On which three can you use Recovery Manager （RMAN） to perform incremental backup？（）
A.data files B.control files C.tablespaces D.password file E.parameter file F.whole database G.flashback log file H.archived log files I.change tracking file
答案
热门试题
Using Oracle Scheduler you have scheduled two jobs， JOB_A and JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）
You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）
Identify three situations in which you would NOT be able to drop a tablespace. （）
You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）
You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）
Using Oracle Scheduler you have scheduled two jobs， JOB_Aand JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）
You have a disk group， DGROUP1， with three disk and NORMAL redundancy. You execute the following command to create a template for the disk group： ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES （MIRROR FINE）；Which statement is true？（）
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL> shutdown immediate; What is the result of executing this command?（）
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL> shutdown immediate; What is the result of executing this command?（）
Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）
Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）
You work as a database administrator for Certkiller .com. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task？（）
You work as a database administrator for Certkiller .com. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task？（）
You work as a database administrator for Supportcenter.cn. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task？（）
You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）.
Which three JVM options would you add to investigate performance issues in a Hot-Spot JVM?（）
Which three JVM options would you add to investigate performance issues in a Hot-Spot JVM?（）
You have three databases， FINDB， PAYDB and ADMINDB， located in Sydney， Tokyo and Singapore respectively. You want to perform administrative tasks which include starting up and shutting down the databases， creating and managing tablespaces and database users， and taking regular backups， for all of the three databases from London. Which component must be enabled and running on each host machine to achieve your objective？（）
使用微信扫一扫登录
