可学答题网 > 问答 > 1Z0-060题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You want to capture column group usag


You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema. Examine the following steps: 1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM dual statement. 2. Execute the DBMS_STATS.SEED_COL_USAGE (null, ‘SH’, 500) procedure. 3. Execute the required queries on the CUSTOMERS table. 4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement. Identify the correct sequence of steps.()

  • A3,2,1,4
  • B2,3,4,1
  • C4,1,3,2
  • D3,2,4,1
参考答案
参考解析:
分类:1Z0-060题库
相关推荐

1、You want to implemen

You want to implement the backup and recovery strategy in your database using Recovery&...

2、You want to create&#

You want to create a shortcut to a folder named Project on a network share.&#8194...

3、You want to rebuild&

You want to rebuild a free list in the free lists of the EMPLOYEE table in&...

4、You want to disable&

You want to disable resumable space allocation for all sessions.Which value should be a...

5、You want to create&#

You want to create an RMAN recovery catalog in the RC01 database to help you&#819...

6、You want to prevent&

You want to prevent a Windows 2000 Professional computer named Payroll5 from communicating&#8...