Oracle认证考试
our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）A、Oracle Net ManagerB、Listener Control utilityC、Databas
题目
our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）
- A、Oracle Net Manager
- B、Listener Control utility
- C、Database Configuration Assistant
- D、Oracle Net Configuration Assistant
相似问题和答案
第1题：
You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running？（）
- A、The instance would normally abort.
- B、The instance would not be affected.
- C、The instance would be invalid， so would have to be aborted.
- D、The instance would remain open， but the LGWR process would fail.
- E、The instance would remain open and would automatically create the missing file
正确答案:B
第2题：
While an electrician was adding additional circuits for the Data Center， the system running the Database inadvertently powered down. The fallover of the service IP labels and volume groups to the hot standby node completed as expected； however， the database did not start. The database log file indicated that the database was already started. What is the most likely cause of this problem？（）
- A、 The shared logical volumes and filesystems did not have database permissions.
- B、 There was a test instance running on the standby system that must be shutdown.
- C、 The tablespaces had an indicator indicating that the database had not shutdown properly.
- D、 The startup script for the highly available instance did not first perform cleanup operations.
正确答案:D
第3题：
A. Oracle Net Manager
B. Listener Control utility
C. Database Configuration Assistant
D. Oracle Net Configuration Assistant
第4题：
A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance？（）
- A、Data Pump
- B、Oracle Net Manager
- C、Oracle Enterprise Manager
- D、Oracle Universal Installer （OUI）
- E、Database Configuration Assistant （DBCA）
正确答案:B,C
第5题：
What two are the prerequisites for enabling Flashback Database?（） (Choose two)
- A、The database must be in ARCHIVELOG mode
- B、The database must be in MOUNT EXCLUSIVE mode
- C、The database must be opened in RESTRICTED mode
- D、The database instance must be started in the NOMOUNT state
- E、The database instance must have the keep buffer pool defined
正确答案:A,B
第6题：
Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
- A、the retention period to support flashback
- B、the expected length of the longest-running query
- C、the number of undo tablespaces in the database
- D、the size of the Flash Recovery Area for the database instance
正确答案:A,B
第7题：
You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）
- A、The instance would hang.
- B、The instance needs to be shut down.
- C、The instance would be in the open state.
- D、The instance would abort in such cases.
- E、The instance would be in the open and invalid state.
- F、The instance would in the open state， but all the background processes will be restarted.
正确答案:D
第8题：
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance :SQL> shutdown immediate;What is the result of executing this command?（）
A. The ASM instance is shut down, but the other instances are still running.
B. It results in an error because other database instances are connected to it.
C. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
D. HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.
第9题：
What two are the prerequisites for enabling Flashback Database？（）
- A、 The database must be in ARCHIVELOG mode
- B、 The database must be in MOUNT EXCLUSIVE mode
- C、 The database must be opened in RESTRICTED mode
- D、 The database instance must be started in the NOMOUNT state
- E、 The database instance must have the keep buffer pool defined
正确答案:A,B
第10题：
Which statement must you issue to an already-running Automatic Storage Management （ASM） instance to prevent database instances from connecting to the ASM instance？（）
- A、 ALTER SYSTEM KILL SESSION
- B、 ALTER SYSTEM DISCONNECT SESSION
- C、 ALTER SYSTEM QUIESCE RESTRICTED
- D、 ALTER SYSTEM ENABLE RESTRICTED SESSION
正确答案:D