The NLS_SORT parameter sets the default sort method for which of the following operations？（）

相似题目

• In your database，the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）

  A . The optimizer statistics are collected automatically. B . Only the timed operating system （OS） statistics and plan execution statistics are collected. C . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization. D . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.  E . Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

  查看最佳答案

• 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

  查看最佳答案

• View the Exhibit to examine the replay settings for replay parameters.What is the implication for setting the values for replay parameters?（）https://assets.asklib.com/images/image2/2018080213555554170.png

  A . The COMMIT order in the captured workload is preserved during replay. B . The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls. C . The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured. D . The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying. E . The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.

  查看最佳答案

• Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY,and NLS_CHARACTERSET parameters?（）

  A . V$VALID_NLS_VALUES B . NLS_VALID_VALUES C . NLS_VALUE_OPTIONS D . V$NLS_VALUE_OPTIONS E . V$NLS_VALID_VALUES

  查看最佳答案

• Which of the following are valid settings for the NLS_COMP parameter？（）

  A .  ASCII B .  ANSI C .  BINARY D .  MONOLINGUAL E .  MULTILINGUAL

  查看最佳答案

• To which parameter should the access point be set during a site survey？（）

  A . Transmit only B . Diversity C . Receive only D . Single isolated antenna

  查看最佳答案

• You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD. The default format of which two data types would be affected by this setting？ （）

  A .  DATE B .  TIMESTAMP C .  INTERVAL YEAR TO MONTH D .  INTERVAL DAY TO SECOND E .  TIMESTAMP WITH LOCAL TIME ZONE

  查看最佳答案

• View the Exhibit and examine the initialization parameter settings. https://assets.asklib.com/images/image2/2018080116211316874.jpg Which three initialization parameters are to be set manually as they are not automatically tuned（）

  A . LOG_BUFFER B . SORT_AREA_SIZE C . JAVA_POOL_SIZE D . STREAMS_POOL_SIZE E . DB_16K_CACHE_SIZE F . DB_KEEP_CACHE_SIZE

  查看最佳答案

• The NLS_SORT parameter sets the default sort method for which of the following operations?（）

  A . WHERE clause WHERE B . ORDER BY clause C . BETWEEN clause D . NLSSORT function E . NLS_SORT functio

  查看最佳答案

• Which of the following parameter sets must be configured on the cisco wireless location appliance？（）

  A . network connections B . location views C . access points D . object definitio

  查看最佳答案

• Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts？（）  

  A .  NLS_SORT = BINARY B .  NLS_SORT = BINARY_AI C .  NLS_SORT = BINARY_CI D .  NLS_SORT = BINARY_AI_CI E .  Binary sorts are case insensitive and accent insensitive by default

  查看最佳答案

• Which of the following are valid settings for the NLS_COMP parameter?（）

  A . ASCII B . ANSI C . BINARY D . MONOLINGUAL E . MULTILINGUAL

  查看最佳答案

• You set the following parameters in the parameter file and restarted the database: https://assets.asklib.com/images/image2/2018080210353589884.jpg Which two statements are true regarding these parameters after the database instance is restarted?（）

  A . The MEMORY_MAX_TARGET parameter is automatically set to 500 MB B . The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually C . The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero D . The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively

  查看最佳答案

• In your database， the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impact of this setting？（）

  A . The optimizer statistics are collected automatically. B . Only the timed operating system （OS） statistics and plan execution statistics are collected. C . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization. D . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.  E . Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

  查看最佳答案

• Which of the following parameter sets must be configured on the Cisco Wireless Location Appliance？（）

  A . network connections B . location views C . access points D . object definitio

  查看最佳答案

• When setting up the Flashback Data Archive， which of these key parameters are required？（）

  A .  Tablespace name B .  Storage quota C .  Retention D .  Table name E .  Create a default archive

  查看最佳答案

• 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.

  查看最佳答案

• Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?（）

  A . NLS_SORT = BINARY B . NLS_SORT = BINARY_AI C . NLS_SORT = BINARY_CI D . NLS_SORT = BINARY_AI_CI E . Binary sorts are case insensitive and accent insensitive by default.

  查看最佳答案

• in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impactof this setting（）

  A . Optimizer statistics are collected automatically. B . Only timed operating system （OS） statistics and plan execution statistics are collected. C . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. D . Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package. E . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

  查看最佳答案

• In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）

  A . It degrades the run time and compiler performance. B . It provides better run time and compiler performance. C . It provides better optimization of the statement during parse time. D . It forces the rule based optimizer to be used for statement optimization. E . It provides better run time performance but slightly degraded compiler performance. F . It provides better run time performance but slightly degraded run time performance.

  查看最佳答案

• Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by default?（）

  A . 120M B . 320M C . 480M D . 600M

  查看最佳答案

• You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY­MM­DD. The default format of which two data types would be affected by this setting？（）

  A . DATE B . TIMESTAMP C . INTERVAL YEAR TO MONTH D . INTERVAL DAY TO SECOND E . TIMESTAMP WITH LOCAL TIME ZONE

  查看最佳答案

• You set the following parameters in the parameter file and restarted the database:Which two statements are true regarding these parameters after the database instance is restarted？（）

  <img src='https://img2.soutiyun.com/shangxueba/ask/64233001-64236000/64234478/9691c5b47b07d813739fc0e9660c9439.jpg' /> A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively

  查看最佳答案