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

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.

A .  FRENCH_AI B .  FRENCH_CI C .  AI_FRENCH D .  CI_FRENCH

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.

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

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

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

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

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

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

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

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

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

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

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.

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

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

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.

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.

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.

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.

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

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

<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