单项选择题
You are transferring records from one database to another. You need to decide whether you can use the SqlBulkCopy class to transfer the records. What should you do? ()
A. Ensure that the source database is Microsoft SQL Server.
B. Ensure that the destination database is Microsoft SQL Server.
C. Ensure that the column names in the source table match the column names in the destination table.
D. Ensure that the bulk copy program (bcp) utility is installed on the destination server.
相关考题
-
单项选择题
You create an application. The application processes hundreds of XML documents per minute. The XML documents are validated against inline schemas. You need to load XML documents from the file system and read them as quickly as possible. XML comments must be ignored while reading the XML documents. What should you do?()
A. Create an instance of the XmlReader class by using the XmlReader Create method with an instance of the XmlReaderSettings class.
B. Create an instance of the XmlReader class with an instance of the XmlTextReader class.
C. Create an instance of the XmlDocument class and specify a location for the application schema.
D. Create an instance of the XmlReader class with an instance of the XmlNodeReader class. -
单项选择题
You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing. DoWork() must run as many times as possible while the SQL query is executing. Which code segment should you use?()
A. While ar.AsyncWaitHandle Is Nothing DoWork()End Whiledr = cmd.EndExecuteReader(ar)
B. While Not ar.IsCompleted DoWork()End Whiledr = cmd.EndExecuteReader(ar)
C. While T hread.CurrentThread.ThreadState = ThreadState.Running DoWork()End Whiledr = cmd.EndExecuteReader(ar)
D. While Not ar.AsyncWaitHandle.WaitOne() DoWork()End Whiledr = cmd.EndExecuteReader(ar) -
单项选择题
You load an XmlDocument named doc with the following XML. World Atlas Dictionary You need to use an XPath query string to select the two book nodes. Which code segment should you use? ()
A. Dim root As XmlElement = doc.DocumentElementDim nodes As XmlNodeList = root.SelectNodes(".")
B. Dim root As XmlElement = doc.DocumentElementDim nodes As XmlNodeList = root.SelectNodes("book")
C. Dim root As XmlElement = doc.DocumentElementDim nodes As XmlNodeList = root.SelectNodes("bookstore//book")
D. Dim root As XmlElement = doc.DocumentElementDim nodes As XmlNodeList = root.SelectNodes("books/book")
