Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recover strategy available in Oracle9i？（）A、Rebuild the index using the online option. B、Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. C、Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. D、Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.
Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recover strategy available in Oracle9i？（）
- A、Rebuild the index using the online option.
- B、Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again.
- C、Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks.
- D、Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.
相关考题：
They were afraid to complain about the noise lest they ________ the people next door. A.would annoyB.annoyC.might annoyD.annoyed
In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?（）A. It collects data from SGA and compares it with a preserved snapshot.B. It collects data from SGA, analyzes it, and provides a report.C. It collects data from SGA and compares it with the latest snapshot.D. It collects data from both SGA and PGA, analyzes it, and provides a report
Some passengers complain that it usually takes so long to ( ) in travel insurance documents.A.finishB.fillC.completeD.write
The drivers complain that the road sign is not easy to read;therefore,they suggest the words on it be made to stand out.A:stick out B:unusual C:undamaged D:unstable
How many users are supported on the Cisco Unified Communications models 540 and 560 platforms？（）A、 16 users on the UC540 and 64 users on the UC560B、 32 users on the UC540 and 64 users on the UC560C、 32 users on the UC540 and 104 users on the UC560D、 16 users on the UC540 and 104 users on the UC560
在缺省配置下，普通用户登录到Windows 2000 Professional中和Windows 2000 Server中后分别所在的组为（）A、Users，UsersB、Power Users，Power UsersC、Users，Power UsersD、Power Users，Users
下面哪些可以将john添加到users数组中？（）A、$users[]=‘john’；B、array_add（$users，’john’）；C、array_push（$users，‘john’）；D、$users[“name”]=‘john’；
Users complain they cannot communicate with a server. The system administrator suspects there may be a problem with the Ethernet adapter or with the way it is configured. Which command can be run to verify the adapter is configured correctly？（）A、netstat -inB、ifconfig -aC、arp -aD、cfgmgr
Users complain an AIX server is running slow. Which of the following commands can be run to determine what is consuming systems resources？（）A、 tprofB、 lpstatC、 ps auxD、 entstat
Certkiller .com boosts a main office and 20 branch offices. Configured as a separate site， each branch office has a Read-Only Domain Controller （RODC） server installed. Users in remote offices complain that they are unable to log on to their accounts. What should you do to make sure that the cached credentials for user accounts are only stored in their local branch office RODC server（）A、Open the RODC computer account security tab and set Allow on the Receive as permission only for the users that are unable to log on to their accountsB、Add a password replication policy to the main Domain RODC and add user accounts in the security groupC、Configure a unique security group for each branch office and add user accounts to the respective security group. Add the security groups to the password replication allowed group on the main RODC serverD、Configure and add a separate password replication policy on each RODC computer account
单选题Users complain an AIX server is running slow. Which of the following commands can be run to determine what is consuming systems resources？（）A tprofB lpstatC ps auxD entstat
单选题You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）AIncrease the undo returnBCreate more undo segmentsCCreate another undotablespaceDIncrease the size of the undotablespace
单选题Users in your PROD database complain about the slow response of the transactions. While investigating the reason， you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）Aincrease the undo retentionBcreate more undo segmentsCcreate another undo tablespaceDincrease the size of the undo tablespace
单选题A system administrator periodically receives calls from users who complain about poor performance with their application. Use the following sar command output to answer the question： Which of the following system resources need more investigation？（）A CPUsB DiskC MemoryD NetworkX
单选题You work as a database administrator for Supportcenter.cn. Users in the Supportcenter.cn PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）AIncrease the undo returnBCreate more undo segmentsCCreate another undotablespaceDIncrease the size of the undo tablespace
单选题In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation. How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?（）AIt collects data from SGA and compares it with a preserved snapshot.BIt collects data from SGA, analyzes it, and provides a report.CIt collects data from SGA and compares it with the latest snapshot.DIt collects data from both SGA and PGA, analyzes it, and provides a report
单选题Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users’queries. Which component of the Oracle Instance would you change to improve performance？（）AJava poolBLarge poolCShared poolDStreams poolELibrary cacheFRedo log bufferGData dictionary cacheHDatabase buffer cache
多选题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.
单选题TS3 is a server running Windows Server 2008 and Terminal Services. You have the responsibility ofsupporting users who connect to TS3 to run various applications. Users complain that the application is responding slowly. You use the quser command on TS3 and discover that many users havemultiple disconnected sessions on the server with idle times of two days or more. You want to reduce thestrain on the TS3 by eliminating disconnected sessions that have been idle for more than two days. What should you do？（）AUse the Rwinsta command.BUse the Tsdicon command.CUse the Tskill command.DUse the Tscon command.
单选题An administrator is in charge of several remote servers in Japan. Users call and complain they cannot connect to the company’s resources located on those servers. Which of the following commands would allow the administrator to verify the servers are running？（）ApingBnetstatCnbtstatDtelnet
单选题You work as a database administrator for Supportcenter.cn. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）AThe trace fileBThe fixed viewsCThe data dictionary viewsDThe operating system log fieldsEThe dynamic performance views.
单选题How many users are supported on the Cisco Unified Communications models 540 and 560 platforms？（）A 16 users on the UC540 and 64 users on the UC560B 32 users on the UC540 and 64 users on the UC560C 32 users on the UC540 and 104 users on the UC560D 16 users on the UC540 and 104 users on the UC560
多选题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 indexBcoalesce the ORDERS_IND indexCcoalesce the INDEXES tablespaceDdrop and re-create the ORDERS tableErebuild the index online and move it to another tablespace
单选题The main idea of Paragraph Three is that ______.Amost people feel life is easyBthe writer feels life is easyCthe writer likes to complain about his problemsDmost people complain about how hard their lives are
多选题下面哪些可以将john添加到users数组中？（）A$users[]=‘john’；Barray_add（$users，’john’）；Carray_push（$users，‘john’）；D$users[“name”]=‘john’；