违法和不良信息举报 联系客服
免费注册 登录

A database administrator wants to design a multi-partition database that can take advantage of both intra-partition parallelism and inter-partition parallelism. Which configuration will allow the use of these types of parallelism while using the least num

题目

A database administrator wants to design a multi-partition database that can take advantage of both intra-partition parallelism and inter-partition parallelism. Which configuration will allow the use of these types of parallelism while using the least number of hardware components (servers, processors)? （）

  • A、one server having at least two processors  
  • B、two servers having one processor and one logical database partition  
  • C、one server having four processors and two logical database partitions  
  • D、two servers each having four processors and two logical database partitions
参考答案和解析
正确答案:C
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

The administrator wants to verify the current state of the OSPF database loading process. Which show command should the administrator use?()

A. show ip ospf [process - id] interface

B. show ip ospf neighbor

C. show ip ospf [process - id]

D. show ip ospf [process - id area - id] database


参考答案：B

第2题：

You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? （）

  • A、Clone 
  • B、Copy 
  • C、Template 
  • D、Terminal 

正确答案:C

第3题：

You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation? ()(Choose two.)

A. Backup compression should be enabled

B. Parallelism for the channel should be set to 2

C. All the files must be backed up as backup sets

D. The backup may be stored either on disk or on media with media manager


参考答案：C, D

第4题：

In which two environments would intra-partition parallelism be used? （）

  • A、Single database partition, single processor  
  • B、Single database partition, multiple processors  
  • C、Multiple database partitions, single processor  
  • D、Multiple database partitions, multiple processors

正确答案:B,D

第5题：

A staff member reports that they cannot access the shared folder on the network； however， other staff members are reporting that they can access the shared folder. Which of the following is the BEST way to identify the problem？（）

  • A、The administrator should monitor all traffic between the staff member and the server.
  • B、The administrator should reconfigure the RAID configuration to allow more space.
  • C、The administrator should map a drive using the net use command.
  • D、The administrator should allow the staff member to use a USB drive.

正确答案:C

第6题：

The administrator wants to verify the current state of the OSPF database loading process. Which show command should the administrator use?（）

  • A、show ip ospf [process - id] interface
  • B、show ip ospf neighbor
  • C、show ip ospf [process - id]
  • D、show ip ospf [process - id area - id] database

正确答案:B

第7题：

An administrator has added a new device to a system and wants to determine if it has been correctly added to the ODM database. Which command would the system administrator use？（）

  • A、odmget
  • B、odmadd
  • C、odmshow
  • D、odmcreate

正确答案:A

第8题：

You are the administrator of three SQL Server 2000 computers at Five Lakes Publishing. One server, FLPSQL01, stores order data. You want to be able to use the other two servers, FLPSQL02 and FLPSQL03, to answer queries and run report. The planned network configuration is shown in the exhibit.

You want to use the database Maintenance Plan wizard to configure log shipping from FLPSQL01 to FLPSQL02 and FLPSQL03. You do not want users to add any new data on FLPSQL02 and FLPSQL03, but they must be able to run queries and reports.

Which two actions should you take? (Each correct answer presents part of the solution. Choose two)

A．Set the database load state for each destination server to No recovery mode.

B．Set the database load state for each destination server to standby mode.

C．Enable the allow database to assume primary role option for both destination servers.

D．Enable the allow database to assume primary role option for one destination server and then disable this option for other destination server.

E．Disable the allow database to assume primary role option for both destination servers.


正确答案：BE
解析：Explanation:B:Astandbyservercanbemaintainedtotaketheplaceoftheprimaryproductionserver,ifneeded.AstandbyserverisasecondarySQLServerinstallationthatiskeptup-to-datewithaprimarySQLServerinstallationthroughtheapplicationoftransactionlogbackupfiles.Youcanautomatetheprocessofmaintainingastandbyserverbycreatingbackup,copy,andrestorejobsthatareperiodicallyexecutedbySQLServerAgentontheprimaryserverandonthestandbyserver.Thisautomatedprocessiscalledlogshipping.Ifyouwantthedestinationdatabasetobeviewableforread-onlyqueries,youmustselecttheStandbyModeoption,thedefaultistheNoRecoveryModeoption.TheStandbymodespecifiesthatthesecondarydatabasebemadeavailableforuse,butinread-onlymode.E:Wedon'twantuserstoaddanydataonFLPSQL02orFLPSQL03.Thereforeweshoulddisabletheallowdatabasetoassumeprimaryroleoptionforthem.IfthisoptionwereenabledFLPSQL02andFLPSQL03wouldbeabletobeusedassourceservers.IncorrectAnswers:A:Thenorecoverymodespecifiesthatthesecondarydatabasebemadeunavailableforuse.WeneedstandbymodesincewewantFLPSQL02andFLPSQL03usedforqueriesandreports.Note:TheactiveportionofthetransactionlogontheprimaryservercanbebackedupusingtheNORECOVERYbackupoption.Thisoptionleavestheprimarydatabaseinrecoverymode.Whentheprimaryserverisreadytobebroughtbackonline,thetransactionlogsfromthestandbyserver(fortheperiodthatuserswereusingthestandbyserverastheprimaryserver)canbeappliedtotheprimaryserver.Thisavoidsthenecessityofapplyingacompletedatabasebackupandallapplicabletransactionlogstorestoretheprimaryserver.Theresultisasignificantdecreaseinthetimerequiredtobringtheprimaryserverbackonline.C:Theprimaryroleoptionmustbedisabledforbothdestinationservers.Ifnottheywouldbeabletochangeandupdatedata.D:Theprimaryroleoptionmustbedisabledforbothdestinationservers.Ifnottheywouldbeabletochangeandupdatedata.

第9题：

An administrator has made several topology and resource group changes on one node in a running cluster.During verification and synchronization， using the "Emulate" option， many errors are reported. Theadministrator decided the best course of action was to roll back the changes. Prior to the changes beingmade， a cluster snapshot was taken. Which of the following actions will roll back the changes with the least disruption？（）

  • A、Perform a synchronization from a node without the changes.
  • B、Apply the cluster snapshot on both nodes while the cluster is running.
  • C、"Restore HACMP Configuration Database from Active Configuration" on the node where the changes weremade
  • D、Stop the cluster using the option "Unmanage Resource Groups" and apply the cluster snapshot on thenode where the changes were made

正确答案:C

第10题：

You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51）  ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following：  The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file and all the archived logs are accessible.  Which option would you choose？（）

  • A、 flash back the corrupted blocks
  • B、 use the DBMS_REPAIR package
  • C、 use the RMAN TSPITR command
  • D、 use the RMAN BLOCKRECOVER command
  • E、 use the RESTORE DATABASE and RECOVER DATABASE commands
  • F、 investigate the time at which the corruption occurred and perform a point-in-time recovery

正确答案:D

更多相关问题
相关内容