In Oracle 11g,by default which one of the following conditio

题目
单选题
In Oracle 11g,by default which one of the following conditions implicitly enables Automatic PGA Memory Management?()
A

 Setting a nonzero value for SGA_TARGET

B

 Configuring Automatic Shared Memory Management

C

 Configuring Automatic Memory Management

D

 Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET

E

 None of the above

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Which setting enables the baselines by default in Oracle Database 11g?()

A. setting the STATISTICS_LEVEL parameter to TYPICAL

B. adding filters to the Automatic Database Diagnostic Monitor (ADDM)

C. enabling Automated Maintenance Task using Oracle Enterprise Manager

D. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE


参考答案:A

第2题:

Which Oracle Database component is audited by default if the unified Auditing option is enabled?()

A. Oracle Data Pump

B. Oracle Recovery Manager (RMAN)

C. Oracle Label Security

D. Oracle Database Vault

E. Oracle Real Application Security


参考答案:B

第3题:

Examine the following RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?()

A. Provide a password for the encryption

B. Set up an Oracle wallet for the encryption

C. No setup is required as it is a default encryption method

D. Both Oracle wallet and password must be set up for the encryption


参考答案:B

第4题:

Examine the following RMAN command:   RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;   Which prerequisite must be met before accomplishing the backup?()

  • A、 Provide a password for the encryption
  • B、 Set up an Oracle wallet for the encryption
  • C、 No setup is required as it is a default encryption method
  • D、 Both Oracle wallet and password must be set up for the encryption

正确答案:B

第5题:

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process,you execute the following script:   SQL>@utlu111i.sql   Which statement about the execution of this script is true?()

  • A、 It must be executed from the Oracle Database 11g environment.
  • B、 It must be executed only after the SYSAUX tablespace has been created.
  • C、 It must be executed from the environment of the database that is being upgraded.
  • D、 It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
  • E、 It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

正确答案:C

第6题:

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:SQL>@utlu111i.sqlWhich statement about the execution of this script is true?()

A. It must be executed from the Oracle Database 11g environment.

B. It must be executed only after the SYSAUX tablespace has been created.

C. It must be executed from the environment of the database that is being upgraded.

D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.

E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.


参考答案:C

第7题:

Which Oracle Database component is audited by default if the unified Auditing option is enabled?()

  • A、Oracle Data Pump
  • B、Oracle Recovery Manager (RMAN)
  • C、Oracle Label Security
  • D、Oracle Database Vault
  • E、Oracle Real Application Security

正确答案:B

第8题:

Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g?()

A. It does not allow you to change the moving window size.

B. Adaptive threshold functionalities use it by default to compute statistics.

C. It is created by default with the window size being equal to the AWR retention time.

D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).


参考答案:B, C

第9题:

You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database?() 

  • A、 The audit trail is stored in an operating system file.
  • B、 Auditing is disabled for all privileges.
  • C、 The audit trail is stored in the database.
  • D、 Auditing is enabled for all privileges.
  • E、 Auditing is enabled for certain privileges related to database security.

正确答案:C,E

第10题:

 You are creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?()

  • A、DEFAULT STORAGE 
  • B、EXTENT MANAGEMENT 
  • C、AUTOEXTEND 
  • D、DATAFILE

正确答案:C

更多相关问题