You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA？（）A

题目

You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA？（）

  • A、 SQL Tuning Advisor
  • B、 Undo Advisor
  • C、 ADDM
  • D、 Memory Advisor
相似考题

1.You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big filetablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.Which method would accomplish the task quickly and efficiently?（）A. parallel image copy backupB. backup with MAXPIECESIZE configured for the channelC. parallel backup with MAXPIECESIZE configured for the channelD. intrafile parallel backup

2. Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.  Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）A、the retention period to support flashbackB、the expected length of the longest-running queryC、the number of undo tablespaces in the databaseD、the size of the Flash Recovery Area for the database instance

3.You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D、 Increase the value of the SGA_TARGET initialization parameter.

4.You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.You want the users to be able to add data, and you want to minimize administrative overhead. What should you do?A．Increase the maximum file size of Sales_Data to 1,500MB.B．Use the DBCC SHRINKDATABASE statement.C．Set automatic file growth to 10 percent.D．Create another data file named Sales_Data2 in a new SECONDARY filegroup.

更多“You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA？（）A”相关问题

  • 第1题：

    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？（）

    • 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

    正确答案:B

  • 第2题：

    You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）

    • A、 V$FLASHBACK_DATABASE_LOG
    • B、 V$FLASHBACK_DATABASE_STAT
    • C、 V$DATABASE
    • D、 V$UNDOSTAT

    正确答案:A

  • 第3题：

    You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA， a big file tablespace of size 100 TB on tape drive， but you have tapedrives of only 10 GB each.  Which method would accomplish the task quickly and efficiently？（）  

    • A、 parallel image copy backup
    • B、 backup with MAXPIECESIZE configured for the channel
    • C、 parallel backup with MAXPIECESIZE configured for the channe
    • D、 intrafile parallel backup

    正确答案:D

  • 第4题：

    You are maintaining the SALES database on Oracle 10g. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter will you specify to control the speed of the rebalancing activity？ （） 

    • A、 ASM_POWER_LIMIT
    • B、 ASM_DISKSTRING
    • C、 ASM_DISKGROUPS
    • D、 LARGE_POOL_SIZE

    正确答案:A

  • 第5题：

    You are maintaining the SALES database. You have added a new disk to a disk group. Automatic StorageManagement performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?（）

    • A、ASM_POWER_LIMIT
    • B、ASM_DISKSTRING
    • C、ASM_DISKGROUPS
    • D、INSTANCE_TYPE

    正确答案:A

  • 第6题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which is named Instance01. Instance01 contains a database which is named Dworks. The bulk-logged recovery mode is used by the Dworks database. You log ship the Dworks database through a WAN link. A scheduled job rebuilds the indexes of the Dworks database. You find that the size of the log backups for log shipping has been enlarged by the job. Now you have to reduce the size of the log backup.  So what action should you perform to achieve this goal？（）  

    • A、You should recreate the indexes. 
    • B、You should compress the log file backups 
    • C、You should make the Dworks database use the Full recovery mode 
    • D、You should make the Dworks database use the Simple recovery mode.

    正确答案:B

  • 第7题：

    单选题
    You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required？（）
    A

     V$DATABASE

    B

     V$FLASHBACK_DATABASE_STAT

    C

     V$FLASHBACK_DATABASE_LOG

    D

     V$RECOVERY_FILE_DEST


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA？（）
    A

     SQL Tuning Advisor

    B

     Undo Advisor

    C

     ADDM

    D

     Memory Advisor


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    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？（）
    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


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    You are maintaining the SALES database on Oracle 10g. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter will you specify to control the speed of the rebalancing activity？ （）
    A

     ASM_POWER_LIMIT

    B

     ASM_DISKSTRING

    C

     ASM_DISKGROUPS

    D

     LARGE_POOL_SIZE


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which is named Instance01. Instance01 contains a database which is named Dworks. The bulk-logged recovery mode is used by the Dworks database. You log ship the Dworks database through a WAN link. A scheduled job rebuilds the indexes of the Dworks database. You find that the size of the log backups for log shipping has been enlarged by the job. Now you have to reduce the size of the log backup.  So what action should you perform to achieve this goal？（）
    A

    You should recreate the indexes. 

    B

    You should compress the log file backups 

    C

    You should make the Dworks database use the Full recovery mode 

    D

    You should make the Dworks database use the Simple recovery mode.


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）
    A

     Increase the value of the FAST_START_MTTR_TARGET initialization parameter.

    B

     Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.

    C

     Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.

    D

     Increase the value of the SGA_TARGET initialization parameter.


    正确答案： B
    解析： 暂无解析

  • 第13题：

    Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）

    • A、The retention period to support flashback
    • B、The expected length of the longest-running query
    • C、The number of undo tablespaces in the database
    • D、The size of the Flash Recovery Area for the database instance

    正确答案:A,B

  • 第14题：

    You work as a database administrator for Certkiller .com. In your production  database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task？（）

    • A、You must have started the database instance in restricted mode.
    • B、You must have started the database instance inNORMALmode.
    • C、You must have started the database instance with server parameter file.
    • D、You must have started the database instance but must not have mounted.
    • E、You must have started the database instance but must not have opened.

    正确答案:C

  • 第15题：

    You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required？（）

    • A、 V$DATABASE
    • B、 V$FLASHBACK_DATABASE_STAT
    • C、 V$FLASHBACK_DATABASE_LOG
    • D、 V$RECOVERY_FILE_DEST

    正确答案:B

  • 第16题：

    You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task？（）

    • A、 the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
    • B、 the column of the V$INSTANCE_RECOVERY view
    • C、 the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
    • D、 the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view

    正确答案:C

  • 第17题：

    ou are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?（）

    • A、parallel image copy backup 
    • B、backup with MAXPIECESIZE configured for the channel 
    • C、parallel backup with MAXPIECESIZE configured for the channel 
    • D、intrafile parallel backup

    正确答案:D

  • 第18题：

    单选题
    You have 100 segments in the USERS tablespace. You get an alert that the USERS tablespace is running low on space. You decide to shrink some segments. Which option would you use to determine which segments to shrink?（）
    A

    Segment Advisor 

    B

    SQL Tuning Advisor 

    C

    SQL Access Advisor 

    D

    Segment Resource Estimation 

    E

    Automatic Database Diagnostic Monitor (ADDM)


    正确答案： A
    解析： 暂无解析

  • 第19题：

    多选题
    Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
    A

    The retention period to support flashback

    B

    The expected length of the longest-running query

    C

    The number of undo tablespaces in the database

    D

    The size of the Flash Recovery Area for the database instance


    正确答案： D,B
    解析： 暂无解析

  • 第20题：

    多选题
    Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.  Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
    A

    the retention period to support flashback

    B

    the expected length of the longest-running query

    C

    the number of undo tablespaces in the database

    D

    the size of the Flash Recovery Area for the database instance


    正确答案： D,A
    解析： 暂无解析

  • 第21题：

    单选题
    You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files？（）
    A

     Oracle Enterprise Manager

    B

     The V$LOG view

    C

     The V$LOGFILE view

    D

     The V$FLASHBACK_DATABASE_LOGS view


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    You are maintaining the SALES database. You have added a new disk to a disk group. Automatic StorageManagement performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?（）
    A

    ASM_POWER_LIMIT

    B

    ASM_DISKSTRING

    C

    ASM_DISKGROUPS

    D

    INSTANCE_TYPE


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）
    A

     V$FLASHBACK_DATABASE_LOG

    B

     V$FLASHBACK_DATABASE_STAT

    C

     V$DATABASE

    D

     V$UNDOSTAT


    正确答案： B
    解析： 暂无解析

相关内容