Note the following parameters settings in your database: https://assets.asklib.com/images/image2/2018080209133885554.jpg What would happen?（）

A . It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically B . It will be successful only if the memory is available from the auto tuned components C . It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET D . It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE

时间：2022-10-17 01:16:32 所属题库：OCP 11G认证考试题库

相似题目

Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）

A . Automatic PGA Memory Management B . Automatic SGA Memory Management C . Automatic Shared Memory Management D . Automatic Memory Management E . Manual SGA Memory Management F . None of the above

查看最佳答案
When configuring the messaging system， which of the following are valid parameters for the file transport？（）

A . File Name B . Operating System C . Location D . Host E . Mode

查看最佳答案
The NLS_SORT parameter sets the default sort method for which of the following operations？（）

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

查看最佳答案
Which of the following are valid settings for the NLS_COMP parameter？（）

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

查看最佳答案
Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository？（）

A . BACKGROUND_DUMP_DEST B . FOREGROUND_DUMP_DEST C . CORE_DUMP_DEST D . USER_DUMP_DEST E . DIAGNOSTIC_DEST F . All of the above

查看最佳答案
The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following globalization elements？（）

A . Date format B . Decimal character C . Group separator D . First day of the month E . None of the above F . All of the above

查看最佳答案
Which of the following commands should be used to reset the Virtual Memory Manager tuning parameters to their default values？（）

A . schedtune -t B . vmtune -R C . schedtune -r D . schedtune -D

查看最佳答案
Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object？（）

A . PLSQL_BLOCK B . JAVA_STORED_PROCEDURE C . STORED_PROCEDURE D . EXECUTABLE E . None of the above are invalid settings.

查看最佳答案
You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）

A . STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN； B . STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS； C . STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS； D . STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；

查看最佳答案
A storage specialist needs to create a new host connection using the DSCLI. Which of the following parameters identifies the host（）

A . hosttype B . volume group C . ioports D . WWPN

查看最佳答案
Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?（）

A . PLSQL_BLOCK B . JAVA_STORED_PROCEDURE C . STORED_PROCEDURE D . EXECUTABLE E . None of the above are invalid settings.

查看最佳答案
Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters？（）

A . SORT_AREA_SIZE B . HASH_AREA_SIZE C . BITMAP_MERGE_AREA_SIZE D . CREATE_BITMAP_AREA_SIZE E . PGA_AGGREGATE_TARGET

查看最佳答案
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 commands should be used to view and change the network filesystem tuning parameters available on the system？（）

A . no B . nfso C . vmtune D . exportf

查看最佳答案
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

查看最佳答案
Which of the following parameters must be specified to define the number of dispatchers that need to be started？（）

A . MAX_DISPATCHERS B . DISPATCHERS C . MIN_DISPATCHERS D . SHARED_SERVERS

查看最佳答案
Which one of the following files includes the parameter NAMES.DIRECTORY_PATH（hostname）？（）

A . Listener.ora B . Tnsnames.ora C . Cman.ora D . Sqlnet.ora

查看最佳答案
Which of the following parameters defines the location where Oracle should create archived redo logs?（）

A . LOG_ARCHIVE_1 B . LOG_DESTINATION_1 C . LOG_ARCHIVED_DESTINATION_1 D . LOG_ARCHIVE_DEST_1 E . LOG_ARCHIVE_SOURCE_1

查看最佳答案
When configuring the messaging system， which of the following are parameters of the e-mail transport？（）

A . Location B . Protocol C . Mode D . Web Address E . Host

查看最佳答案
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

查看最佳答案
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

查看最佳答案

Note the following parameters settings in your database: https://assets.asklib.com/images/image2/2018080209133885554.jpg What would happen?（）

相似题目

推荐题目