题目内容

Which three functions are performed by the SQL Tuning Advisor？（）

A. Building the SQL profile
B. Recommending optimization of materialized views
Checking query objects for missing and stale statistics
D. Recommending bitmap， function-based， and B-tree indexes
E. Recommending restructuring SQL queries that are using bad plans

查看答案

搜索结果不匹配？点我反馈

更多问题

YouareworkingonaCATDBdatabasethatcontainsanOracleDatabaseversion11.1catalogschemaownedbytheuserRCO11.TheINST1databasecontainsanOracleDatabaseversion10.1catalogschemaownedbytheuserRCAT10. YouwanttheRMANtoimportmetadatafordatabaseIDs1423241and1423242,registeredinRCAT10,intotherecoverycatalogownedbyRCO11.Youalsowanttoderegisterthemfromthecatalogafterimport. Youexecutedthefollowingcommandstoachievethis: WhathappensiftheRCO11cataloghasscriptswiththesamenameasthatofthescriptsinRCAT10catalog?（）

A. ThescriptsintheRCO11catalogareoverwritten.
B. RMANrenamesthelocalstoredscriptsintheRCO11catalog.
C. TheRMANsessioninwhichthecommandisexecutedaborts.
D. RMANrenamestheglobalscriptsthatareimportedfromtheRCAT10catalog.

查看答案

Companycom will be using the Virtual IO Server to share both FC and Ethernet adapters among multiple LPARs. The customer is using mostly web services in the LPARs. Which of the following should be considered?（）

A. Shared Ethernet Adapters and Virtual SCSI services require separate Virtual IO Servers.
B. Virtualized adapters require essentially the same Virtual IO Server resources regardless of adapter type.
C. Shared Ethernet Adapters require significantly more Virtual IO Server resources than Virtual SCSI services.
D. Virtual SCSI services require significantly more Virtual IO Server resources than Shared Ethernet Adapters.

查看答案

To examine the Exhibit， press the Exhibit button. While a user is compiling a C program， "vmstat 120 10" is run to determine the cause of a performance problem. Given the vmstat output as shown in the exhibit， which of the following conclusions should be drawn about the I/O bottleneck？（）

A. There is a file I/O bottleneck.
B. There are too many open files.
C. There appears to be a buffer shortage.
D. There is a paging space I/O bottleneck.

查看答案

A customer is installing a new x3850 X5 server and has purchased a warranty upgrade on the server to 24 x 7 four hour response. The customer requested IBM help with setting up the RAID adapter. The customer was told IBM would not help them. Which of the following should be verified first？（）

A. The customer used their IBM Customer Number
B. The customer has activated their base warranty
C. The customer purchased Remote Technical Support Servicepac
D. The customer escalated the issue to the Duty Manager

查看答案

Which three functions are performed by the SQL Tuning Advisor？（）

A. Building the SQL profile B. Recommending optimization of materialized views Checking query objects for missing and stale statistics D. Recommending bitmap， function-based， and B-tree indexes E. Recommending restructuring SQL queries that are using bad plans

Companycom will be using the Virtual IO Server to share both FC and Ethernet adapters among multiple LPARs. The customer is using mostly web services in the LPARs. Which of the following should be considered?（）

A customer is installing a new x3850 X5 server and has purchased a warranty upgrade on the server to 24 x 7 four hour response. The customer requested IBM help with setting up the RAID adapter. The customer was told IBM would not help them. Which of the following should be verified first？（）

A. Building the SQL profile
B. Recommending optimization of materialized views
Checking query objects for missing and stale statistics
D. Recommending bitmap， function-based， and B-tree indexes
E. Recommending restructuring SQL queries that are using bad plans