多选题Examine the values for the following initialization parameters: FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database()AThe SGA advisor will be disabled.BThe MTTR advisor will be disabled.CAutomatic checkpoint tuning will be disabled.DCheckpoint information will not be written to the alert log file.

多选题
Examine the values for the following initialization parameters: FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database()
A

The SGA advisor will be disabled.

B

The MTTR advisor will be disabled.

C

Automatic checkpoint tuning will be disabled.

D

Checkpoint information will not be written to the alert log file.


参考解析

解析: 暂无解析

相关考题:

Which two statements are true regarding the starting of the database instance using the following command?()SQLSTARTUP UPGRADE A. It enables all system triggers.B. It allows only SYSDBA connections.C. It ensures that all job queues remain active during the upgrade process.D. It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.

Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B?() A. A must contain all of the characters defined in BB. A must be UnicodeC. The encoded values in A must match the encoded values in B for all characters defined in BD. A must be a multibyte character setE. The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B

Examine the structure of the EMPLOYEES table:You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:Which UPDATE statement meets the requirements?()A.B.C.D.E.

Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0MEMORY_TARGET=0SGA_TARGET=0PGA_AGGREGATE_TARGET=500mWhich three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?()A. LOG_BUFFERB. SORT_AREA_SIZEC. JAVA_POOL_SIZED. STREAMS_POOL_SIZEE. DB_16K_CACHE_SZIEF. DB_KEEP_CACHE_SIZE

What are the values of a, b, and c after the following instructions:int a=5, b=7, c;c = a+++b;

What values are printed when the following C program is executed?int i = 8;void main(void)(

Which of the following is not considered a common approach to narrow the field of potentialproblem causes? (Choose the best answer.)()A、Following the traffic pathB、Top-downC、Comparing configurationsD、Bottom-upE、Divide and conquerF、Examine SLAs

Which two statements are true regarding the starting of the database instance using the following command?() SQLSTARTUP UPGRADEA、It enables all system triggers.B、It allows only SYSDBA connections.C、It ensures that all job queues remain active during the upgrade process.D、It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.

Examine the following options, Multicasting supports applications that communicate.()A、many - to - oneB、one - to - oneC、one - to - manyD、many - to - many

Which of the following commands should Karen, a technician, use to examine and restoreprotected system files?()A、SFCB、RECOVERC、REPLACED、COPY

When monitoring a system using vmstat with an interval, which of the following conclusions should be drawn about the metrics under page pi and page po?()A、 The values do not include working storage.B、 The values do not include persistent storage.C、 The values include both persistent and working storage.D、 The values are not working or persistent storage.

Examine the values for the following initialization parameters: FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database()A、The SGA advisor will be disabled.B、The MTTR advisor will be disabled.C、Automatic checkpoint tuning will be disabled.D、Checkpoint information will not be written to the alert log file.

Examine the following values of the initialization parameters in the database having the SID ORCL: BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What is the location of the Automatic Diagnostic Repository (ADR) home?()A、/u01/app/oracle/product/11.1.0/db_1B、/u01/app/oracleC、$ORACLE_HOME/bdumpD、$ORACLE_HOME/log

To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, you can set values for which of the following initialization parameters?()A、 DB_CACHE_SIZEB、 SHARED_POOL_SIZEC、 LARGE_POOL_SIZED、 JAVA_POOL_SIZEE、 SGA_MAX_SIZEF、 SORT_AREA_SIZE

You included the following Automatic Storage Management (ASM) initialization parameter settings in the ASM initialization parameter file:   INSTANCE_TYPE = ASM  ASM_POWER_LIMIT = 11  LARGE_POOL_SIZE = 4M   ASM_DISKGROUPS = DG1, DG2  DB_UNIQUE_NAME = +ASM   You are unable to start the ASM instance. Which initialization parameter file setting(s) is not allowing the ASM instance to start?()A、 only the INSTANCE_TYPE initialization parameter is set to an invalid valueB、 only the ASM_POWER_LIMIT initialization parameter is set to an invalid valueC、 only the LARGE_POOL_SIZE initialization parameter is set to an invalid valueD、 both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values

单选题Examine the following values of the initialization parameters in the database having the SID ORCL:   BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST=   The environment variables have the following value:   ORACLE_BASE=/u01/app/oracle  ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1   What is the location of the Automatic Diagnostic Repository (ADR) home?()A /u01/app/oracle/product/11.1.0/db_1B /u01/app/oracleC $ORACLE_HOME/bdumpD $ORACLE_HOME/log

多选题Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?()ALOG_BUFFERBSORT_AREA_SIZECJAVA_POOL_SIZEDSTREAMS_POOL_SIZEEDB_16K_CACHE_SZIEFDB_KEEP_CACHE_SIZE

单选题When monitoring a system using vmstat with an interval, which of the following conclusions should be drawn about the metrics under page pi and page po?()A The values do not include working storage.B The values do not include persistent storage.C The values include both persistent and working storage.D The values are not working or persistent storage.

多选题To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, you can set values for which of the following initialization parameters?()ADB_CACHE_SIZEBSHARED_POOL_SIZECLARGE_POOL_SIZEDJAVA_POOL_SIZEESGA_MAX_SIZEFSORT_AREA_SIZE

单选题Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?()AThe next value will be 0 and the sequence will never use the values 101 to 105.BThe next value will be 101 to ensure uniqueness between existing and newly generated sequence values.CPreviously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.DThe next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.

多选题Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B?()AA must contain all of the characters defined in BBA must be UnicodeCThe encoded values in A must match the encoded values in B for all characters defined in BDA must be a multibyte character setEThe encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B

多选题Examine the values for the following initialization parameters: FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database()AThe SGA advisor will be disabled.BThe MTTR advisor will be disabled.CAutomatic checkpoint tuning will be disabled.DCheckpoint information will not be written to the alert log file.

多选题You set the value of the SGA_TARGET initialization parameter to 1G to enable Oracle to automatically resize most of the memory components according to the current workload in the database. You issue the following statement:   SQL SELECT name, value, isdefault  2 FROM v$parameter   3 WHERE name LIKE ’%size%’;   The output of this statement displays that the DB_CACHE_SIZE, SHARED_POOL_SIZE,  LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters contain a zero value.  What does this imply?()AThe SGA_TARGET initialization parameter cannot be set to a value less than 1GBThe SGA_TARGET initialization parameter cannot be set to a value greater than 1GCThe Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGADThe values of the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters cannot be set manually.ENo minimum limits are imposed on the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and  JAVA_POOL_SIZE initialization parameters.FThe Automatic Shared Memory Management feature cannot be disabled unless you specify values for the  DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.

单选题You included the following Automatic Storage Management (ASM) initialization parameter settings in the ASM initialization parameter file:   INSTANCE_TYPE = ASM  ASM_POWER_LIMIT = 11  LARGE_POOL_SIZE = 4M   ASM_DISKGROUPS = DG1, DG2  DB_UNIQUE_NAME = +ASM   You are unable to start the ASM instance. Which initialization parameter file setting(s) is not allowing the ASM instance to start?()A only the INSTANCE_TYPE initialization parameter is set to an invalid valueB only the ASM_POWER_LIMIT initialization parameter is set to an invalid valueC only the LARGE_POOL_SIZE initialization parameter is set to an invalid valueD both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values

多选题Which two statements are true regarding the starting of the database instance using the following command?() SQLSTARTUP UPGRADEAIt enables all system triggers.BIt allows only SYSDBA connections.CIt ensures that all job queues remain active during the upgrade process.DIt sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.

多选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table? ()AINSERT INTO employees VALUES (NULL, 'JOHN','Smith');BINSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');CINSERT INTO employees VALUES ('1000','JOHN','NULL');DINSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');EINSERT INTO employees (employee_id) VALUES (1000);FINSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',);

单选题The SPFILE for the PROD database specifies the following initialization parameter values:   SGA_TARGET = 2G   DB_8K_CACHE_SIZE = 128M   You create a tablespace named HR with the non-standard block size of 8K. Four database users are running queries on a table in the HR tablespace. These users complain that the queries are taking longer than usual to complete. While investigating the reasons for this delay, you discover that the database encounters extensive cache misses on the database buffer cache with the block size of 8K. You issue the following statement to increase the value of the DB_8K_CACHE_SIZE initialization parameter to 256M:   SQLALTER SYSTEM SET DB_8K_CACHE_SIZE=256M SCOPE = BOTH;   What is the result of this statement?()A The statement fails because you cannot set the memory components manually if the SGA_TARGET initialization parameter is set to a nonzero value.B The statement fails because the DB_8K_CACHE_SIZE initialization parameter is not a dynamic parameter.C The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and extracts an additional 128M of memory from the automatically sized memory components.D The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and reallocates an additional 128M memory from the memory components that are not auto-tuned.

多选题Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?()ALOG_BUFFERBSORT_AREA_SIZECJAVA_POOL_SIZEDSTREAMS_POOL_SIZEEDB_16K_CACHE_SZIEFDB_KEEP_CACHE_SIZE