单选题Your database is running on the automatic Program Global Area (PGA) memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do?()A modify the HASH_AREA_SIZE initialization parameterB modify the PGA_AGGREGATE_TARGET initialization parameterC modify the WORK_AREASIZE_POLICY initialization parameterD increase the value of the SGA_TARGET initialization parameterE increase the value of the SGA_MAX_SIZE initialization parameterF increase the value of the SORT_AREA_SIZE initialization parameter

单选题
Your database is running on the automatic Program Global Area (PGA) memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do?()
A

 modify the HASH_AREA_SIZE initialization parameter

B

 modify the PGA_AGGREGATE_TARGET initialization parameter

C

 modify the WORK_AREASIZE_POLICY initialization parameter

D

 increase the value of the SGA_TARGET initialization parameter

E

 increase the value of the SGA_MAX_SIZE initialization parameter

F

 increase the value of the SORT_AREA_SIZE initialization parameter


参考解析

解析: 暂无解析

相关考题:

Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?()A. User processB. Server processC. System Monitor (SMON)D. Process Monitor (PMON)E. Checkpoint process (CKPT)

Which two are the prerequisites to enable Flashback Data Archive?() (Choose two.) 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).

You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario? ()A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.

Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command:   RESTORE CONTROLFILE FROM AUTOBACKUP;   Which of the following statements is true?() A、 The command restores only the missing control file.B、 The command restores all the control files.C、 The command fails because the database is running.D、 This is the correct way to address this problem.E、 This is not the correct way to address this problem.

The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings, workload profile,and statistics to diagnose the possible causes of the performance degradation?()A、by using the SQL access advisorB、by using the Automatic Workload Repository reportC、by running the Automatic Database Diagnostic Monitor (ADDM)D、by using the Automatic Workload Repository Compare Period reportE、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view

You work as a database administrator for Supportcenter.cn. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to, in order to determine the appropriate indexes?()A、Memory AdvisorsB、Segment AdvisorsC、SQL Tuning and Access AdvisorsD、Automated Workload Repository (AWR)E、Automatic Database Diagnostic Monitor (ADDM)

You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor?()A、 The database must be in the ARCHIVELOG mode.B、 The automatic memory tuning must be enabled.C、 The change tracking feature must be enabled.D、 The automatic memory tuning must be disabled.

Identify the memory component from which memory may be allocated for: () 1: Session memory for the shared server  2: Buffers for I/O slaves  3: Oracle Database Recovery Manager (RMAN) backup and restore operations A、Large PoolB、Redo Log BufferC、Database Buffer CacheD、Program Global Area (PGA)

SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason?()A、The User Global Area (UGA) is not configured.B、The sessions were started using the login name SYS.C、The sessions are running in the Automatic Shared Memory Management mode.D、The sessions are running in the automatic Program Global Area (PGA) memory management mode.

You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area (SGA) are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page.  Which two links should you click to go to the Memory Advisor page?() A、 Advisor CentralB、 Global AttributesC、 Resource MonitorsD、 Memory ParametersE、 Database Usage StatisticsF、 All Initialization ParametersG、 Automatic Workload Repository

For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?()  A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above

You have a single Automatic Storage Management (ASM) instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file?()A、 INSTANCE_TYPEB、 DB_UNIQUE_NAMEC、 ASM_DISKSTRINGD、 ASM_POWER_LIMIT

Identify the memory component from which memory may be allocated for:() 1. Session memory for the shared server 2. Buffers for I/O slaves 3. Oracle Database Recovery Manager (RMAN) backup and restore operationsA、Large PoolB、Redo Log BufferC、Database Buffer CacheD、Program Global Area (PGA)

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).

单选题You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor?()A The database must be in the ARCHIVELOG mode.B The automatic memory tuning must be enabled.C The change tracking feature must be enabled.D The automatic memory tuning must be disabled.

单选题The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings, workload profile, and statistics to diagnose the possible causes of the performance degradation?()Aby using the SQL access advisorBby using the Automatic Workload Repository reportCby running the Automatic Database Diagnostic Monitor (ADDM)Dby using the Automatic Workload Repository Compare Period reportEby analyzing the output of the V$ACTIVE_SESSION_HISTORY view

单选题Examine the parameter setting in your database: Which statement is correct about the database?()A Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not setB The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are setC The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are setD Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup

单选题Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:   SQL SELECT * FROM sales;   Which process would retrieve the result from the database and return it to the client program?()A User processB Server processC System Monitor (SMON)D Process Monitor (PMON)E Checkpoint process (CKPT)

多选题Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true?()AThe destination must be global only.BA maximum of five destinations can be assigned.CA maximum of ten different destinations can be assigned.DAll the destinations are determined by the server automatically.EThe destination may be local or remote for a Standby Database.FThe destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.

单选题While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective?()Aconfigure the database to run in ARCHIVELOG modeBconfigure the Flash Recovery Area to enable automatic database backupCschedule the database backup using DBMS_JOB package after creating the databaseDschedule the database backup using Recovery Manager (RMAN)commands after creating the databaseEschedule the database backup using Database Configuration Assistant (DBCA)while creating the database

单选题Your database is running on the automatic Program Global Area (PGA) memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do?()A modify the HASH_AREA_SIZE initialization parameterB modify the PGA_AGGREGATE_TARGET initialization parameterC modify the WORK_AREASIZE_POLICY initialization parameterD increase the value of the SGA_TARGET initialization parameterE increase the value of the SGA_MAX_SIZE initialization parameterF increase the value of the SORT_AREA_SIZE initialization parameter

单选题The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?()ACreate two custom ADDM tasks.BModify the AWR snapshot time interval to two hours.CCreate a new scheduler window for a time period of two hours.DModify the Automatic Workload Repository (AWR) snapshot retention period to two hours.

单选题Your database is running in the automatic Program Global Area (PGA) memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do?()Amodify the HASH_AREA_SIZE initialization parameterBmodify the PGA_AGGREGATE_TARGET initialization parameterCmodify the WORK_AREASIZE_POLICY initialization parameterDincrease the value of the SGA_TARGET initialization parameterEincrease the value of the SGA_MAX_SIZE initialization parameterFincrease the value of the SORT_AREA_SIZE initialization parameter

单选题Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?()AUser processBServer processCSystem Monitor (SMON)DProcess Monitor (PMON)ECheckpoint process (CKPT)

单选题You have a single Automatic Storage Management (ASM) instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file?()A INSTANCE_TYPEB DB_UNIQUE_NAMEC ASM_DISKSTRINGD ASM_POWER_LIMIT

多选题You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode.   Which two statements are correct in this scenario?()AThe WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.BThe Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.CSetting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management.DThe SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.

单选题For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?()A Automatic PGA Memory ManagementB Automatic SGA Memory ManagementC Automatic Shared Memory ManagementD Automatic Memory ManagementE Manual SGA Memory ManagementF None of the above

单选题SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason?()AThe User Global Area (UGA) is not configured.BThe sessions were started using the login name SYS.CThe sessions are running in the Automatic Shared Memory Management mode.DThe sessions are running in the automatic Program Global Area (PGA) memory management mode.