CMS专题
单选题In your database，the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory （OID）. SSL and the password file have b
题目
authentication by password file
authentication by using certificates over SSL
authentication by using the Oracle Internet Directory
authentication by using the local OS of the database server
相似问题和答案
第1题：
In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command： SQL>SELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales GROUP BY sale_category； Where would the result of this query be stored（）？
- A、 database buffer cache
- B、 shared pool
- C、 PGA
- D、 large pool
正确答案:B
第2题：
You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）
- A、 The database will not start.
- B、 The database will start but will not retain the undo data in the undo segment.
- C、 The database will start， and the undo segment will contain the undo data for at least one hour.
- D、 The database will start， and the undo segment will retain the undo data for at least 15 minutes.
正确答案:D
第3题：
In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:Which authentication method would be used first?（）
A. authentication by password file
B. authentication by using certificates over SSL
C. authentication by using the Oracle Internet Directory
D. authentication by using the local OS of the database server
第4题：
In your database，the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory （OID）. SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command：$ SQLPLUS scott/tiger@DB01 AS SYSDBA where DB01 is the net service name. Which authentication method would be used first？（）
- A、 authentication by password file
- B、 authentication by using certificates over SSL
- C、 authentication by using the Oracle Internet Directory
- D、 authentication by using the local OS of the database server
正确答案:A
第5题：
You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter？（）
- A、 0
- B、 1
- C、 NONE
- D、 DEFAULT
正确答案:A
第6题：
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）
- A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.
- B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.
- C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.
- D、 Increase the value of the SGA_TARGET initialization parameter.
正确答案:B
第7题：
You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）
- A、The database performance would be enhanced.
- B、The redo log files would be get filled more frequently.
- C、The overall database performance would be degraded.
- D、The mean time to recover （MTTR） would be increased.
正确答案:C
第8题：
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）
- A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
- B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
- C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.
- D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
正确答案:B,D
第9题：
You are maintaining your OLTP database in Oracle10g. While observing the performance of the database， you find that the log switch occurs more than once for every 20 minutes， affecting the database performance. Which factor is responsible for frequent log switches？（）
- A、the value of the UNDO_RETENTION initialization parameter
- B、the value of the optimal redo log file size provided by the Redo Logfile Size Advisor
- C、the online redo log files size
- D、the number of redo log members in a group
正确答案:C
第10题：
You executed the following command to back up your control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； Which initialization parameter is used to specify the location of the trace file？（）
- A、USER_DUMP_DEST
- B、CORE_DUMP_DEST
- C、TRACE_DUMP_DEST
- D、BACKUP_DUMP_DEST
- E、BACKGROUND_DUMP_DEST
正确答案:A