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、 ONLINEB、 REVERSEC、 PARALLELD、 COMPRESSE、 NOLOGGINGF、 COMPUTE STATISTICS
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
相关考题：
If you are traveling in Australia. take _________of the duty-free goods availableat our store in the Sydney Airport.A． holdB． advantageC． noticeD． account
How did the host find out there was a thief in the house?A. He heard someone breathing.B. He heard footsteps in the hall.C. He noticed a shadow on the floor.D. He noticed that his gifts were gone.
I (give advice) to you to go to the Town Hall and ask them for the information about it.选择能代替括号里的选项A、announceB、adviseC、noticeD、advertise
Ezonexam users have noticed extremely slow network performance, intermittent connectivity, and connection losses. After entering the "show interfaces" command, you notice that the Ethernet interface is configured as 100 Mbps full-duplex and that there is evidence of late collisions. What could be the cause of this problem?A. Duplex mismatchB. A routing loopC. Trunking mode mismatchD. Improperly configured root bridgeE. Improperly configured static VLANF. None of the above
You work as a network engineer at TestKing.com. TestKing users have noticed extremely slow network performance, intermittent connectivity, and connection loss. After entering the show interfaces command, you notice that the Ethernet interface is configured as 100 Mbps full-duplex and that there is evidence of late collisions. What could be the cause of this problem?（）A. duplex mismatchB. a routing loopC. trunking mode mismatchD. improperly configured root bridgeE. improperly configured static VLAN
You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）A、 recycle buffer cacheB、 large poolC、 streams poolD、 keep buffer cacheE、 redo log buffer
Examine the parameter for your database instance: You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan: Identify the reason why the optimizer chose different execution plans.（）A、The optimizer used a dynamic plan for the query.B、The optimizer chose different plans because automatic dynamic sampling was enabled.C、The optimizer used re-optimization cardinality feedback for the query.D、The optimizer chose different plan because extended statistics were created for the columns used.
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、ONLINEB、REVERSEC、PARALLELD、COMPRESSE、NOLOGGINGF、COMPUTE STATISTICS
You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery. Which datafiles will you recover？（）A、 all the datafiles in the databaseB、 the datafiles associated with the SYSTEM tablespaceC、 the datafiles associated with the DATA1 tablespaceD、 all the datafiles in the database except those associated with the DATA1 tablespace
TS1 is a server running Windows Server 2008 and Terminal Services. Users in your organization connectto the server TS1 to run a line-of-business application. Recently， you have noticed that user profiles arethreatening to consume the total disk capacity on TS1. You want users to be able to save their own data，but you also want to prevent profiles from exhausting the total storage capacity of the disk on TS1. Whatshould you do？（）A、Use Group Policy to assign mandatory profiles to users who connect to TS1.B、Configure disk quotas for the disk on TS1 on which user profiles are stored.C、Use Group Policy to assign Terminal Services roaming user profiles to users who connect to TS1.D、Configure disk quotas for the local disk of each user who connects to TS1.
You work as an Exchange Administrator for Xxx .The company has a Windows 2008 Active Directorybased network.You have just finished deploying an Exchange 2010 server and migrating all mailboxes including resource mailboxes from Exchange Server 2003. After the migration from the Exchange 2003 server was complete， you noticed that the resource mailboxes were showing up as a shared mailbox and not a resource mailbox.You realize that you need to convert them to Exchange 2010 resource mailboxes.While logged into the Exchange Management Console， you do not see any option to convert a mailbox. What should you use to convert this Exchange 2010 shared mailbox to an Exchange 2010 resource mailbox？（）A、Exchange Troubleshooting AssistantB、Exchange System ManagerC、Exchange Management ShellD、Command prompt
单选题The IT department requested a report to list each server name and the name of each department that utilizes resources from each server. You create a tabular layout that breaks on the server name. You ran the report and noticed that the department field is too large for most of the department names. Which field size setting would you use to allow the field to be smaller but not larger than the field layout size?（）AFixed BExpand CContract DVariable
单选题You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）A recycle buffer cacheB large poolC streams poolD keep buffer cacheE redo log buffer
多选题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
单选题In your production database， data manipulation language （DML） operations are executed on the SALES table.You have noticed some dubious values in the SALES table during the last few days. You are able to track users， actions taken， and the time of the action for this particular period but the changes in data are not tracked.You decide to keep track of both the old data and new data in the table along with the user information. Whataction would you take to achieve this task（）AApply fine-grained auditing.BImplement value-based auditing.CImpose standard database auditing to audit object privileges.DImpose standard database auditing to audit SQL statements.
单选题Examine the parameter for your database instance: You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan: Identify the reason why the optimizer chose different execution plans.（）AThe optimizer used a dynamic plan for the query.BThe optimizer chose different plans because automatic dynamic sampling was enabled.CThe optimizer used re-optimization cardinality feedback for the query.DThe optimizer chose different plan because extended statistics were created for the columns used.
单选题You work as a network engineer at TestKing.com. TestKing users have noticed extremely slow network performance, intermittent connectivity, and connection loss. After entering the show interfaces command, you notice that the Ethernet interface is configured as 100 Mbps full-duplex and that there is evidence of late collisions. What could be the cause of this problem?（）Aduplex mismatchBa routing loopCtrunking mode mismatchDimproperly configured root bridgeEimproperly configured static VLAN
多选题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 a systems administrator responsible for configuring a Windows Server 2008 SMTP server. Yourorganization is currently using the default SMTP virtual server for sending order notifications from a single Web application called ContosoOrderManagement. Recently， you have noticed that a largenumber of messages have been sent to the SMTP virtual server from other computers and users. Which two methods can you use to prevent unauthorized access to the SMTP server？（）AEnable Basic Authentication.BConfigure a smart host for use by the SMTP virtual server.CAdd Connection Control entries to limit which IP addresses can use the SMTP server.DModify settings on the Security tab of the properties of the SMTP virtual server.
单选题A: I noticed a copy of Scientific American on your desk. May I borrow it? B: ______AYes, you can.BYes, you could.CYes, go on.DYes, help yourself.
单选题You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery. Which datafiles will you recover？（）A all the datafiles in the databaseB the datafiles associated with the SYSTEM tablespaceC the datafiles associated with the DATA1 tablespaceD all the datafiles in the database except those associated with the DATA1 tablespace