itgle.com

单选题Which of the following is a feature of a unit of work?()A It applies to a single data server.B It is a recoverable sequence of operations.C Its value can be queried from the system catalog tables.D It begins when the application connects to the data se

题目
单选题
Which of the following is a feature of a unit of work?()
A

It applies to a single data server.

B

It is a recoverable sequence of operations.

C

Its value can be queried from the system catalog tables.

D

It begins when the application connects to the data server.


相似考题
参考答案和解析
正确答案: A
解析: 暂无解析
更多“单选题Which of the following is a feature of a unit of work?()A It applies to a single data server.B It is a recoverable sequence of operations.C Its value can be queried from the system catalog tables.D It begins when the application connects to the data se”相关问题
  • 第1题:

    Which of the following is the main feature of an OLTP application?()

    • A、Summarized queries
    • B、Granular transactions
    • C、Voluminous historical data
    • D、Heterogeneous data sources

    正确答案:B

  • 第2题:

    When executing the massload command to load catalog data into a WebSphere Commerce database on a remote DB2 server,which of the following can be used as valid values for the -method command line parameter?()

    • A、create
    • B、import
    • C、load
    • D、sqlimport
    • E、update

    正确答案:B,D

  • 第3题:

    Which of the following is a feature of a unit of work?()

    • A、It applies to a single data server.
    • B、It is a recoverable sequence of operations.
    • C、Its value can be queried from the system catalog tables.
    • D、It begins when the application connects to the data server.

    正确答案:B

  • 第4题:

    Which two statements about subqueries are true?()

    • A、A single row subquery can retrieve data from only one table.
    • B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
    • C、A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.
    • D、A single row subquery can retrieve data from more than one table.
    • E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
    • F、A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.

    正确答案:B,D

  • 第5题:

    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

  • 第6题:

    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A vendor company’s application is utilized, and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor, and the new OLE DB driver will be utilized when the application database is queried. According the company requirements, the connections between the SQL Server database and the application database is prohibited, except when this data is queried. You should think out a method to have data queried from the application database.  Which action should be performed to achieve the goal?()

    • A、To achieve the goal, a Linked Server connection should be configured to the application database.
    • B、To achieve the goal, a query should be written, and an OPENQUERY command is utilized by the query.
    • C、To achieve the goal, a Remote Server connection to the application database should be configured.
    • D、To achieve the goal, a query should be written, and an OPENDATASOURCE command is utilized by the query.

    正确答案:D

  • 第7题:

    单选题
    Which is a license scope option when managing activations for an IBM System Storage DS8100using the IBM Disk Storage Feature Activation (DSFA) application?()
    A

    Operating environment

    B

    Parallel access volumes

    C

    Point-in-time copy

    D

    Count Key Data


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

  • 第8题:

    单选题
    Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?()
    A

    After a ROLLBACK is issued

    B

    After the sequence is altered

    C

    After the sequence is dropped

    D

    After the current session ends


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

  • 第9题:

    单选题
    For the following attempts, which one is to ensure that no one employee becomes a pervasive securitythreat, that data can be recovered from backups, and that information system changes do not compromisea system’s security?()
    A

    Strategic security planning

    B

    Disaster recovery

    C

    Implementation security

    D

    Operations security


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

  • 第10题:

    多选题
    When executing the massload command to load catalog data into a WebSphere Commerce database on a remote DB2 server,which of the following can be used as valid values for the -method command line parameter?()
    A

    create

    B

    import

    C

    load

    D

    sqlimport

    E

    update


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

  • 第11题:

    单选题
    Which of the following is the BEST sequence to bare metal restore a server?()
    A

    Determine backups available, restore backups, and verify data.

    B

    Restore applications, restore data, and verify data.

    C

    Restore OS, restore system applications, and restore data.

    D

    Contact end users of outage, restore backup data, and verify data.


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

  • 第12题:

    单选题
    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A vendor company’s application is utilized, and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor, and the new OLE DB driver will be utilized when the application database is queried. According the company requirements, the connections between the SQL Server database and the application database is prohibited, except when this data is queried. You should think out a method to have data queried from the application database.  Which action should be performed to achieve the goal?()
    A

    To achieve the goal, a Linked Server connection should be configured to the application database.

    B

    To achieve the goal, a query should be written, and an OPENQUERY command is utilized by the query.

    C

    To achieve the goal, a Remote Server connection to the application database should be configured.

    D

    To achieve the goal, a query should be written, and an OPENDATASOURCE command is utilized by the query.


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

  • 第13题:

    What does it mean for a variable in the Application Editor to be defined as a parameter?()

    • A、The variable can be used to pass data to and from subflows.  
    • B、The value for that variable can be supplied via Application Configuration in Application Administration.  
    • C、The value for that variable is defined by the calling application.  
    • D、The variable can be used in conditional steps.  
    • E、The variable can be used to pass data to and from VoiceXML applications.

    正确答案:B

  • 第14题:

    Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?()

    • A、After a ROLLBACK is issued
    • B、After the sequence is altered
    • C、After the sequence is dropped
    • D、After the current session ends

    正确答案:A

  • 第15题:

    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

  • 第16题:

    Which two requirements would lead towards a high availability solution?()

    • A、When uptime is critical
    • B、When data must be refactored
    • C、When application concurrency is static
    • D、When data loss is unacceptable
    • E、When application is a single point of failure

    正确答案:A,D

  • 第17题:

    Your data recovery strategy must meet the following requirements: Back up all data files and folders in C:///Data.  Restore individual files and folders in C:///Data.  Ensure that data is backed up to and restored from external media.  What should you do?()

    • A、Use the Previous Versions feature to restore the files and folders.
    • B、Use the System Restore feature to perform backup and restore operations.
    • C、Use the NTBackup utility to back up and restore individual files and folders.
    • D、Use the Backup and Restore Center to back up and restore files.

    正确答案:D

  • 第18题:

    Which two statements are true regarding single row functions?()

    • A、They accept only a single argument 
    • B、They can be nested only to two levels 
    • C、Arguments can only be column values or constants 
    • D、They always return a single result row for every row of a queried table 
    • E、They can return a data type value different from the one that is referenced

    正确答案:D,E

  • 第19题:

    单选题
    Which of the following is the main feature of an OLTP application?()
    A

    Summarized queries

    B

    Granular transactions

    C

    Voluminous historical data

    D

    Heterogeneous data sources


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

  • 第20题:

    单选题
    You are operating your database in NOARCHIVELOG mode. Your most recent backup includes a copy of all of the data files and the control files taken when the current log sequence number was 45. You experience disk failure on the drive on which your SYSTEM tablespace data files are stored. At the time of the failure, the current log sequence number is 98. Which files should you restore to recover from the loss of the SYSTEM tablespace data files?()
    A

    Only the data files.

    B

    All of the data files and the control files.

    C

    Only the data files belonging to the SYSTEM tablespace.

    D

    Only the data files belonging to the SYSTEM tablespace and the control files.


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

  • 第21题:

    多选题
    Which two statements about subqueries are true? ()
    A

    A single row subquery can retrieve data from only one table.

    B

    A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.

    C

    A SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.

    D

    A single row subquery can retrieve data from more than one table.

    E

    A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.

    F

    A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.


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

  • 第22题:

    单选题
    What does it mean for a variable in the Application Editor to be defined as a parameter?()
    A

    The variable can be used to pass data to and from subflows.  

    B

    The value for that variable can be supplied via Application Configuration in Application Administration.  

    C

    The value for that variable is defined by the calling application.  

    D

    The variable can be used in conditional steps.  

    E

    The variable can be used to pass data to and from VoiceXML applications.


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

  • 第23题:

    单选题
    Which of the following is the BEST sequence to bare metal restore a server?()
    A

     Determine backups available, restore backups, and verify data.

    B

     Restore applications, restore data, and verify data.

    C

     Restore OS, restore system applications, and restore data.

    D

     Contact end users of outage, restore backup data, and verify data.


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

  • 第24题:

    单选题
    Which of the following is a feature of a unit of work?()
    A

    It applies to a single data server.

    B

    It is a recoverable sequence of operations.

    C

    Its value can be queried from the system catalog tables.

    D

    It begins when the application connects to the data server.


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