网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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 want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level?（）A、issuing the ALTER SYSTEM ENABLE RESUMABLE; statementB、issuing the ALTER SESSION ENABLE RESUMABLE; statementC、modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueD、issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=nonzero value; statement
考题
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
考题
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.
考题
Which background process of a database instance，using Automatic Storage Management （ASM）， connects as a foreground process into the ASM instance？（）A、 ASMBB、 PMONC、 RBALD、 SMON
考题
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
考题
You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level？（） A、 issuing the ALTER SYSTEM ENABLE RESUMABLE；statementB、 issuing the ALTER SESSION ENABLE RESUMABLE；statementC、 modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueD、 issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=；statement
考题
You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level? （）(Choose two.)A、issuing the ALTER SYSTEM ENABLE RESUMABLE; statementB、issuing the ALTER SESSION ENABLE RESUMABLE; statementC、modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueD、issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=; statement
考题
You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？ （）A、 RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.B、 RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMFC、 RMAN would relocate all the database files to an ASM disk group.D、 RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.
考题
One of the users in the PROD database， Adams， complains that his update on the table， TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions， and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority. Which method would you use to overcome this problem？（）A、execute the command， ALTER SESSION KILL ..， to kill the blocking sessionB、execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking sessionC、execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking sessionD、execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking sessionE、execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session
考题
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
考题
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
考题
Which background process of a database instance, using Automatic Storage Management (ASM), connects asa foreground process into the ASM instance?（）A、ASMBB、PMONC、RBALD、SMON
考题
You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non/x7fASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？（）A、RMAN would relocate all the database files to an ASM disk group.B、RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.C、RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.D、RMAN would relocate the ASM files to an ASM disk group and the nonASM files to an operating system location， defined using OMF
考题
Which statement is true about the Manageability Monitor （MMON） background process（）A、It transfers statistics from memory to disk at regular intervals.B、It coordinates the rebalance activity for disk groups when ASM is used.C、It communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance.D、It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance
考题
单选题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.
考题
单选题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 have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non/x7fASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？（）A
RMAN would relocate all the database files to an ASM disk group.B
RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.C
RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.D
RMAN would relocate the ASM files to an ASM disk group and the nonASM files to an operating system location， defined using OMF
考题
单选题Which background process of a database instance，using Automatic Storage Management （ASM）， connects as a foreground process into the ASM instance？（）A
ASMBB
PMONC
RBALD
SMON
考题
单选题Which statement is true about the Manageability Monitor （MMON） background process（）A
It transfers statistics from memory to disk at regular intervals.B
It coordinates the rebalance activity for disk groups when ASM is used.C
It communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance.D
It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance
考题
单选题You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？ （）A
RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.B
RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMFC
RMAN would relocate all the database files to an ASM disk group.D
RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.
考题
单选题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
考题
单选题Which background process of a database instance, using Automatic Storage Management (ASM), connects asa foreground process into the ASM instance?（）A
ASMBB
PMONC
RBALD
SMON
考题
单选题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
考题
单选题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
考题
单选题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
考题
单选题Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?（）A
ASMBB
PMONC
RBALD
SMON
考题
多选题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.
热门标签
最新试卷