单选题Which of the following is NOT true about XML columns?（）AData can be retrieved by SQL.BData can be retrieved by XQuery.CXML columns must be altered to accommodate additional parent and child relationships.DAccess 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 can be direct, without reading the whole document.
参考解析
解析：
暂无解析
相关考题：
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
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 describes how DB2 9 stores an XML document if the XML Extender is not used?() A.CLOBB.BLOBC.HierarchicallyD.Rows and columns
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
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 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 subqueryF、 Multiple columns or expressions can be compared between the main query and subquery
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
Which of the following are TRUE about a store archive？（）A、It is an XML file containing store data assetsB、It uses the same file format as a ZIP fileC、It contains file assets to create a store or siteD、It can easily be copied from one machine to anotherE、It can contain WebSphere Commerce instance configuration information
Which of the following supports the XML data type?（）A、A unique indexB、A composite indexC、A check constraintD、A generated column
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 three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?（）A、A DBA can check specific tables with the DMUB、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.
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.
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.
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
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.
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.
多选题Which two statements are true regarding the USING clause in table joins?（）AIt can be used to join a maximum of three tablesBIt can be used to restrict the number of columns used in a NATURAL joinCIt can be used to access data from tables through equijoins as well as nonequijoinsDIt can be used to join tables that have columns with the same name and compatible data types
单选题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？（）AAdd an XML index to the table that contains the product data.BAdd the XSINIL argument to the ELEMENTS directive in the query.CAdd a HAVING clause to the query.DAdd the replace value of clause to the query.
多选题Which three statements about subqueries are true? （）AA main query can have more than one subquery.BA subquery can have more than one main query.CThe subquery and main query must retrieve data from the same table.DThe subquery and main query can retrieve data from different tables.EOnly one column or expression can be compared between the subquery and main query.FMultiple columns or expression can be compared between the subquery and main query.
单选题Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?（）ACLOBBBLOBCHierarchicallyDRows and columns
多选题Which two statements are true regarding the USING and ON clauses in table joins?（）ABoth USING and ON clauses can be used for equijoins and nonequijoinsBAmaximum of one pair of columns can be joined between two tables using the ON clauseCThe ON clause can be used to join tables on columns that have different names but compatible data typesDThe WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause
单选题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? （）ALoad the XML data by using an instance of the XmlDocument class and specify a location for the application schema.BConfigure the ValidationEventHandler in the XmlReaderSettings of the XmlReader object.CRead the XML file into a DataSet object and set the EnforceConstraints property to True.DRead the XML file into a DataSet object. Handle the DataSet.MergeFailed event to parse the data that does not conform to the XML schema.
多选题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?（）AEach extra column in the copy with more columns must not have a default valueBColumns that are common to both versions of the table must be defined in the same order on the master and the slaveCThe slave database cannot have more columns than the master. Only the master database can have more columnsDColumns 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 serverEThe master database cannot have more columns than the slave. Only the slave deatbase can have more columns
单选题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？（）AA primary XML index should be created on the XML column.BStatistics should be created on the nvarchar columns.CA view should be created， and only the four columns that the query utilizes are contained by a view.DA composite index should be created on the three nvarchar columns， and INCLUDE should be specified for the XML column.
多选题Which three statements are true regarding subqueries?（）ASubqueries can contain GROUP BY and ORDER BY clausesBMain query and subquery can get data from different tablesCMain query and subquery must get data from the same tablesDSubqueries can contain ORDER BY but not the GROUP BY clauseEOnly one column or expression can be compared between the main query and subqueryFMultiple columns or expressions can be compared between the main query and subquery
单选题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.
多选题Which of the following are TRUE about a store archive？（）AIt is an XML file containing store data assetsBIt uses the same file format as a ZIP fileCIt contains file assets to create a store or siteDIt can easily be copied from one machine to anotherEIt can contain WebSphere Commerce instance configuration information