网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.” 相关考题
考题
Which setting enables the baselines by default in Oracle Database 11g?()
A. setting the STATISTICS_LEVEL parameter to TYPICALB. adding filters to the Automatic Database Diagnostic Monitor (ADDM)C. enabling Automated Maintenance Task using Oracle Enterprise ManagerD. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
考题
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
考题
Which setting enables the baselines by default in Oracle Database 11g?（）A、setting the STATISTICS_LEVEL parameter to TYPICALB、adding filters to the Automatic Database Diagnostic Monitor (ADDM)C、enabling Automated Maintenance Task using Oracle Enterprise ManagerD、setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
考题
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.
考题
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.
考题
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 fileB、to enable the ASM instance to identify the server parameter fileC、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
考题
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
考题
What components are present in an ASM instance？（）A、 SGAB、 Database processesC、 Database datafilesD、 Control filesE、 Database parameter file or spfile
考题
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.
考题
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.
考题
You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file： INSTANCE_TYPE = ASM ASM_POWER_LIMIT = 11 LARGE_POOL_SIZE = 4M ASM_DISKGROUPS = DG1， DG2 DB_UNIQUE_NAME = +ASM You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）A、 only the INSTANCE_TYPE initialization parameter is set to an invalid valueB、 only the ASM_POWER_LIMIT initialization parameter is set to an invalid valueC、 only the LARGE_POOL_SIZE initialization parameter is set to an invalid valueD、 both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values
考题
单选题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.
考题
单选题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
考题
单选题In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level. You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated. How do you achieve this objective？（）A
by setting the SQL_TRACE parameter to FALSE in the parameter fileB
by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user sessionC
by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user sessionD
by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session
考题
单选题Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）A
When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.B
When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.C
When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.D
When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
考题
单选题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
考题
单选题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 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 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： RMANBACKUP SECTION SIZE 300M TABLESPACE users； What configuration should be effected to accomplish faster and optimized backups by using the above command？（）A
The SBT channel must be configured， with the default parallelism setting for the SBT device set to 1B
The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0C
The SBT channel must be configured， with the parallelism setting for the SBT device set to 3D
The SBT channel must be configured， with the MAXPIECESIZE set to 300 MB
考题
单选题You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file： INSTANCE_TYPE = ASM ASM_POWER_LIMIT = 11 LARGE_POOL_SIZE = 4M ASM_DISKGROUPS = DG1， DG2 DB_UNIQUE_NAME = +ASM You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）A
only the INSTANCE_TYPE initialization parameter is set to an invalid valueB
only the ASM_POWER_LIMIT initialization parameter is set to an invalid valueC
only the LARGE_POOL_SIZE initialization parameter is set to an invalid valueD
both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values
考题
单选题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 fileB
to enable the ASM instance to identify the server parameter fileC
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
考题
单选题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 setting enables the baselines by default in Oracle Database 11g？（）A
setting the STATISTICS_LEVEL parameter to TYPICALB
adding filters to the Automatic Database Diagnostic Monitor （ADDM）C
enabling Automated Maintenance Task using Oracle Enterprise ManagerD
setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
考题
单选题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.
热门标签
最新试卷