The database instance has the following parameter setting: O

题目
单选题
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  assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege.  What would youachieve 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 the username and password.

D

The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.

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

第1题:

Which setting enables the baselines by default in Oracle Database 11g?()

  • A、setting the STATISTICS_LEVEL parameter to TYPICAL
  • B、adding filters to the Automatic Database Diagnostic Monitor (ADDM)
  • C、enabling Automated Maintenance Task using Oracle Enterprise Manager
  • D、setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

正确答案:A

第2题:

To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL > startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.()

  • A、The PGA_AGGREGATE_TARGET parameter is set to zero.
  • B、The STATISTICS_LEVEL parameter is setto basic.
  • C、Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.
  • D、The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.

正确答案:B

第3题:

Which setting enables the baselines by default in Oracle Database 11g?()

A. setting the STATISTICS_LEVEL parameter to TYPICAL

B. adding filters to the Automatic Database Diagnostic Monitor (ADDM)

C. enabling Automated Maintenance Task using Oracle Enterprise Manager

D. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE


参考答案:A

第4题:

When issuing the duplicate database command, you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter?()  

  • A、 To indicate the location of the auxiliary-instance online redo logs.
  • B、 To indicate the location of the target database datafiles.
  • C、 To indicate the location of the auxiliary-instance control file and online redo logs.
  • D、 To indicate the location of the auxiliary-instance database datafiles.
  • E、 This is not a valid parameter when duplicating a database.

正确答案:D

第5题:

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

第6题:

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  assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege.  What would youachieve 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 the username and password.
  • D、The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.

正确答案:C

第7题:

You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. While studying the parameter file of the ASM instance, you find the following entry:  ASM_DISKSTRING = /devices/*  What could be the reason for this setting?()

  • A、to enable the ASM instance to identify the alert log file
  • B、to enable the ASM instance to identify the server parameter file
  • C、to enable the ASM instance to define the locations for Oracle Managed Files (OMF)
  • D、to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory

正确答案:B

第8题:

You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command:RMAN> BACKUPSECTION SIZE 300M TABLESPACE users;Identify the appropriate configuration to accomplish faster and optimized backups using the above command.()

A. The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.

B. The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.

C. The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.

D. The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1


参考答案:B

第9题:

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

第10题:

You work as a database administrator for Certkiller .com. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task?()

  • A、Shut down the instance, copy the control file to the third location and open the database.
  • B、Abort the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.
  • C、Copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile, restart the instance and open the database.
  • D、Shut down the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.
  • E、Shut down the instance, startup in the mount state, copy the control file to the third location, modify the CONTROL_FILES parameter ininit.oraand open the database.

正确答案:D

更多相关问题