The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD，

题目

The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve by the above process（）

A、The database user OPS$SKD will be able to administer the database.
B、The authentication detail for the database user OPS$SKD is recorded in the password file.
C、The local operating system user SKD will be able to access the database instance without specifying theusername and password.
D、The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

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

第2题：

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_SIZE
B、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA
C、 The database instance starts，but Automatic Memory Management is disabled
D、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

正确答案:B

第3题：

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

第4题：

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 Assistant
B、Recovery Manager （RMAN）
C、Oracle Data Pump Export and Import
D、conventional Oracle Export and Import
E、operating system utilities to copy the files to the ASM instance

正确答案:B

第5题：

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

第6题：

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

第7题：

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.

正确答案:C

第8题：

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.

正确答案:A

第9题：

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.

正确答案:C

第10题：

What components are present in an ASM instance？（）

A、 SGA
B、 Database processes
C、 Database datafiles
D、 Control files
E、 Database parameter file or spfile

正确答案:A,B,E

The database instance

题目

相似问题和答案

更多相关问题

相关内容