niusouti.com

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

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

相似考题

1.You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.Which two conditions must be true?()A.Each extra column in the copy with more columns must not have a default valueB.Columns that are common to both versions of the table must be defined in the same order on the master and the slaveC.The slave database cannot have more columns than the master. Only the master database can have more columnsD.Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either serverE.The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

2.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

3.Which two statements are true regarding the USING clause in table joins?（）A、It can be used to join a maximum of three tables B、It can be used to restrict the number of columns used in a NATURAL join C、It can be used to access data from tables through equijoins as well as nonequijoins D、It can be used to join tables that have columns with the same name and compatible data types

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.

更多“单选题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 ca”相关问题

  • 第1题：

    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

  • 第2题：

    You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）

    • A、Each extra column in the copy with more columns must not have a default value
    • B、Columns that are common to both versions of the table must be defined in the same order on the master and the slave
    • C、The slave database cannot have more columns than the master. Only the master database can have more columns
    • D、Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
    • E、The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

    正确答案:B,D

  • 第3题：

    Which of the following supports the XML data type?（）

    • A、A unique index
    • B、A composite index
    • C、A check constraint
    • D、A generated column

    正确答案:A

  • 第4题：

    Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?（）

    • A、A DBA can check specific tables with the DMU
    • B、The database to be migrated must be opened read-only.
    • C、The release of the database to be converted can be any release since 9.2.0.8.
    • D、The DMU can report columns that are too long in the converted characterset.
    • E、The DMU can report columns that are not represented in the converted characterset.

    正确答案:A,D,E

  • 第5题：

    You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package. Which statement is true regarding the ACL created?（）

    • A、It is a list of remote database links stored in the XML file that are available to the users of the database.
    • B、It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.
    • C、It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.
    • D、It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.

    正确答案:B

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

  • 第7题：

    多选题
    Which two statements are true regarding the USING clause in table joins?（）
    A

    It can be used to join a maximum of three tables

    B

    It can be used to restrict the number of columns used in a NATURAL join

    C

    It can be used to access data from tables through equijoins as well as nonequijoins

    D

    It can be used to join tables that have columns with the same name and compatible data types


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

  • 第8题：

    多选题
    Which three statements about subqueries are true? （）
    A

    A main query can have more than one subquery.

    B

    A subquery can have more than one main query.

    C

    The subquery and main query must retrieve data from the same table.

    D

    The subquery and main query can retrieve data from different tables.

    E

    Only one column or expression can be compared between the subquery and main query.

    F

    Multiple columns or expression can be compared between the subquery and main query.


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

  • 第9题：

    多选题
    Which two statements are true regarding the USING and ON clauses in table joins?（）
    A

    Both USING and ON clauses can be used for equijoins and nonequijoins

    B

    Amaximum of one pair of columns can be joined between two tables using the ON clause

    C

    The ON clause can be used to join tables on columns that have different names but compatible data types

    D

    The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause


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

  • 第10题：

    多选题
    You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）
    A

    Each extra column in the copy with more columns must not have a default value

    B

    Columns that are common to both versions of the table must be defined in the same order on the master and the slave

    C

    The slave database cannot have more columns than the master. Only the master database can have more columns

    D

    Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server

    E

    The master database cannot have more columns than the slave. Only the slave deatbase can have more columns


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

  • 第11题：

    多选题
    Which three statements are true regarding subqueries?（）
    A

    Subqueries can contain GROUP BY and ORDER BY clauses

    B

    Main query and subquery can get data from different tables

    C

    Main query and subquery must get data from the same tables

    D

    Subqueries can contain ORDER BY but not the GROUP BY clause

    E

    Only one column or expression can be compared between the main query and subquery

    F

    Multiple columns or expressions can be compared between the main query and subquery


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

  • 第12题：

    多选题
    Which of the following are TRUE about a store archive？（）
    A

    It is an XML file containing store data assets

    B

    It uses the same file format as a ZIP file

    C

    It contains file assets to create a store or site

    D

    It can easily be copied from one machine to another

    E

    It can contain WebSphere Commerce instance configuration information


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

  • 第13题：

    Which three statements are true regarding subqueries?（）

    • A、Subqueries can contain GROUP BY and ORDER BY clauses 
    • B、Main query and subquery can get data from different tables 
    • C、Main query and subquery must get data from the same tables 
    • D、Subqueries can contain ORDER BY but not the GROUP BY clause 
    • E、Only one column or expression can be compared between the main query and subquery
    • F、 Multiple columns or expressions can be compared between the main query and subquery

    正确答案:A,B,E

  • 第14题：

    Which of the following are TRUE about a store archive？（）

    • A、It is an XML file containing store data assets
    • B、It uses the same file format as a ZIP file
    • C、It contains file assets to create a store or site
    • D、It can easily be copied from one machine to another
    • E、It can contain WebSphere Commerce instance configuration information

    正确答案:B,C,D

  • 第15题：

    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

  • 第16题：

    Which three statements about subqueries are true? （）

    • A、A main query can have more than one subquery.
    • B、A subquery can have more than one main query.
    • C、The subquery and main query must retrieve data from the same table.
    • D、The subquery and main query can retrieve data from different tables.
    • E、Only one column or expression can be compared between the subquery and main query.
    • F、Multiple columns or expression can be compared between the subquery and main query.

    正确答案:A,C,E

  • 第17题：

    Which two statements are true regarding the USING and ON clauses in table joins?（）

    • A、Both USING and ON clauses can be used for equijoins and nonequijoins 
    • B、Amaximum of one pair of columns can be joined between two tables using the ON clause 
    • C、The ON clause can be used to join tables on columns that have different names but compatible data types 
    • D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause 

    正确答案:C,D

  • 第18题：

    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

  • 第19题：

    单选题
    You are creating an online catalog application that will display product information on the company Web site. The product data is stored in a SQL Server 2005 database. The data is stored as relational data but must be passed to the application as an XML document by using FOR XML. You test your application and notice that not all of the items matching your query appear in the XML document. Only those products that have values for all elements in the schema appear.   You need to modify your Transact-SQL statement so that all products matching your query appear in the XML document. What should you do？（）
    A

    Add an XML index to the table that contains the product data.

    B

    Add the XSINIL argument to the ELEMENTS directive in the query.

    C

    Add a HAVING clause to the query.

    D

    Add the replace value of clause to the query.


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

  • 第20题：

    单选题
    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
    解析： 暂无解析

  • 第21题：

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


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

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    单选题
    ou need to configure fine-grained access control to external network resources from within your database. You create an access control list （ACL） using the DBMS_NETWORK_ACL_ADMIN package.  Which statement is true regarding the ACL created？（）
    A

     It is a list of remote database links stored in the XML file that are available to the users of the database.

    B

     It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.

    C

     It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.

    D

     It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.


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

  • 第24题：

    单选题
    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
    解析： 暂无解析

相关内容