单选题You are specifying French case-insensitive sorts by using the NSL_SORT parameter for the user session of the user， Scott. Which value will you set for the NLS_SORT parameter？（）A FRENCH_AIB FRENCH_CIC AI_FRENCHD CI_FRENCH
单选题
You are specifying French case-insensitive sorts by using the NSL_SORT parameter for the user session of the user， Scott. Which value will you set for the NLS_SORT parameter？（）
A
FRENCH_AI
B
FRENCH_CI
C
AI_FRENCH
D
CI_FRENCH
参考解析
解析：
暂无解析
相关考题：
Which of the following NLS_SORT parameter values would result in case－insensitive and accent－insensitive binary sorts?() A. NLS_SORT = BINARYB. NLS_SORT = BINARY_AIC. NLS_SORT = BINARY_CID. NLS_SORT = BINARY_AI_CIE. Binary sorts are case insensitive and accent insensitive by default.
In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）A、the alert log fileB、the core dump filesC、the change tracking fileD、the user session trace filesE、the database audit trail filesF、the background process trace files
You issued the following statement： SQL ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1； Which parameter is NOT overridden by using the above statement？（） A、 the value of the NLS_LANGUAGE variableB、 the value of the NLS_TERRITORY variableC、 the value of the NLS_CURRENCY variableD、the character encoding scheme used by the client application
Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?（）A、NLS_SORT = BINARYB、NLS_SORT = BINARY_AIC、NLS_SORT = BINARY_CID、NLS_SORT = BINARY_AI_CIE、Binary sorts are case insensitive and accent insensitive by default.
For the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）A、 Set the CPU time per call in the users profile.B、 Set the CPU time per session in the users profile.C、 Set the CPU levels for the user’s group using Resource Manager.D、 Set the TIMED_STATISTICS parameter to TRUE in the parameter file.
You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process. Which action will enable you to disable the trace files generated by the ARCn background process？（） A、 Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.B、 Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.C、 Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.D、 Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.
Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts？（） A、 NLS_SORT = BINARYB、 NLS_SORT = BINARY_AIC、 NLS_SORT = BINARY_CID、 NLS_SORT = BINARY_AI_CIE、 Binary sorts are case insensitive and accent insensitive by default
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）A、Set MEMORY_TARGET to zeroB、Set the STATISTICS_LEVEL parameter to BASICC、Set the WORKAREA_SIZE_POLICY parameter to MANUALD、Set the PGA_AGGREGATE_TARGET parameter to nonzero value
From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You would like to ensure that users SYS and SYSTEM get priority over all other users. Which method would you use to achieve this objective？（）A、create a plan directive in the SYS_GROUPB、create the pending area for the consumer groupC、activate the provided SYSTEM_PLAN in Resource ManagerD、set the TIMED_STATISTICS parameter to TRUE in the parameter fileE、set the execution time limit for all users， except SYS and SYSTEM， in their profiles
A user complains that he gets the following error message repeatedly after executing some SQL statements.The error message forces the user to log off from and log onto the database to continue his work. ORA-02392：exceeded session limit on CPU usage，you are being logged off Which action would you take to increase the session limit on CPU usage？（）A、Modify the profile assigned to the user.B、Modify the roles assigned to the users.C、Modify the object privileges assigned to the user.D、Modify the system privileges assigned to the users.E、Modify the value for the RESOURCE_LIMIT parameter in the parameter file.
An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?（）A、You can conned as a common user by using the connect statement.B、You can connect as a local user by using the connect statement.C、You can connect by using easy connect.D、You can connect by using OS authentication.E、You can connect by using a Net Service name.F、You can connect as a local user by using the SET CONTAINER statement.
Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH； What would be the outcome of this command？ （）A、The command would return an error because LOG_BUFFER is a static parameter.B、The parameter value would be changed and it would come into effect immediately.C、You need to restart the database so that parameter changes can come into effect.D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
The database users are connecting to the PROD database from different applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective？ （）A、set the SESSIONS to 1 in the parameter fileB、grant SINGLE SESSION privilege to all of the usersC、set the SESSIONS_PER_USER to 1 in the users’ profileD、grant RESTRICTED SESSION privilege to all of the database usersE、create a role with SINGLE SESSION privilege and assign the role to the users
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
单选题A user complains that he gets the following error message repeatedly after executing some SQL statements.The error message forces the user to log off from and log onto the database to continue his work. ORA-02392：exceeded session limit on CPU usage，you are being logged off Which action would you take to increase the session limit on CPU usage？（）AModify the profile assigned to the user.BModify the roles assigned to the users.CModify the object privileges assigned to the user.DModify the system privileges assigned to the users.EModify the value for the RESOURCE_LIMIT parameter in the parameter file.
单选题Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?（）ANLS_SORT = BINARYBNLS_SORT = BINARY_AICNLS_SORT = BINARY_CIDNLS_SORT = BINARY_AI_CIEBinary sorts are case insensitive and accent insensitive by default.
多选题In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）Athe alert log fileBthe core dump filesCthe change tracking fileDthe user session trace filesEthe database audit trail filesFthe background process trace files
单选题A user complains that he gets the following error message repeatedly after executing some SQL statements. The error message forces the user to log off from and log on to the database to continue his work. ORA-02392： exceeded session limit on CPU usage， you are being logged off Which action would you take to increase the session limit on CPU usage？（）AModify the profile assigned to the user.BModify the roles assigned to the users.CModify the object privileges assigned to the user.DModify the system privileges assigned to the users.EModify the value for the RESOURCE_LIMIT parameter in the parameter file.
单选题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？（）Aby setting the SQL_TRACE parameter to FALSE in the parameter fileBby using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user sessionCby setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user sessionDby setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session
单选题You issued the following statement： SQL ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1； Which parameter is NOT overridden by using the above statement？（）A the value of the NLS_LANGUAGE variableB the value of the NLS_TERRITORY variableC the value of the NLS_CURRENCY variableDthe character encoding scheme used by the client application
单选题You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process. Which action will enable you to disable the trace files generated by the ARCn background process？（）A Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.B Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.C Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.D Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.
单选题You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE; Which is true about the result of this command?（）AThe STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.BThe STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.CThe STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.DNothing happens; because there is no SPFILE for each PDB, the statement is ignored.
单选题For the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）A Set the CPU time per call in the users profile.B Set the CPU time per session in the users profile.C Set the CPU levels for the user’s group using Resource Manager.D Set the TIMED_STATISTICS parameter to TRUE in the parameter file.
单选题Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts？（）A NLS_SORT = BINARYB NLS_SORT = BINARY_AIC NLS_SORT = BINARY_CID NLS_SORT = BINARY_AI_CIE Binary sorts are case insensitive and accent insensitive by default
单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this？（）A Set MEMORY_TARGET to zeroB Set the STATISTICS_LEVEL parameter to BASICC Set the WORKAREA_SIZE_POLICY parameter to MANUALD Set the PGA_AGGREGATE_TARGET parameter to nonzero value
单选题From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）A set the CPU time per call in the users profileB set the CPU time per session in the users profilesC set the TIMED_STATISTICS parameter to TRUE in the parameter fileD set the CPU levels for the users’ group using Resource Manager
单选题You have just finished aligning a Cisco Aironet 1400 Series Wireless Bridge link using installationmode.When you set the link back to operational mode you loose association to the root bridge. Which action will correct the problem？（）AConfigure the bridge to force infrastructure devices to associate only to the SSID parameter.BEnable passwords on both bridges.CConfigure the distance parameter value.DConfigure the proper channel.