当前位置:1z0-043题库

问题:

[单选] You are a DBA of your company. You created a database named SALES on an Oracle 10g instance. You have defined an index named INDEX1 on the database table named INVENTORY. Users are complaining that queries accessing the INVENTORY table are running slow. Upon investigation you determine that the tablespace where the index is located is experiencing high I/O and you decide to relocate the index to another tablespace. Which of these will be the best way to accomplish this objective?()

A .  Rebuild the index.
B .  Coalesce the index.
C .  Drop and re-create the index in the new tablespace.
D .  Relocate the index using the ALTER INDEX...MOVE statement.

Examine the following commands executed in your database: SQL> ALTER SESSION RECYCLEBIN=ON; Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees;  Table created.  Further, you executed the following command to drop the table:  SQL> DROP TABLE emp;Table dropped.  What happens in this scenario?() The table is moved to the SYSAUX tablespace.。 The table is moved to the SYSTEM tablespace.。 The table is removed from the database permanently.。 The table is renamed and remains in the TBSFD tablespace.。 最小后悔值决策方法中的后悔值就是机会损失值. A customer is planning to buy a two enclosure Power 770, and will implement 4 LPARs with the following requirements:Each LPAR must have a private, dedicated connection to the network.The adapter for this network connection must be hot-swappable.The customer wants to minimize the number of I/O slots used. Which of the following fulfills the customer requirements?() Two dual-port PCIe adapters。 A four-port PCIe Ethernet adapter。 Four separate PCIe Ethernet adapters。 Two embedded Integrated Virtual Ethernet adapters (IVE)。 抵抗不良环境最强的微生物是()。 Which two capabilities are granted with the SUPER privilege?() Allowing a client to kill other client connections。 Allowing a client to shut down the server。 Allowing change of the server runtime configuration。 Allowing client accounts to take over the account of another user。 You are a DBA of your company. You created a database named SALES on an Oracle 10g instance. You have defined an index named INDEX1 on the database table named INVENTORY. Users are complaining that queries accessing the INVENTORY table are running slow. Upon investigation you determine that the tablespace where the index is located is experiencing high I/O and you decide to relocate the index to another tablespace. Which of these will be the best way to accomplish this objective?()
参考答案:

  参考解析

本题暂无解析

在线 客服