Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?（）A、CLOBB、BLOBC、HierarchicallyD、Rows and columns

题目

Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?（）

  • A、CLOB
  • B、BLOB
  • C、Hierarchically
  • D、Rows and columns
相似考题

1.YouwanttoaccessemployeedetailscontainedinflatfilesaspartoftheEMPLOYEEtable.YouplantoaddanewcolumntotheEMPLOYEEtabletoachievethis.Whichdatatypewouldyouuseforthenewcolumn()A.CLOBB.BLOBC.BFILED.LONGRAW

2.You completed your workflow definition. You want to save a copy of the definition to the file system for source control purposes. How does Oracle Workflow Builder save that file?()A. as a flat fileB. as a BPEL-compiled definitionC. as an XML file with an associated document type definition (DTD)D. as an XML file without an associated document type definition (DTD)

3.Which of the following DB2 data types has a fixed length?()A.XMLB.BLOBC.DOUBLED.DBCLOB

4.Consider the following:Which statement best describes the meaning of the value for the key_len column?()A.It shows the total size of the index rowB.It shows how many columns in the index are examinedC.It shows the number of characters indexed in the keyD.It shows how many bytes will be used from each index row

更多“Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?（）A、CLOBB、BLOBC、HierarchicallyD、Rows and columns”相关问题

  • 第1题：

    A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?()

    A.Table

    B.Columns

    C.Table and Alias

    D.Columns and Alias


    参考答案：A

  • 第2题：

    Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?()

    A.CLOB

    B.BLOB

    C.Hierarchically

    D.Rows and columns


    参考答案：C

  • 第3题：

    A(n) ______ document is an interlinked system of documents in which a user may iump from one document to another in a nonlinear,associative way．

    A．Hipertext

    B．Web

    C．Html

    D．XML


    正确答案：A
    解析：超文本文档是一种链接的文档系统，用户能够以非线性关联的方式从一个文档跳转到另一个文档。

  • 第4题：

    Which of the following is NOT true about XML columns?（）

    • A、Data can be retrieved by SQL.
    • B、Data can be retrieved by XQuery.
    • C、XML columns must be altered to accommodate additional parent and child relationships.
    • D、Access to any portion of an XML document can be direct, without reading the whole document.

    正确答案:C

  • 第5题：

    在J2EE中，接受一个XML文档，返回document对象，以分析该XML文档，可以使用如下（）方法获得document对象 

    • A、Document doc=DocumentBuilderFactory.parse（“my.xml”）；
    • B、Document doc=DocumentBuilder.parse（“my.xml”）；
    • C、DocumentBuilderFactory dbf= DocumentBuilderFactory.newInstance（）； DocumentBuilder builder=dbf.newDocumentBuilder（）； Document doc=builder.parse（“my.xml”）；
    • D、DocumentBuilder builder=new DocumentBuilder（）； Document doc=builder.parse（“my.xml”）；

    正确答案:C

  • 第6题：

    Which of the following DB2 data types has a fixed length?（）

    • A、XML
    • B、BLOB
    • C、DOUBLE
    • D、DBCLOB

    正确答案:C

  • 第7题：

    A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?（）

    • A、Table
    • B、Columns
    • C、Table and Alias
    • D、Columns and Alias

    正确答案:A

  • 第8题：

    You completed your workflow definition. You want to save a copy of the definition to the file system for source control purposes. How does Oracle Workflow Builder save that file?（）

    • A、as a flat file
    • B、as a BPEL-compiled definition
    • C、as an XML file with an associated document type definition (DTD)
    • D、as an XML file without an associated document type definition (DTD)

    正确答案:A

  • 第9题：

    You create a Web application to process XML documents. The Web application receives XML document files from several sources, reads them, and stores them in a Microsoft SQL Server database. The Web application parses all incoming data files to ensure that they conform to an XML schema. You need to find all validation errors in the XML document. What should you do?（）

    • A、Load the XML data by using an instance of the XmlDocument class and specify a location for the application schema.
    • B、Configure the ValidationEventHandler in the XmlReaderSettings of the XmlReader object.
    • C、Read the XML file into a DataSet object and set the EnforceConstraints property to True.
    • D、Read the XML file into a DataSet object. Handle the DataSet.MergeFailed event to parse the data that does not conform to the XML schema.

    正确答案:B

  • 第10题：

    单选题
    Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?（）
    A

    CLOB

    B

    BLOB

    C

    Hierarchically

    D

    Rows and columns


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

  • 第11题：

    单选题
    在J2EE中，接受一个XML文档，返回document对象，以分析该XML文档，可以使用如下（）方法获得document对象
    A

    Document doc=DocumentBuilderFactory.parse（“my.xml”）；

    B

    Document doc=DocumentBuilder.parse（“my.xml”）；

    C

    DocumentBuilderFactory dbf= DocumentBuilderFactory.newInstance（）； DocumentBuilder builder=dbf.newDocumentBuilder（）； Document doc=builder.parse（“my.xml”）；

    D

    DocumentBuilder builder=new DocumentBuilder（）； Document doc=builder.parse（“my.xml”）；


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

  • 第12题：

    单选题
    Which of the following is NOT true about XML columns?（）
    A

    Data can be retrieved by SQL.

    B

    Data can be retrieved by XQuery.

    C

    XML columns must be altered to accommodate additional parent and child relationships.

    D

    Access to any portion of an XML document can be direct, without reading the whole document.


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

  • 第13题：

    Which of the following is NOT true about XML columns?()

    A.Data can be retrieved by SQL.

    B.Data can be retrieved by XQuery.

    C.XML columns must be altered to accommodate additional parent and child relationships.

    D.Access to any portion of an XML document can be direct, without reading the whole document.


    参考答案：C

  • 第14题：

    Which of the following are all valid DB2 data types?()

    A.LONG VARCHAR, SMALLINT, NUMBER, BLOB

    B.DECIMAL, DATE, DBCLOB, INTERVAL

    C.NUMERIC, TIMESTAMP, BYTE, FLOAT

    D.NUM, TIME, XML, DOUBLE


    参考答案：D

  • 第15题：

    Which statement describes the XML management interface in Cisco NX-OS Software？（）

    • A、The following XML-based NETCONF operations are supported in NX-OS SoftwarE˙close-session  copy-config  delete-config  and edit-config
    • B、The following XML-based NETCONF operations are supported in NX-OS SoftwarE˙close-session  copy-config  edit-config  and kill-session
    • C、NX-OS Software supports up to a maximum of 16 concurrent XML sessions
    • D、Only show commands are supported via the XML management interface in NX-OS Software
    • E、The NX-OS implementation of the XML-based NETCONF requires SSH to be used for communication with the device

    正确答案:E

  • 第16题：

    Which of the following describes the model used by the Geodetic Extender?（）

    • A、Flat earth
    • B、3-D Square
    • C、Trapezoidal
    • D、Round earth

    正确答案:D

  • 第17题：

    Which of the following are all valid DB2 data types?（）

    • A、LONG VARCHAR, SMALLINT, NUMBER, BLOB
    • B、DECIMAL, DATE, DBCLOB, INTERVAL
    • C、NUMERIC, TIMESTAMP, BYTE, FLOAT
    • D、NUM, TIME, XML, DOUBLE

    正确答案:D

  • 第18题：

    Which of the following describes the objects of a DB2 database and their relationships?（）

    • A、Instance
    • B、Table space
    • C、System catalog
    • D、Schema repository

    正确答案:C

  • 第19题：

    Which of the following best describes how locks are used in DB2?（）

    • A、To maintain control of updated rows for commit processing
    • B、To ensure only committed changes are altered by another application
    • C、To allow two applications to update the same row of data simultaneously
    • D、To prevent multiple applications from accessing the same data simultaneously

    正确答案:B

  • 第20题：

    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 SQL Server 2005 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query， and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table， and 50，000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal？（）

    • A、A primary XML index should be created on the XML column.
    • B、Statistics should be created on the nvarchar columns.
    • C、A view should be created， and only the four columns that the query utilizes are contained by a view.
    • D、A composite index should be created on the three nvarchar columns， and INCLUDE should be specified for the XML column.

    正确答案:D

  • 第21题：

    单选题
    Which of the following best describes how locks are used in DB2?（）
    A

    To maintain control of updated rows for commit processing

    B

    To ensure only committed changes are altered by another application

    C

    To allow two applications to update the same row of data simultaneously

    D

    To prevent multiple applications from accessing the same data simultaneously


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

  • 第22题：

    单选题
    Which of the following describes the model used by the Geodetic Extender?（）
    A

    Flat earth

    B

    3-D Square

    C

    Trapezoidal

    D

    Round earth


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

  • 第23题：

    单选题
    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 SQL Server 2005 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query， and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table， and 50，000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal？（）
    A

    A primary XML index should be created on the XML column.

    B

    Statistics should be created on the nvarchar columns.

    C

    A view should be created， and only the four columns that the query utilizes are contained by a view.

    D

    A composite index should be created on the three nvarchar columns， and INCLUDE should be specified for the XML column.


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

相关内容