网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
our database instance is started using the server parameter file （SPFILE）. You executed a command tochange the value of the LOG_BUFFER initialization parameter：ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）
- A、The command succeeds only if Automatic Memory Management is not enabled.
- B、The command succeeds， but you need to restart the database for changes to take effect.
- C、The command returns an error because the size of the redo log buffer cannot be changed dynamically.
- D、The parameter value is changed and it comes into effect as soon as space becomes available in theSystem Global Area （SGA）
参考答案
更多 “ our database instance is started using the server parameter file （SPFILE）. You executed a command tochange the value of the LOG_BUFFER initialization parameter：ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）A、The command succeeds only if Automatic Memory Management is not enabled.B、The command succeeds， but you need to restart the database for changes to take effect.C、The command returns an error because the size of the redo log buffer cannot be changed dynamically.D、The parameter value is changed and it comes into effect as soon as space becomes available in theSystem Global Area （SGA）” 相关考题
考题
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
考题
If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? （）A、All existing databases in the instance are expanded to the new database partition but data cannot be stored on the newpartition until it has been added to a partition group. B、Database partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition. C、Any single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance. D、A database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.
考题
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
考题
You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true？（）A、 The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC、 The database instance starts，but Automatic Memory Management is disabledD、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
考题
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
考题
Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（） A、 If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.B、 If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately.C、 If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down.D、 If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.
考题
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
考题
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.
考题
In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）A、Oracle Migration AssistantB、Recovery Manager （RMAN）C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance
考题
What components are present in an ASM instance？（）A、 SGAB、 Database processesC、 Database datafilesD、 Control filesE、 Database parameter file or spfile
考题
Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）A、mount the new disk group in the ASM instanceB、restart the ASM instance and the production database instanceC、register the new disk groups in the production database instanceD、restart the ASM instance without restarting the production database instanceE、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance
考题
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？（）A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.B、 Before the instance starts， you receive an error about the missing redo log files of a group.C、 The instance starts and the database opens with an error message written to the alert log file.D、 The instance starts and the database opens because two redo log groups still exist.E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.
考题
单选题n your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）A
Oracle Migration AssistantB
Recovery Manager （RMAN）C
Oracle Data Pump Export and ImportD
conventional Oracle Export and ImportE
operating system utilities to copy the files to the ASM instance
考题
单选题You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）A
Start the instance and open the database, instance recovery automatically recovers control files B
Create a file based on the contents of the trace file and save it to the control file locations and start the database C
Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) D
Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. E
Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
考题
单选题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？（）A
The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.B
Before the instance starts， you receive an error about the missing redo log files of a group.C
The instance starts and the database opens with an error message written to the alert log file.D
The instance starts and the database opens because two redo log groups still exist.E
The instance starts and the database opens， but every attempt to write to redo log files fails with an error.
考题
多选题What two are the prerequisites for enabling Flashback Database?（）AThe database must be in ARCHIVELOG modeBThe database must be in MOUNT EXCLUSIVE modeCThe database must be opened in RESTRICTED modeDThe database instance must be started in the NOMOUNT stateEThe database instance must have the keep buffer pool defined
考题
单选题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.
考题
单选题You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）A
mount the new disk group in the ASM instanceB
restart the ASM instance and the production database instanceC
register the new disk groups in the production database instanceD
restart the ASM instance without restarting the production database instanceE
include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance
考题
单选题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 production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）A
mount the new disk group in the ASM instanceB
restart the ASM instance and the production database instanceC
register the new disk groups in the production database instanceD
restart the ASM instance without restarting the production database instanceE
include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance
考题
多选题What two are the prerequisites for enabling Flashback Database?（） (Choose two)AThe database must be in ARCHIVELOG modeBThe database must be in MOUNT EXCLUSIVE modeCThe database must be opened in RESTRICTED modeDThe database instance must be started in the NOMOUNT stateEThe database instance must have the keep buffer pool defined
考题
单选题Which statement is true about Oracle Net Listener?（）A
It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.B
A single listener can service only one database instance and multiple remote client connections.C
Service registration with the listener is performed by the process monitor (PMON) process of each database instance.D
The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.
考题
单选题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.
考题
单选题In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non/x7fASM instance to an ASM instance？（）A
Oracle Migration AssistantB
Recovery Manager （RMAN）C
Oracle Data Pump Export and ImportD
conventional Oracle Export and ImportE
operating system utilities to copy the files to the ASM instance
考题
单选题You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true?（）A
The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB
The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC
The database instance starts, but Automatic Memory Management is disabledD
The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
考题
单选题Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（）A
If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.B
If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately.C
If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down.D
If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.
考题
多选题You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario？（）AThe database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.BRDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.CThe RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.DASM compatibility controls which features for the ASM will be enabled.
热门标签
最新试卷
