单选题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.
单选题
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 application that consumes a Windows Communication Foundation (WCF) service. The service implements the IService contract. The client application contains the CallbackHandler class, which implements IServiceCallback.You need to ensure that a client proxy is created that can communicate with the service over a duplex channel.Which code segment should you use?()A.B.C.D.
Your company has an Active Directory Domain Services (AD DS) domain. You virtualize applications by using Microsoft Application Virtualization (App-V).You are creating an application virtualization package.Which should you use?()A.Microsoft Application Virtualization SequencerB.Microsoft Application Virtualization Desktop ClientC.Microsoft System Center Application Virtualization Streaming ServerD.Microsoft System Center Application Virtualization Management Server
You are in the process of creating a new application.This new application has to be able to read all data from a text file.What should you do?() A.B.C.D.
You are currently in the process of creating an application that reads binary information from a file.You need to ensure that the only the first kilobyte of data is retrieved.What should you do?() A.B.C.D.
You have recently completely creating a new application for Certkiller .com.This new application has to load an instance of the Inventory class from a large file named Inventory.dat.You need to ensure that the application executes the loading process in as little time as possible.What should you do?()A.B.C.D.
You work as a Web Developer at Certkiller.com. You are in the process of creating a Webapplication using Microsoft ASP.NET 3.5. You host the Web application in Microsoft Internet Information Services (IIS) 6.0. You browse theapplication and receive the following error message: Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable.Please hit the "Refresh" button in your web browser to retry your request. You view the Application event log and discover the following message: It is not possible to run two different versions of ASP.NET in the same IIS process. Please use theIIS Administration Tool to reconfigure your server to run the application in a separate process. To ensure productivity you need to solve this problem as quick as possible. What should you do?()A、You should change the IIS isolation mode.B、You should assign the application to another application pool.C、You should configure all applications that are part of your application's application pool in orderto use the same version of ASP.NET.D、You should run the Aspnet_regiis.exe Tool.E、You should restart the application pool that hosts the application.
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()A、 online redo log filesB、 alert log filesC、 control fileD、 datafiles associated with the SYSTEM tablespace
It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()A、cannot be used in RMANB、by starting up the database againC、by using the CATALOG command of RMAND、by using the RECOVER CATALOG command in RMANE、by re-creating the target control file to rebuild the RMAN repository
If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated?()A、 The next time you back up the database when you are also connected to the recovery catalog and the target databaseB、 The next time you are connected to the target database and the recovery catalog database and issue the resync commandC、 The next time you connect RMAN to just the recovery catalogD、 The next time you connect to the recovery catalog and the target database with RMANE、 Connecting to the recovery catalog and issuing the resync all databases command
You use Microsoft .NET Framework 4 to create a Windows application. You plan to deploy the application by using Trusted Application Deployment. The application can only be installed by users who have elevated permissions. You need to ensure that users are not prompted for additional permissions when they install the application. Which two actions should you perform? ()A、Obfuscate the assemblies.B、Configure the application as online only.C、Enable User Account Control (UAC) on all client computers.D、Sign the deployment manifest with the publisher's digital certificate.E、Add the publisher of application to the trusted publisher's store on all client computers.
Your company has an Active Directory Domain Services (AD DS) domain. You virtualize applications by using Microsoft Application Virtualization (App - V). You are creating an application virtualization package. Which sh ould you use?()A、Microsoft Application Virtualization SequencerB、Microsoft Application Virtualization Desktop ClientC、Microsoft System Center Application Virtualization Streaming ServerD、Microsoft System Center Application Virtualization Management Server
You are creating a Windows Forms application by using the .NET Framework 3.5 The application is used by a financial service provider.You discover that the service provider transfers large amounts of data by using XML.You need to read and validate the XMLdocuments in the most time efficient manner.Which technology should you use?()A、The XmlReader classB、The XmlDocument classC、The XmlResolver classD、The LINQ to XML method
You have a single Active Directory directory service domain. You have an application that adds Active Directory Schema attributes during installation. The attributes replicate as part of global catalog replication. Your user account is a member of the Domain Admins, Schema Admins, and Enterprise Admins global groups. You test the application and decide not to deploy it to production. You need to ensure that the attributes that are added by the application are no longer available in Active Directory. Using the Active Directory Schema snap-in,what should you do?()A、 Clear the Index this attribute in the Active Directory option for each attribute that is added by the application.B、 Clear the Attribute is active option for each attribute that is added by the application.C、 Clear the Replicate this attribute to the Global Catalog option for each attribute that is added by the application.D、 Clear the Allow this attribute to be shown in advanced view option for each attribute that is added by the application.
You work as an application developer at Cer-Tech.com.You are in the process of creating an application for Cert-Tech.com’s Human Resources department that tracks employee benefits You have to store current employee data without recompiling the application. You elect to store this employee data as a custom section in the application configuration file. The relevant portion of the application configuration file is shown in the following exhibit: What should you do?()A、 Create a custom section handler class that inherits the ConfigurationSection interfaceB、 Add a section element to the EmployeeSection element of the application configuration fileC、 Create a custom section handler class that implements the IConfigurationSectionHandler interface.D、 Add an EmployeeSection element to the configSections element of the application confguration fileE、 Create a custom section handler class that implements the IApplicationSettingsProvider interfaceF、 Add a section element to the configSections element of the application configuration file
多选题You are creating a Windows Forms application by using the .NET Framework 3.5.You plan to deploy the application in multiple countries and languages.You need to ensure that the application meets the globalization requirements. Which two actions should you perform?()AHandle server names and URLs as ASCII dataBUse Unicode strings throughout the applicationCUse the NumberFormatInfo class for numeric formattingDHandle strings as a series of individual characters instead of entire stringsEAvoid usage of the SortKey class and the CompareInfo class for sorting purposes
单选题Your company has 1,000 client computers. You are planning to deploy Windows 7 and a new line-of-business application. You have the following requirements: Install the application as part of the standard Windows 7 deployment. Use a single Windows 7 image for the deployment. The application must be available for use on client computers that are not connected to the network. You need to ensure that the application is installed on all new client computers. What should you do?()APublish the application by using Group Policy Software Installation.BDeploy the application by using Windows Server Update Services (WSUS).CService an online image of Windows 7 to add the new application.DService an offline image of Windows 7 to add the new application.
单选题You are creating a Windows Forms Application by using the .NET Framework 3.5.You plan to deploy a new Applciation.You need to ensure that on deployment, the application meets the following requirements; (1)It is executed on the client computer. (2)It is removed from the client computer after the application closed. (3)It is not displayed in the Add/Remove programs panel on the client computer. What sould you do?()ADeploy the application to a central network server.- Access the application by using hte Remote Desktop Connection tool.BDeploy the application by using the ClickOnce technology.- Use the Mage.exe tool to set the Online Only option in the deployment manifest.CDeploy the application by using the ClickOnce technologoy.- Set the Install attiribute of the deployment tag to true in the deployment manifest.DDeploy the application to a CD-ROM by using the ClickOnce technology. - Execute the application from the CD-ROM.
单选题While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this database. The options that can be considered while moving the recovery catalog are as follows: 1. Using one of the Oracle expdp utilities to export the catalog data 2. Creating a recovery catalog user and granting the necessary privileges in the other database 3. Creating the recovery catalog using the CREATE CATALOG command 4. Using the corresponding impdp utility to import the catalog data into the other database 5. Registering the target database in the new catalog database using the REGISTER DATABASE command Identify the option with the correct sequence for moving the recovery catalog.()A2,3,5B1,2,4C1,2,4,5D1, 2, 3, 4, 5
多选题You work as an ASP.NET Web Application Developer for SomeCompany. The company uses Visual Studio .NET 2010 as its application development platform. You are creating an ASP.NET Web application using .NET Framework 4.0. The application holds a Web page named MyHome.aspx. You are creating a button with a rolloverimage on MyHome.aspx. However, when mouse hovered over the button image, the rolloverimage is retrieved from the server in a separate request. You need to use an improved rollover button in which the button„s rolloverimage is already downloaded and stored in the browser’s cache, as a result when you hover over the button, it is instantly displayed. What will you do to accomplish this?()AUse JavaScript Object Notation.BUse the RegisterClientScriptBlock method.CUse the RegisterClientScriptlnclude method.DBuild a JavaScript function.EUse the RegisterClientScriptResource method.
单选题In a JSP-centric web application, you need to create a catalog browsing JSP page. The catalog is stored asa List object in the catalog attribute of the webapp’s ServletContext object. Which scriptlet code snippetgives you access to the catalog object?()A% List catalog = config.getAttribute(catalog); %B% List catalog = context.getAttribute(catalog); %C% List catalog = application.getAttribute(catalog); %D% List catalog = servletContext.getAttribute(catalog); %
单选题You are creating a Windows Forms application for a financial service provider by using the .NET Framework 3.5. You have to implement a multiple document interface (MDI) in the application to allow users to open multiple financial documents simultaneously.You need to ensure that whenever the child MDI form is created, the application displays a message in the title bar of the parent MDI that a child form has received focus. What should you do?()AImplement theActivated eventBImplement the MdiChildActivate eventCOverride the OnParentVisibleChanged methodDOverride the OnParentBindingContextChanged method
单选题You are creating a Windows Forms Application by using the .NET Framework 3.5.You plan to create a Windows Installer package for a Windows Forms application. The package will be deployed on Windows Vista computers.You need to ensure that during deployment the installation does not elevate privileges of the user installing the application.What should you do?()ACreate a custom action and set the NoImpersonate property to trueBCreate a custom action and set the NoImpersonate property to falseCCreate a manifest and set the RequestedExecutionLevel level attribute to AsInvokerDCreate a manifest and set the RequestedExecutionLevel level attribute to AsAdministrator
单选题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.
单选题You are a network administrator for your company. You install Windows Server 2003 on two servers named Server1 and Server2. You configure Server1 and Server2 as a two-node cluster. You configure a custom application on the cluster by using the Generic Application resource, and you put all resources in the Application group. You test the cluster and verify that it fails over properly and that you can move the Applications group from one node to the other and back again. The application and the cluster run successfully for several weeks. Users then report that they cannot access the application. You investigate and discover that Server1 and Server2 are running but the Application group is in a failed state. You restart the Cluster service and attempt to bring the Application group online on Server1. The Application group fails. You discover that Server1 fails, restarts automatically, and fails again soon after restarting. Server1 continues to fail and restart until the Application group reports that it is in a failed state and stops attempting to bring itself back online. You need to configure the Application group to remain on Server2 while you research the problem on Server1. What should you do? ()A On Server2, configure the failover threshold to 0.B On Server2, configure the failover period to 0.C Remove Server1 from the Possible owners list.D Remove Server1 from the Preferred owners list.
单选题You are creating a Windows Forms application by using the .Net Framework 3.5.You plan to design a composite control for the application.You need to derive the control from a base class that supports templates.What should you do?()ADerive from the Control class.BDerive from the UserControl class.CDerive from the ScrollableControl class.DDerive from the ContainerControl class.
单选题You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. The application requires frequent updates. You want to use the ClickOnce technology to distribute the application to Internet users. You need to ensure that the application is automatically updated without requiring user intervention. You also need to ensure that the users execute the most recent version of the application. What should you do when you publish the application? ()AUse Install the application from a file share. Select the Application is available online and offline option.BUse Install the application from CD-ROM or a DVD-ROM. Select the Application will not check for updates option.CUse Install the application from a Web site. Select the Application is available online only option.DUse Install the application from a Web site. Select the Application is available online and offline option.
单选题It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()Acannot be used in RMANBby starting up the database againCby using the CATALOG command of RMANDby using the RECOVER CATALOG command in RMANEby re-creating the target control file to rebuild the RMAN repository
单选题You are creating a recovery catalog for use with RMAN. You have issued these commands: SQL CREATE TABLESPACE rman_ts DATAFILE ’/DISK1/rman_ts01.dbf’ 2 SIZE 20M 3 DEFAULT STORAGE (initial 100K next 100K pctincrease 0); SQL CREATE USER rman_db01 IDENTIFIED BY rman_db01 2 DEFAULT TABLESPACE rman_ts 3 QUOTA unlimited ON rman_ts; Which command should you issue next?()ARESYNC CATALOG;BREGISTER DATABASE;CCREATE CATALOG TABLESPACE rman_ts;DGRANT recovery_catalog_owner TO rman_db01;