CMS专题
单选题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 datab
题目
When the instance is started
When the database is mounted
When the database is opened
When the database is closed
参考答案和解析
相似问题和答案
第1题：
While planning to manage more than one database in your system， you perform the following activities： 1. Organize different categories of files into independent subdirectories. 2. Use consistent naming convention for database files. 3. Separate administrative information pertaining to each database. Which option corresponds to the type of activities performed by you？（）
- A、Oracle Managed Files
- B、Oracle Grid Architecture
- C、Optimal Flexible Architecture
- D、Oracle database architecture
正确答案:C
第2题：
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（）
- A、The backups would be consistent.
- B、The backups would be inconsistent.
- C、The backups would be possible only if the database is running in ARCHIVELOG mode.
- D、The backups would be possible only if the database is running in NOARCHIVELOG mode.
- E、The backups need to be restored and the database has to be recovered in case of a media failure
正确答案:B,C,E
第3题：
You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?（）
A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.
B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.
C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.
D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
第4题：
You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）
- A、 target database
- B、 auxiliary database
- C、 third-party database
- D、 recovery catalog database
正确答案:C
第5题：
You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）
- A、LOGICAL_READS_PER_SESSION
- B、CONNECT_TIME
- C、COMPOSITE_LIMIT
- D、CPU_PER_SESSION
- E、PRIVATE_SGA
正确答案:C
第6题：
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）
- A、You must shut down the database instance to perform the backups.
- B、You must configure the Flash Recovery Area （FRA） for the database.
- C、You can perform complete database backups without closing the database.
- D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
正确答案:C,D
第7题：
You are maintaining subscriptions in an Oracle database. Which property of that subscription allowsyou to update it?（）
- A、Phase
- B、Status
- C、Source Type
- D、Rule Function
- E、Customization Level
正确答案:E
第8题：
A. Phase
B. Status
C. Source Type
D. Rule Function
E. Customization Level
第9题：
You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）
- A、 STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
- B、 STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；
- C、 STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；
- D、 STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
正确答案:D
第10题：
SYSTEM
OUTLN
INTERNAL
SYS