niusouti.com

多选题In which two environments would intra-partition parallelism be used? ()ASingle database partition, single processorBSingle database partition, multiple processorsCMultiple database partitions, single processorDMultiple database partitions, multiple pro

题目
多选题
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


相似考题
更多“多选题In which two environments would intra-partition parallelism be used? ()ASingle database partition, single processorBSingle database partition, multiple processorsCMultiple database partitions, single processorDMultiple database partitions, multiple pro”相关问题
  • 第1题:

    A technical specialist has a requirement to implement a 4-way POWER5 server with a small Web server partition and a high performance database server partition. The Web server provides a client front-end to the database server. The most important concerns are speed of communication between the Web server and the database and I/O speed of the database. Which of the following virtualization features would be most appropriate?()

    • A、Virtual SCSI
    • B、Virtual Ethernet
    • C、Virtual I/O Server
    • D、Micro-Partitioning

    正确答案:B

  • 第2题:

    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

  • 第3题:

    Company.com has a single pSeries server with two shared processor logical partitions. The first partition has peak resource requirements during weekdays. The second partition has peak resource requirements during weekends. During the peak times, the total workload between the partitions does NOT exceed the capacity of the server. However, the partitions are not able to utilize the full capacity of the system during peak times, because the necessary CPU and memory resources are not always allocated to the busiest partition. Which of the following options would best balance these resources?()

    • A、Configure AIX Workload Manager
    • B、Configure Partition Load Manager
    • C、Configure eServer Workload Manager
    • D、Use DLPAR from the HMC

    正确答案:B

  • 第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题:

    Which two statements are correct regarding IS-IS?()

    • A、Routers maintain a single link-state database per area.
    • B、Routers maintain a separate Level 1 link-state database.
    • C、Routers maintain a separate Level 2 link-state database.
    • D、Routers maintain a single Level 1 link-state database per area.

    正确答案:B,C

  • 第6题:

    Which statements are true about logical structures of the Oracle database()

    • A、Each segment contains one or more extents.
    • B、Multiple tablespaces can share a single data file
    • C、A data block is the smallest unit of input/output (I/O) in data files.
    • D、It is possible to have tablespaces of different block sizes in a database.
    • E、Each data block in the database always corresponds to one operating system block

    正确答案:A,C,D

  • 第7题:

    Which two statements are true regarding listeners()

    • A、Listeners use only the TCP/IP protocol.
    • B、Multiple listener processes can run simultaneously on a host.
    • C、Multiple database instances can be registered with a single listener.
    • D、The listener-related errors can be traced only at the administrative level.
    • E、Only one database instance can be registered with a single listener at any time.

    正确答案:B,C

  • 第8题:

    You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?() 

    • A、Create the database by using a single data file and a single log file.
    • B、Create the database by using a single data file and multiple log files.
    • C、Create the database by using a single log file and multiple filegroups.
    • D、Create the database by using a single log file and a filegroup that has multiple data files.

    正确答案:C

  • 第9题:

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


    正确答案: D
    解析: 暂无解析

  • 第10题:

    多选题
    Your customer wants to build a network for a financial trading floor that has a requirement for multiple high-value transactions, which are also vital to the customer. What are the two most critical requirements? ()(Choose two.)
    A

    no single point of failure

    B

    trading database server location

    C

    redundant application servers location

    D

    deterministic response to all failures

    E

    determine which protocol to use


    正确答案: A,D
    解析: 暂无解析

  • 第11题:

    单选题
    If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? ()
    A

    All existing databases in the instance are expanded to the new database partition but data cannot be stored on the newpartition until it has been added to a partition group.  

    B

    Database partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition.  

    C

    Any single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance.  

    D

    A database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.


    正确答案: D
    解析: 暂无解析

  • 第12题:

    单选题
    The database users are connecting to the PROD database from different applications, thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective? ()
    A

    set the SESSIONS to 1 in the parameter file

    B

    grant SINGLE SESSION privilege to all of the users

    C

    set the SESSIONS_PER_USER to 1 in the users’ profile

    D

    grant RESTRICTED SESSION privilege to all of the database users

    E

    create a role with SINGLE SESSION privilege and assign the role to the users


    正确答案: A
    解析: 暂无解析

  • 第13题:

    A customer has two Power 770 systems with 4 enclosures each.  Thirty two cores and 1TB of memory are activated on each system.  Each system has 3 database partitions and each partition has 10 cores and 300GB of memory.   Which solution will provide automated recovery of unplanned outages at least cost?()

    • A、Purchase PowerVM Enterprise Edition.Use System Director to automate Live Partition Mobility to recover from partition failure
    • B、Create additional shared processor partitions as standby nodes.Use PowerHA SystemMirror to activate and use CoD resources when a failover occurs
    • C、Purchase an additional 32-core Power 750 with PowerHA SystemMirror Standard Edition.Use the new system as standby node with the XD component of PowerHA
    • D、Purchase an additional Power 770 system.Locate production and standby database partitions on each system.Use DB2 pureScale to provide automated partition monitoring and failover

    正确答案:B

  • 第14题:

    The database on a p5-570 Micro-Partition has grown and backups are not meeting the Service Level Agreement. There are several partitions using the Virtual I/O Server to access the storage array. The database backup has high CPU utilization while the others have low CPU utilization. What adjustment can the technical specialist make to ensure that the Service Level Agreement is achieved?()

    • A、Add memory to the database partition to improve response time.
    • B、Add additional Host Bus Adapters to the server to improve IO throughput.
    • C、Modify CPU allocations to favor the database partition.
    • D、Increase CPU allocations to the Virtual I/O Server.

    正确答案:C

  • 第15题:

    A customer would like to consolidate multiple database workloads to a single server to reduce TCO. What is the effect of PowerVM on TCO?()

    • A、Reduces SAN cost
    • B、Reduces network cost
    • C、Reduces administration costs
    • D、Reduces software licensing cost

    正确答案:C

  • 第16题:

    If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? ()

    • A、All existing databases in the instance are expanded to the new database partition but data cannot be stored on the newpartition until it has been added to a partition group.  
    • B、Database partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition.  
    • C、Any single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance.  
    • D、A database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.

    正确答案:A

  • 第17题:

    Which  statements are true regarding listeners()

    • A、Listeners use only the TCP/IP protocol.
    • B、Multiple listener processes can run simultaneously on a host.
    • C、Multiple database instances can be registered with a single listener.
    • D、The listener-related errors can be traced only at the administrative level.
    • E、Only one database instance can be registered with a single listener at any time

    正确答案:B,C

  • 第18题:

    In which situation would you use static database registration for a listener()

    • A、when multiple databases are to be registered with the listener
    • B、when DBAs need to connect remotely to start up the database instance
    • C、when users need to connect the database instance using the host naming method
    • D、when the database instance that is to be registered with the listener is configured in shared server mode

    正确答案:B

  • 第19题:

    Which three statements are true about logical structures of the Oracle database()

    • A、Each segment contains one or more extents.
    • B、Multiple tablespaces can share a single data file.
    • C、A data block is the smallest unit of input/output (I/O) in data files.
    • D、It is possible to have tablespaces of different block sizes in a database.
    • E、Each data block in the database always corresponds to one operating system block.

    正确答案:A,C,D

  • 第20题:

    多选题
    In an environment that includes both a Master Domain Manager (MDM)  and Backup Master Domain Manger (BMDM),  which two options are  appropriate for the location of the database? ()
    A

    local database installed on the MDM only

    B

    live local database installed on the BMDM only

    C

    single database on a clustered machine remote from the MDM and BMDM

    D

    live database installed on a single Fault Tolerant Agent within IBM  Tivoli Workload Scheduler network

    E

    live database on MDM and High Availability Disaster Recovery/Data  Guard standby database on BMDM


    正确答案: A,D
    解析: 暂无解析

  • 第21题:

    多选题
    Which two statements are correct regarding IS-IS?()
    A

    Routers maintain a single link-state database per area.

    B

    Routers maintain a separate Level 1 link-state database.

    C

    Routers maintain a separate Level 2 link-state database.

    D

    Routers maintain a single Level 1 link-state database per area.


    正确答案: C,B
    解析: 暂无解析

  • 第22题:

    单选题
    A cluster administrator decides ti implement application monitoring in order to monitor both a web application and its supporting database. The plan is to use a single resource group prod_rg and to configure one monitor method for the web app and one monitor method for the database.  Which of the following statements best describes the need for custom resource monitor?()
    A

     Multiple application servers must be in a single resource group.

    B

     Multiple application servers per resource group may be monitored.

    C

     Multiple resource groups must each contain a single application server.

    D

     Multiple application servers in a cluster cannot use process monitoring.


    正确答案: A
    解析: 暂无解析

  • 第23题:

    多选题
    Which two statements are correct regarding IS-IS?()
    A

    Routers maintain a single link-state database per area.

    B

    Routers maintain a separate Level 1 link-state database.

    C

    Routers maintain a separate Level 2 link-state database.

    D

    Routers maintain a single Level 1 link-state database across multiple areas.


    正确答案: D,A
    解析: 暂无解析