网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
参考答案
更多 “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、Database Configuration AssistantD、Oracle Net Configuration Assistant” 相关考题
考题
Your 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. Database Configuration AssistantD. Oracle Net Configuration Assistant
考题
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.
考题
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
考题
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 flashbackB、the expected length of the longest-running queryC、the number of undo tablespaces in the databaseD、the size of the Flash Recovery Area for the database instance
考题
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.
考题
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.
考题
What two are the prerequisites for enabling Flashback Database?（） (Choose two)A、The database must be in ARCHIVELOG modeB、The database must be in MOUNT EXCLUSIVE modeC、The database must be opened in RESTRICTED modeD、The database instance must be started in the NOMOUNT stateE、The database instance must have the keep buffer pool defined
考题
What two are the prerequisites for enabling Flashback Database？（） A、 The database must be in ARCHIVELOG modeB、 The database must be in MOUNT EXCLUSIVE modeC、 The database must be opened in RESTRICTED modeD、 The database instance must be started in the NOMOUNT stateE、 The database instance must have the keep buffer pool defined
考题
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 PumpB、Oracle Net ManagerC、Oracle Enterprise ManagerD、Oracle Universal Installer （OUI）E、Database Configuration Assistant （DBCA）
考题
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 SESSIONB、 ALTER SYSTEM DISCONNECT SESSIONC、 ALTER SYSTEM QUIESCE RESTRICTEDD、 ALTER SYSTEM ENABLE RESTRICTED SESSION
考题
You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）A、 INSTANCE_TYPEB、 DB_UNIQUE_NAMEC、 ASM_DISKSTRINGD、 ASM_POWER_LIMIT
考题
What effect should the loss of an index tablespace have on an Oracle instance that is running？（）A、 instance hangsB、 instance gets abortedC、 instance continues runningD、 instance gets restarted automatically
考题
Your 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、 Database Configuration AssistantD、 Oracle Net Configuration Assistant
考题
多选题A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ. Which two will optimize the security of this setup?（）ADisabling connections from named pipes or socket files (depending on the operating system of the server)BEnabling and using SSL for connections to the Mysql databaseCInstalling Mysql on the application server, and running the database and application on the same serverDStarting the server with – bind- address=0.0.0.0 specifiedERunning the server with – skip-networking specifiedFLimiting logins to originate from the application server or the server's subnet'
考题
单选题ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure. Which statement is true in this situation（）A
The online redo log files and archived redo log files are required to accomplish the recovery.B
The uncommitted transaction will be committed at the next startup of the database instance.C
The uncommitted transaction is rolled back automatically at the next opening of the database.D
The DBA has to perform the recovery on the database to recover the uncommitted transaction.
考题
单选题View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities：SQL SELECT substr（component， 0， 10） COMP， current_size CS， user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0；What do you infer from this（）A
The database instance is running with manual PGA management.B
The database instance is running with manual shared memory management.C
The database instance has the MEMORY_TARGET value set to a nonzero value.D
All sessions are connected to the database instance in dedicated mode， and no RMAN or parallel queryoperations have been performed
考题
单选题Your 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
Database Configuration AssistantD
Oracle Net Configuration Assistant
考题
单选题Your 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
Database Configuration AssistantD
Oracle Net Configuration Assistant
考题
单选题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
Database Configuration AssistantD
Oracle Net Configuration Assistant
考题
多选题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？（）AData PumpBOracle Net ManagerCOracle Enterprise ManagerDOracle Universal Installer （OUI）EDatabase Configuration Assistant （DBCA）
考题
单选题You work as a database administrator for Supportcenter.cn. In your production database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task？（）A
You must have started the database instance in restricted mode.B
You must have started the database instance inNORMALmode.C
You must have started the database instance with server parameter file.D
You must have started the database instance but must not have mounted.E
You must have started the database instance but must not have opened.
考题
单选题You need to design the consolidation strategy for the Promotions and Partners databases. You want to choose a strategy that results in the best database performance while maintaining the permissions of end users in each database.What consolidation strategy should you choose？（）A
Place each database in a separate instance running on SQL2.B
Place each database in a separate instance running on SQL3.C
Place both databases in a single instance running on SQL2.D
Place both databases in a single instance running on SQL3.
考题
单选题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.
考题
单选题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
考题
单选题You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）A
INSTANCE_TYPEB
DB_UNIQUE_NAMEC
ASM_DISKSTRINGD
ASM_POWER_LIMIT
考题
多选题Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）AThe retention period to support flashbackBThe expected length of the longest-running queryCThe number of undo tablespaces in the databaseDThe size of the Flash Recovery Area for the database instance
考题
单选题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 SESSIONB
ALTER SYSTEM DISCONNECT SESSIONC
ALTER SYSTEM QUIESCE RESTRICTEDD
ALTER SYSTEM ENABLE RESTRICTED SESSION
热门标签
最新试卷
