You are configuring your index to be stored in a tablespace.

题目
单选题
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题:

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?()

  • A、ONLINE
  • B、REVERSE
  • C、PARALLEL
  • D、COMPRESS
  • E、NOLOGGING
  • F、COMPUTE STATISTICS

正确答案:C,E

第2题:

You lost the index tablespace in your database. You decided to re/x7fcreate the index tablespace and the indexes in the tablespace.  What methods can you use to re/x7fcreate the indexes?()

  • A、Data Pump
  • B、SQL scripts
  • C、SQL*Loader
  • D、Flashback database
  • E、Recovery Manager (RMAN) script

正确答案:A,B

第3题:

You are an administrator of a switched network and your goal is to reduce some of the administrative overhead on your network. You plan on achieving this by configuring a new VLAN for each department in your network. However, you need to share the VLAN information across numerous switches throughout your network. Which of the following would allow you accomplish this?()

  • A、STP
  • B、GVRP
  • C、SNMP
  • D、VTP
  • E、DHCP

正确答案:D

第4题:

You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace?()

  • A、 by using the Flashback Database feature
  • B、 by using RMAN incomplete recovery
  • C、 by performing a user-managed incomplete recovery
  • D、 by dropping and re-creating the index tablespace

正确答案:D

第5题:

The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use?() 

  • A、the DBNEWID utility
  • B、the ANALYZE command
  • C、the RMAN LIST command
  • D、the RMAN REPORT command
  • E、the RMAN CROSSCHECK command
  • F、the RMAN BLOCKRECOVER command

正确答案:B

第6题:

You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes?()

  • A、 SQL scripts
  • B、 Recovery Manager (RMAN) script
  • C、 Data Pump
  • D、 SQL*Loader
  • E、 Flashback database

正确答案:A,C

第7题:

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?()

  • A、 ONLINE
  • B、 REVERSE
  • C、 PARALLEL
  • D、 COMPRESS
  • E、 NOLOGGING
  • F、 COMPUTE STATISTICS

正确答案:C,E

第8题:

At database startup, you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes?()

  • A、 Start the database in OPEN mode, and create a new index tablespace.
  • B、 Start the database in OPEN mode, and drop the lost index tablespace from the database.
  • C、Start the database in MOUNT mode, create a new index tablespace, and drop the lost index tablespace from the database.
  • D、 Start the database in MOUNT mode, drop the lost index tablespace from the database, open the database, and create a new index tablespace.

正确答案:D

第9题:

You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this?()

  • A、 The index tablespace contains bitmap indexes.
  • B、 The index tablespace contains more than one data file.
  • C、 The index tablespace supports only complete recovery.
  • D、 The index tablespace is not a dictionary-managed tablespace.
  • E、 There is a dependency relationship between a table and its indexes.

正确答案:E

第10题:

You work as the IT professional in an international company which is named Wiikigo. You are experiencedin implementing and administering a network operating system. You are specialized in deploying servers,configuring Windows Server 2008 Terminal services and network application services,and configuring aweb services infrastructure. You have the Windows Deployment Services (WDS) role installed on a serverthat runs Windows Server 2008. You plan to install Windows Vista on a computer that does not supportPreboot Execution Environment (PXE). You have a Windows Vista image that is stored on the WDS server. You have to start the computer and install the image that is stored on the WDS server. What should you create?()

  • A、You should create a discover image
  • B、You should create an install image
  • C、You should create a capture image
  • D、You should create a CD-ROM that contains PXE drivers

正确答案:A

更多相关问题