单选题You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?（）A OPTIMAL B INITIAL C PCTINCREASE D NEXT

题目内容(请给出正确答案)

单选题

You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?（）

OPTIMAL

INITIAL

PCTINCREASE

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

更多相关问题

第1题

单选题You are configuring a failover cluster for a database server. You are assigning four nodes to the cluster. Allnodes have access to a SAN，and adequate storage is available. Which of the following options should youchoose for your quorum configuration？（）A Node MajorityB Node And Disk MajorityC Node And File Share MajorityD No Majority： Disk Only

点击查看答案
第2题

多选题Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1： ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）ADrop and re-create the inbox.BCoalesce the ORDERS_IND index.CCoalesce the INDEXES tablespace.DDrop and re-create the ORDERS table.ERebuild the index online and move it to another tablespace.

点击查看答案
第3题

单选题You created the DEPT table by using the following command： CREATE TABLE scott.dept （deptno NUMBER（3）， dname VARCHAR2（15）， loc VARCHAR2（15）） STORAGE （INITIAL 100K NEXT 50K MAXEXTENTS 10 PCTINCREASE 5 FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）AIssue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.BIssue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.CIssue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.DYou cannot shrink the SCOTT.EMP table.

点击查看答案
第4题

单选题You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（）A DBCC DBREINDEXB SELECT * FROM sys.dm_db_index_physical_statsC DBCC INDEXDEFRAGD SELECT * FROM sys.indexes

点击查看答案
第5题

单选题You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?（）A DROP TABLE B ALTER TABLE C RESIZE D COALESCE

点击查看答案
第6题

多选题You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）AONLINEBREVERSECPARALLELDCOMPRESSENOLOGGINGFCOMPUTE STATISTICS

点击查看答案
第7题

多选题You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re/x7fcreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re/x7fcreate the indexes？（）AONLINEBREVERSECPARALLELDCOMPRESSENOLOGGINGFCOMPUTE STATISTICS

点击查看答案

单选题You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?（）A OPTIMAL B INITIAL C PCTINCREASE D NEXT

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容