单选题Examine the command： SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）A Automatic statistics collection is stopped for the CUSTOMERS table.B Statistics for the CUSTOMERS

题目

单选题

Examine the command： SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）

Automatic statistics collection is stopped for the CUSTOMERS table.

Statistics for the CUSTOMERS table are locked and cannot be overwritten.

Existing statistics for the CUSTOMERS table become unusable for the query optimizer.

Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.

参考答案和解析

正确答案： B

解析：暂无解析

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

相似问题和答案

第1题：

Examine the following command that is executed for the TRANSPORT table in the SH schema:Which statement describes the significance of this command?()

A. It collects statistics into the pending area in the data dictionary

B. It creates a virtual hidden column in the CUSTOMERS_OBE table

C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT

D. It creates a histogram to hold skewed information about the data in the columns

参考答案：B

第2题：

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()

参考答案：C

第3题：

View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?()

A. Accept the recommended SQL profile.

B.Collect statistics for the related objects.

C. Run the Access Advisor for the SQL statement.

D. Run the Segment Advisor for recommendations.

参考答案：C

第4题：

After adding a new Ethernet card to a system and rebooting， the system administrator notices the card was not configured. How can the system administrator determine if there were errors during the configuration process for the card？（）

A、Examine the bootlog with the command： alog -o -f /var/adm/ras/bootlog
B、Display the device attributes and errors with the command： lsdev -C -l ent0
C、Examine the AIX errlog for configuration method errors with the command： errpt -a -C ent0
D、Examine the ODM for configuration errors with the command： odmget -q "method_errors" ent0

正确答案:A

第5题：

Command对象可以执行SQL语句。

正确答案:正确

第6题：

Examine the structure of the STUDENTS table:You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.Which SQL statement accomplishes this task?（）

参考答案：D

第7题：

Examine this command:SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’);Which three statements are true about the effect of this command?()

A. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.

B. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.

C. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.

D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.

E. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

参考答案：A, C, D

第8题：

Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL> PURGE TABLE sales_tab;What would be the outcome of this command?（）

A. All three tables in the recycle bin are purged

B. Only the table with the oldest DROPSCN is purged

C. The command returns an error because multiple entries with the same name exist in the recycle bin

D. Only the table with the latest DROPSCN is purged

参考答案：B

第9题：

Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）

A、A CHECK constraint is created on the OID column.
B、A NOT NULL constraint is created on the OID column.
C、The ORDERS table is the only object created in the USERS tablespace.
D、The ORDERS table and a unique index are created in the USERS tablespace.
E、The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.

正确答案:B,D

第10题：

A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design Advisor so that it will evaluate the information stored in the file and give advice on re-partitioning?（）

A、db2advis -d proddb -i workload.sql -P
B、db2advis -d proddb -i workload.sql -partitioning
C、db2advis -d proddb -i workload.sql -m P
D、db2advis -d proddb -i workload.sql -m ALL

正确答案:C

Examine the command： SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’，

题目

参考答案和解析

相似问题和答案

更多相关问题

相关内容