Which setting enables the baselines by default in Oracle Database 11g？（）  

相似题目

• For SLIP to work， what should the "Enable Login" value be set to on both systems？（）

  A . Enable B . Disable C . Share D . Delay

  查看最佳答案

• 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

  查看最佳答案

• Which initialization parameter must you set to enable automatic archiving？ （）

  A . LOG_ARCHIVE_DEST B . LOG_ARCHIVE_START C . LOG_ARCHIVE_FORMAT D . LOG_ARCHIVE_MAX_PROCESSES

  查看最佳答案

• Two access points running the core feature set are connected to the same switch and are providingguest services. If PSPF is enabled， what must be enabled on the switch to prevent clients fromseeing one another’s data？（）

  A . port-based RADIUS B . 802.1q trunking C . inline power D . protected port

  查看最佳答案

• You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUTparameter set to a nonzero value.Which three statements about resumable space allocation are true? （）(Choose three.)

  A . Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session. B . A resumable statement is suspended only if an out of space error occurs. C . When a resumable statement is suspended, the transaction that contains the statement is also suspended. D . A resumable statement can only be suspended and resumed once during the execution of the statement. E . You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a sessio

  查看最佳答案

• Which command will enable the administrator to query the current network adapter configuration？（）

  A . netstat -v B . entstat -d C . lsattr -El D . lsdev -C -attr

  查看最佳答案

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

  查看最佳答案

• Which two initialization parameters would you set to enable Automatic Shared Memory Management？（）

  A .  set SHARED_POOL_SIZE to zero B .  set STATISTICS_LEVEL to BASIC C .  set SGA_TARGET to a non-zero value D .  set DB_CACHE_SIZE to a non-zero value E .  set STATISTICS_LEVEL to TYPICAL or ALL

  查看最佳答案

• You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level?（）

  A . issuing the ALTER SYSTEM ENABLE RESUMABLE; statement B . issuing the ALTER SESSION ENABLE RESUMABLE; statement C . modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value D . issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=<nonzero value>; statement

  查看最佳答案

• You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value.Which three statements about resumable space allocation are true? （）

  A . Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session. B . A resumable statement is suspended only if an out of space error occurs. （Out of space condition Maximum extents reached condition，Space quota exceeded condition） C . When a resumable statement is suspended, the transaction that contains the statement is also suspended. D . A resumable statement can only be suspended and resumed once during the execution of the statement. E . You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.

  查看最佳答案

• Which two initialization parameters would you set to enable Automatic Shared Memory Management?（）

  A . set SHARED_POOL_SIZE to zero B . set STATISTICS_LEVEL to BASIC C . set SGA_TARGET to a non-zero value D . set DB_CACHE_SIZE to a non-zero value E . set STATISTICS_LEVEL to TYPICAL or ALL

  查看最佳答案

• You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below：  SGA_TARGET= 10GB  SGA_MAX_SIZE = 14GB  STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB  Which two statements are correct in this scenario？ （）

  A .  A maximum of 3 GB can be allocated to shared pool B .  The value for SGA_TARGET can be increased up to a maximum of 15 GB C .  A total of 14 GB memory will be allocated to the automatically tuned memory components. D .  Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE E .  Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters F .  Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB

  查看最佳答案

• If IP routing is enabled, which two commands set the gateway of last resort to the default gateway?（）

  A . ip default-gateway 0.0.0.0 B . ip route 172.16.2.1 0.0.0.0 0.0.0.0 C . ip default-network 0.0.0.0 D . ip default-route 0.0.0.0 0.0.0.0 172.16.2.1 E . ip route 0.0.0.0 0.0.0.0 172.16.2.1

  查看最佳答案

• Which command will enable the administrator toquery the current network adapter configuration?（）

  A . netstat -v B . entstat -d C . lsattr -El D . lsdev -C -attr

  查看最佳答案

• Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?（）

  A . Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file. B . All DDL commands are logged in the alert log file. C . All DDL commands are logged in a different log file that contains DDL statements and their execution dates. D . Only DDL commands that resulted in the creation of new segments are logged. E . All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

  查看最佳答案

• By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value， you will enable which of the following memory-management options？（）  

  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

  查看最佳答案

• You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）  

  A .  Drop the table. B .  Partition the table. C .  Truncate the table. D .  Add a column to the table. E .  Rename a column in the table.

  查看最佳答案

• Which command sets and automatically encrypts the privileged enable mode password？（）

  A . enbale password c1sco B . secret enable c1sco C . password enable c1sco D . enable secret c1sco

  查看最佳答案

• Two access points running the core feature set are connected to the same switch and are  providing guest services. if pspf is enabled. What must be enabled on the switch to prevent clients from seeing one another’s data？（）

  A . port-based radius B . 802.1q trunking C . inline power D . protected port

  查看最佳答案

• Which command sets and automatically encrypts the privileged enable mode password?（）

  A . enbale password c1sco B . secret enable c1sco C . password enable c1sco D . enable secret c1sco

  查看最佳答案

• The enableModifiedFlag enables which of the following？（）

  A . User initiated edit document command B . Silent navigation from an edited page C . User initiated save command D . Removal of a locked for editing statu

  查看最佳答案

• You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below：  SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB  STREAMS_POOL_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  Which two statements are correct in this scenario？ （）

  A .  A total of 14 GB memory will be allocated to the automatically tuned memory components B .  Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB C .  The value for SGA_TARGET can be increased up to a maximum of 14 GB D .  A maximum of 3 GB can be allocated to shared pool E .  Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters F .  Increasing the value for SGA_TARGET will automatically increase the memory allocated for  STREAMS_POOL_SIZE

  查看最佳答案

• Which two are the prerequisites to enable Flashback Data Archive？（）

  A .  Database must be running in archivelog mode. B .  Automatic undo management must be enabled. C .  Undo retention guarantee must be enabled. D .  The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management （ASSM）.

  查看最佳答案

• Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?（）

  A . None of the data definition language (DDL) statements are logged in the trace file. B . Only DDL commands that resulted in errors are logged in the alert log file. C . A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file. D . Only DDL commands that resulted in the creation of new database files are logged.

  查看最佳答案