网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.” 相关考题
考题
Servlet A receives a request that it forwards to servlet B within another web application in the same webcontainer. Servlet A needs to share data with servlet B and that data must not be visible to other servlets inA’s web application. In which object can the data that A shares with B be stored？（）A、HttpSessionB、ServletConfigC、ServletContextD、HttpServletRequestE、HttpServletResponse
考题
Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However，on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However,the query fails when executed.You need to troubleshoot the cause of the error. What should you do？（）A、Join the two servers by using the four-part syntax of server.database.schema.table.B、Reference SQL2 by using an alias.C、Add SQL2 as a remote server to SQL1.D、Add SQL2 as a linked server to SQL1.
考题
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. The company stores clients data in DB1. Clients can access their profile data by using a Web application. You must ensure the security of the customer data, you must ensure that even if the backup media is lost, data files, log files and subsequent backups and so on are quite safe. So what action should you perform to achieve this goal?（）A、For both the CustomerDB database and the master database, enable Transparent Database Encryption.B、You should use the built-in encryption functions to encrypt the sensitive data at the cell level. C、You should make the CustomerDB database accessible only through stored procedures and functions. D、For the CustomerDB database, enable Transparent Database Encryption and back up the transaction log.
考题
Servlet A receives a request that it forwards to servlet B within another web application in the same web container. Servlet A needs to share data with servlet B and that data must not be visible to other servlets in A’s web application. In which object can the data that A shares with B be stored？（）A、 HttpSessionB、 ServletConfigC、 ServletContextD、 HttpServletRequestE、 HttpServletResponse
考题
You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports. What should you do?（）A、 Publish the data in the database as an XML Web service by using the FOR XML AUTO clause. B、 Create a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service. C、 Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service. D、 Have a developer in your company create an assembly that calls the remote Web service. Create aCLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.
考题
You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）A、Configure a Linked Server connection to the application database.B、Write a query that uses an OPENDATASOURCE command.C、Write a query that uses an OPENQUERY command.D、Configure a Remote Server connection to the application database.
考题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. VIP customer data of the company are stored in DB1. The customers access their profile data by using a Web application. You must ensure the security of the customer data， that is to say， even if the backup media is lost， you must guarantee that data files， log files and subsequent backups and so on are as safe as possible. So what action should you perform to achieve this goal？（）A、For both the CustomerDB database and the master database, enable Transparent Database Encryption B、You should use the built-in encryption functions to encrypt the sensitive data at the cell Ievel C、You should make the CustomerDB database accessible only through stored procedures and functions. D、For the CustomerDB database, enable Transparent Database Encryption and back up the transaction log.
考题
You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?（）A、Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.B、Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.C、Create a SQL Server Integration Services （SSIS） package to import， standardize， and cleanse the data.D、Create a CLR stored procedure to import the data into a staging table， to cleanse and standardize the data， and to insert the data into the database.
考题
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. There is a database named Inventory on a SQL Server 2005 computer， and the computer is named SQL01. SQL01 is utilized to aggregate manufacturing part numbers from your company’s trading partners. And the company stores the manufacturing part numbers in the Product table in the Inventory database. The company requests the users to deliver data as text files from each trading partner to SQL1 every night. The data should be imported， and no duplicate manufacturing part numbers should exist in the data which is imported from the text files， and the text files are stored in the Inventory database on SQL01. You should cut the effect on your company’s trading partners and your IT department to the least. Which action should you perform？（）A、First， you should import the data from each text file into a staging table. Second， you should write a query to have a HAVING clause contained so as to migrate replicate values before results are inserted into the Product table.B、First， you should make sure that each text file is stored in an Extensible Markup Language （XML） file. Second， you should utilize Extensible Stylesheet Language Transformations （XSLT） to automatically migrate replicates before data is imported into the Product table.C、First， you should make sure that the unique key values for manufacturing part numbers are utilized by each of your company’s trading partners utilizes. Second， you should import the text files into the Product table.D、You should place a unique index on the PartNum column.
考题
You create a Web Form. The Web Form allows users to log on to a Web site. You implement the login logic using a Login control named Login1. The membership data for the application is stored in a SQL Express database in the App_Data directory. You need to configure your application so that the membership data is stored in a local Microsoft SQL Server database. You add the following code segment to the Web.config file. Which two additional actions should you perform?（）A、Use Aspnet_regsql.exe to create the Microsoft SQL Server database.B、Set Login1's MembershipProvider property to MySqlProviderConnection.C、Add the following code segment to the Web.config file.connectionStrings add name="MySqlProviderConnection" connectionString="valid connection string" //connectionStringsD、Add the following code segment to the Web.config file.appSettingsadd key="MySqlProviderConnection" value="valid connection string" //appSettingsE、In the ASP.NET configuration settings within IIS, ensure that Role Management Enabled is selected.F、Use the Web Site Administration Tool to select AspNetSqlMembershipProvider as the membership provider for your application.
考题
You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do？（）A、Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.B、Define the new column as NOT NULL with a default value of ’Undefined.’C、Define the new column as NULL. Use application logic to enforce the data constraint.D、Define the new column as NULL with a default value of ’Undefined.’
考题
You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1，000 simultaneous users. This application must quickly display the results of calculation-intensive operations， such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do？（）A、Implement parameterized Transact-SQL queries in the application.B、Implement Transact-SQL stored procedures in the database.C、Implement CLR stored procedures in the database.D、Implement distributed Web services.
考题
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.
考题
单选题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. There is a database named Inventory on a SQL Server 2005 computer， and the computer is named SQL01. SQL01 is utilized to aggregate manufacturing part numbers from your company’s trading partners. And the company stores the manufacturing part numbers in the Product table in the Inventory database. The company requests the users to deliver data as text files from each trading partner to SQL1 every night. The data should be imported， and no duplicate manufacturing part numbers should exist in the data which is imported from the text files， and the text files are stored in the Inventory database on SQL01. You should cut the effect on your company’s trading partners and your IT department to the least. Which action should you perform？（）A
First， you should import the data from each text file into a staging table. Second， you should write a query to have a HAVING clause contained so as to migrate replicate values before results are inserted into the Product table.B
First， you should make sure that each text file is stored in an Extensible Markup Language （XML） file. Second， you should utilize Extensible Stylesheet Language Transformations （XSLT） to automatically migrate replicates before data is imported into the Product table.C
First， you should make sure that the unique key values for manufacturing part numbers are utilized by each of your company’s trading partners utilizes. Second， you should import the text files into the Product table.D
You should place a unique index on the PartNum column.
考题
单选题You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）A
Configure a Linked Server connection to the application database.B
Write a query that uses an OPENDATASOURCE command.C
Write a query that uses an OPENQUERY command.D
Configure a Remote Server connection to the application database.
考题
单选题You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1,000 simultaneous users. This application must quickly display the results of calculation-intensive operations, such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do?（）A
Implement parameterized Transact-SQL queries in the application. B
Implement Transact-SQL stored procedures in the database. C
Implement CLR stored procedures in the database. D
Implement distributed Web services.
考题
单选题You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?（）A
Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.B
Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.C
Create a SQL Server Integration Services （SSIS） package to import， standardize， and cleanse the data.D
Create a CLR stored procedure to import the data into a staging table， to cleanse and standardize the data， and to insert the data into the database.
考题
单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. The company stores clients data in DB1. Clients can access their profile data by using a Web application. You must ensure the security of the customer data, you must ensure that even if the backup media is lost, data files, log files and subsequent backups and so on are quite safe. So what action should you perform to achieve this goal?（）A
For both the CustomerDB database and the master database, enable Transparent Database Encryption.B
You should use the built-in encryption functions to encrypt the sensitive data at the cell level. C
You should make the CustomerDB database accessible only through stored procedures and functions. D
For the CustomerDB database, enable Transparent Database Encryption and back up the transaction log.
考题
单选题You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1，000 simultaneous users. This application must quickly display the results of calculation-intensive operations， such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do？（）A
Implement parameterized Transact-SQL queries in the application.B
Implement Transact-SQL stored procedures in the database.C
Implement CLR stored procedures in the database.D
Implement distributed Web services.
考题
单选题You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. The application uses Session objects. You are modifying the application to run on a Web farm. You need to ensure that the application can access the Session objects from all the servers in the Web farm. You also need to ensure that when any server in the Web farm restarts or stops responding， the Session objects are not lost. What should you do？（）A
Use the InProc Session Management mode to store session data in the ASP.NET worker process. B
Use the SQLServer Session Management mode to store session data in a common Microsoft SQL Server 2005 database. C
Use the SQLServer Session Management mode to store session data in an individual database for each Web server in the Web farm. D
Use the StateServer Session Management mode to store session data in a common State Server process on a Web server in the Web farm.
考题
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. VIP customer data of the company are stored in DB1. The customers access their profile data by using a Web application. You must ensure the security of the customer data， that is to say， even if the backup media is lost， you must guarantee that data files， log files and subsequent backups and so on are as safe as possible. So what action should you perform to achieve this goal？（）A
For both the CustomerDB database and the master database, enable Transparent Database Encryption B
You should use the built-in encryption functions to encrypt the sensitive data at the cell Ievel C
You should make the CustomerDB database accessible only through stored procedures and functions. D
For the CustomerDB database, enable Transparent Database Encryption and back up the transaction log.
考题
单选题Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However，on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However,the query fails when executed.You need to troubleshoot the cause of the error. What should you do？（）A
Join the two servers by using the four-part syntax of server.database.schema.table.B
Reference SQL2 by using an alias.C
Add SQL2 as a remote server to SQL1.D
Add SQL2 as a linked server to SQL1.
考题
单选题Servlet A receives a request that it forwards to servlet B within another web application in the same webcontainer. Servlet A needs to share data with servlet B and that data must not be visible to other servlets inA’s web application. In which object can the data that A shares with B be stored？（）A
HttpSessionB
ServletConfigC
ServletContextD
HttpServletRequestE
HttpServletResponse
考题
单选题You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do？（）A
Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.B
Define the new column as NOT NULL with a default value of ’Undefined.’C
Define the new column as NULL. Use application logic to enforce the data constraint.D
Define the new column as NULL with a default value of ’Undefined.’
考题
单选题You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports. What should you do?（）A
Publish the data in the database as an XML Web service by using the FOR XML AUTO clause. B
Create a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service. C
Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service. D
Have a developer in your company create an assembly that calls the remote Web service. Create aCLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.
考题
单选题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.
考题
单选题Servlet A receives a request that it forwards to servlet B within another web application in the same web container. Servlet A needs to share data with servlet B and that data must not be visible to other servlets in A’s web application. In which object can the data that A shares with B be stored？（）A
HttpSessionB
ServletConfigC
ServletContextD
HttpServletRequestE
HttpServletResponse
热门标签
最新试卷