ĐỀ THI LÝ THUYẾT AFSS

Detailed Score Report

Correct 50% answered this correctly. 50% answered wrong   <><><!--[if !supportMisalignedColumns]--> <><><!--[endif]--> Q.1) This refer to parts of XML documents. These parts need not include the root element.   A. XML Views B. XML fragments () C. Native XML storage Correct 100% answered this correctly. 0% answered wrong   Q.2) The XML data type can be used to define: - 3 choices.   A. rowa B. columns () C. parameters () D. values E. variables () Correct 100% answered this correctly. 0% answered wrong   Q.3) Until an xml data type variables. parameter, or column is not associated with an xml schema it is called:   A. Typed XML data B. Untyped XML data () Correct 100% answered this correctly. 0% answered wrong   Q.4) Which statement of code is type xml data?   A. CREATE TABLE student( ID varchar(20) not null, Address xml (CONTENT studentAddress) null, Class xml ) () B. CREATE TABLE student( ID varchar(20) not null, Address xml null, Class xml not null ) Correct 100% answered this correctly. 0% answered wrong   Q.5) The XML data type enable storage of xml data in their native form, xml   A. True () B. False Correct 100% answered this correctly. 0% answered wrong   Q.6) XML data type variables or columns can only store complete XML documents.   A. True B. False () Incorrect 50% answered this correctly. 50% answered wrong   Q.7) Native XML storage makes it easy to map XML data into relational databases   A. True () B. False (correct answer) Correct 100% answered this correctly. 0% answered wrong   Q.8) XML data can provide a highly optimized querying environment by indexing.   A. True () B. False Incorrect 50% answered this correctly. 50% answered wrong   Q.9) XML views work best when data in database needs to be converted to xml   A. True (correct answer) B. False () Correct 100% answered this correctly. 0% answered wrong   Q.10) XML data storage in relational databases makes data management impossible.   A. True B. False () Correct 100% answered this correctly. 0% answered wrong   Q.11) XML document can be validated against their schemas sincean xml schema defines an xml document's basic structure.   A. True () B. False Correct 100% answered this correctly. 0% answered wrong   Q.12) ALTER XML SCHEMA COLLECTION statement permits developers to modify existing schema elements and attributes.   A. True B. False () Correct 50% answered this correctly. 50% answered wrong   Q.13) This method is used to shred an xml document into relational data.   A. query(); B. value(); C. nodes(); () D. modify(); Correct 100% answered this correctly. 0% answered wrong   Q.14) This method is used to retrieve fragments of an xml document.   A. value() B. data() C. query() () D. nodes() Correct 100% answered this correctly. 0% answered wrong   Q.15) Insert, append or delete XML document nodes.   A. modify () B. nodes C. query Incorrect 50% answered this correctly. 50% answered wrong   Q.16) Recreate xml fragments as specified by query.   A. modify () B. exist C. query (correct answer) Correct 50% answered this correctly. 50% answered wrong   Q.17) Transpose XML values to relational database   A. value B. exist C. nodes () D. node Incorrect 50% answered this correctly. 50% answered wrong   Q.18) You want to create a table store long distance train travel details. The table stores the journey, passenger and reservation details in the form of untyped XML data. Which one of the following codes will help you achieve this ?   A. CREATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails varchar NOT NULL, PassengerDetails varchar NOT NULL, ReservationDetails varchar NOT NULL) B. CREATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails XML, PassengerDetails XML (CONTENT Passenger) NOT NULL, ReservationDetails varchar NOT NULL) () C. CRATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails XML, PassengerDetails XML, ReservationDetails XML) (correct answer) D. CREATE TABLE LongDistanceDetails(TicketNumber varchar NOT NULL, JourneyDetails XML (CONTENT Journey) NOT NULL, PassengerDetails XML (CONTENT Passenger) NOT NULL, ReservationDetails XML (CONTENT Reservation) NOT NULL) Incorrect 50% answered this correctly. 50% answered wrong   Q.19) Which of these codes snippets about XML data type methods are true and which of these statements are false ?   A. SELECT StudentID FROM Students WHERE @student.exist(‘(/Age)[.=”15”]’)=1 (missed) B. SELECT @student.value( ‘(/Student/Age)[1]’, ‘int(2)’) (missed) C. SELECT StudentID FROM Students WHERE @student.exist(‘(/Age)[.=”15”]’)=0 () D. SET @student.modify( ‘insert Aaroninto Student[1]’) (missed) E. SELECT StudentID FROM Students WHERE @student.exist(‘(/Age’=”15”) Correct 100% answered this correctly. 0% answered wrong   Q.20) Software entity that calls a service provider   A. Service Consumer () B. Service Locator C. Service Broker D. Services E. Service Provider Correct 50% answered this correctly. 50% answered wrong   Q.21) Software entity that implements a service specification.   A. Service Consumer B. Service Locator C. Service Broker D. Services E. Service Provider () Incorrect 50% answered this correctly. 50% answered wrong   Q.22) Service provider that can pass on service requests to one or more additional service providers.   A. Service Consumer B. Service Locator () C. Service Broker (correct answer) D. Services E. Service Provider Correct 100% answered this correctly. 0% answered wrong   Q.23) Service provider that acts as a registry and allows for lookup of service provider interfaces and service location   A. Service Consumer B. Service Locator () C. Service Broker D. Services E. Service Provider Correct 100% answered this correctly. 0% answered wrong   Q.24) Function in which consumers communicate through contract   A. Service Consumer B. Service Locator C. Service Broker D. Services () E. Service Provider Incorrect 50% answered this correctly. 50% answered wrong   Q.25) SOA is an architecture that encourages tightly coupled communication between software services.   A. True (correct answer) B. Fasle () Correct 100% answered this correctly. 0% answered wrong   Q.26) Service-Oriented architecture is essentially a collection of services that communicate with each other   A. True () B. False Correct 50% answered this correctly. 50% answered wrong   Q.27) Service-Oriented terminology provides patterns for design, development, deployment, and management of a loosely coupled business application infrastructure   A. True () B. False Correct 100% answered this correctly. 0% answered wrong   Q.28) Service consumer can be a client application, a server application such as a Web server, or any other kind of application.   A. True () B. False Correct 100% answered this correctly. 0% answered wrong   Q.29) Service is a function that directly depends on the state of other service.   A. True B. False () Incorrect 50% answered this correctly. 50% answered wrong   Q.30) A group sharing similar dialog conversations.   A. Endpoints B. Service Broker Security C. Conversation Groups (correct answer) D. Messages () E. Dialogs Correct 100% answered this correctly. 0% answered wrong   Q.31)   A conversation that takes place between two Service Brokers.   A. Endpoints B. Service Broker Security C. Conversation Groups D. Messages E. Dialogs () Correct 100% answered this correctly. 0% answered wrong   Q.32) An entity that is exchanged between Service Brokers   A. Dialogs B. Endpoints C. Conversation Groups D. Service Broker Security E. Messages () Incorrect 50% answered this correctly. 50% answered wrong   Q.33)   Supports communication between two services and connection between two databases along with authentication   A. Endpoints B. Dialogs () C. Service Broker Security (correct answer) D. Conversation Groups E. Message Correct 100% answered this correctly. 0% answered wrong   Q.34) Responsible for the communication in Service Broker   A. Conversation Groups B. Endpoints () C. Service Broker Security D. Dialogs E. Messages Incorrect 50% answered this correctly. 50% answered wrong   Q.35) The messages are read one after another from the same queue by multiple programs   A. True () B. False (correct answer) Correct 100% answered this correctly. 0% answered wrong   Q.36) Service Broker handles ordering of messages, conversation identification, and unique delivery automatically.   A. True () B. False Correct 100% answered this correctly. 0% answered wrong   Q.37) Service Broker’s integrated design is beneficial for application performance and administration   A. True () B. Fasle Correct 100% answered this correctly. 0% answered wrong   Q.38) Defines the type of message data   A. Services B. Message Types () C. Service Program D. Queues E. Contracts Correct 100% answered this correctly. 0% answered wrong   Q.39) Agreement that specifies who sends the message and what message types are sent.   A. Message Types B. Contracts () C. Queues D. Services E. Service Type Correct 100% answered this correctly. 0% answered wrong   Q.40) Holds messages as long as they do not expire   A. Message Type B. Service Program C. Services D. Queues () E. Contracts Incorrect 50% answered this correctly. 50% answered wrong   Q.41) Receives the messages from a queue and send the messages to services.   A. Message Type B. Service Program (correct answer) C. Queues D. Services () E. Contracts Incorrect 50% answered this correctly. 50% answered wrong   Q.42) Handles and processes all the messages when they arrive at the server.   A. Message Type B. Service Program C. Services (correct answer) D. Queues E. Contracts () Correct 100% answered this correctly. 0% answered wrong   Q.43) All Service Broker applications use conversations for their reliable communication   A. True () B. Fasle Incorrect 50% answered this correctly. 50% answered wrong   Q.44) All Service Broker applications communicate using dialogs for reliable communication   A. True () B. False (correct answer) Correct 100% answered this correctly. 0% answered wrong   Q.45) Service Broker delivers messages in an Exactly-Once-In-Order fashion   A. True () B. False Correct 50% answered this correctly. 50% answered wrong   Q.46) The first message dialog sent by the Service Broker has the message_sequence_number of one   A. True B. False () Incorrect 50% answered this correctly. 50% answered wrong   Q.47) When conversations are going on between various SQL Server instances, Service Broker use the routes to direct the messages.   A. True (correct answer) B. False () Correct 100% answered this correctly. 0% answered wrong   Q.48)   Any type of message body is acceptable.   A. NONE () B. Well Formed xml C. Well Formed Xml Schema D. Empty Incorrect 50% answered this correctly. 50% answered wrong   Q.49) Only an empty message body is acceptable   A. NONE () B. Well Formed XML C. Well Form XML Schema D. EMPTY (correct answer) Incorrect 50% answered this correctly. 50% answered wrong   Q.50) Only a message body with valid XML is acceptable.   A. NONE B. Well Formed XML (correct answer) C. Well Formed XML Schema () D. EMPTY Correct 100% answered this correctly. 0% answered wrong   Q.51) Only a message with valid XML and XML schema is acceptable   A. NONE B. Well Formed XML C. Well Formed XML Schema () D. EMPTY Correct 100% answered this correctly. 0% answered wrong   Q.52)   Arrange the following steps in sequence to create the service in Service Broker 1.      Create a contract 2.      Create an application that uses functions 3.      Create a service 4.      Create the message type 5.      Create a queue.   A. 1-3-2-4-5 B. 4-1-2-5-3 () C. 4-1-5-3-2 D. 2-3-4-1-5 Incorrect 0% answered this correctly. 100% answered wrong   Q.53) Which of the following is the correct code to send the message from service consumer to service provider   A. DECLARE @dialog_handle1 FROM SERVICE [//Adventure-Service.com/Provider] TO SERVICE ‘//Adventure-Service.com/Consumer’ DECLARE @msgString NVARCHAR(MAX) SET @msgString = N’Welcome’; SEND ON CONVERSATION @dialog_handle1 MESSAGE TYPE [//Adventure-Service.com/Adventure/AdventureSales] (@msgString) () B. DECLARE @dialog_handle1 BEGIN DIALOG CONVERSATION @dialog_handle1 FROM SERVICE [//Adventure-Service.com/Provider] TO SERVICE ‘//Adventure-Service.com/Consumer’ ON CONTRACT [//Adventure-Service.com/Adventure/Contract] DECLARE @msgString NVARCHAR(MAX) SET @msgString = N’Welcome’; SEND ON CONVERSATION @dialog_handle1 C. DECLARE @dialog_handle1 BEGIN DIALOG CONVERSATION @dialog_handle1 FROM SERVICE [//Adventure-Service.com/Provider] TO SERVICE ‘//Adventure-Service.com/Consumer’ ON CONTRACT [//Adventure-Service.com/Adventure/Contract] DECLARE @msgString NVARCHAR(MAX) SET @msgString = N’Welcome’; SEND ON CONVERSATION @dialog_handle1 MESSAGE TYPE [//Adventure-Service.com/Adventure/AdventureSales] (@msgString) (correct answer) D. DECLARE @dialog_handle1 BEGIN DIALOG CONVERSATION @dialog_handle1 ON CONTRACT [//Adventure-Service.com/Adventure/Contract] DECLARE @msgString NVARCHAR(MAX) SET @msgString = N’Welcome’; SEND ON CONVERSATION @dialog_handle1 MESSAGE TYPE [//Adventure-Service.com/Adventure/AdventureSales] Correct 100% answered this correctly. 0% answered wrong   Q.54)   Web Services are services available on the Web   A. True () B. False Correct 100% answered this correctly. 0% answered wrong   Q.55) Web Services are platform independent, but not language independent   A. True B. False () Correct 100% answered this correctly. 0% answered wrong   Q.56) Web Services fail to encourage reusability   A. True B. False () Correct 100% answered this correctly. 0% answered wrong   Q.57) Web Services makes use of industry-supported standards   A. True () B. False Correct 100% answered this correctly. 0% answered wrong   Q.58) The existing components and libraries can be easily exposed as Web Services   A. True () B. False Correct 100% answered this correctly. 0% answered wrong   Q.59) SOAP is a protocol for the exchange of information in decentralized and distributed environments   A. True () B. False Incorrect 0% answered this correctly. 100% answered wrong   Q.60) Exchanging SOAP messages leads to time consuming way for communicating with Web Services.   A. True () B. False (correct answer) Correct 100% answered this correctly. 0% answered wrong   Q.61) SOAP encourages distributed computing   A. True () B. False Correct 50% answered this correctly. 50% answered wrong   Q.62) SOAP defines application semantics such as a programming model or implementation-specific details   A. True B. False () Correct 100% answered this correctly. 0% answered wrong   Q.63) SOAP message consists of an XML document with a header and a body   A. True () B. Fasle Correct 100% answered this correctly. 0% answered wrong   Q.64) Http.sys receives requests and forwards to SQL Server based on an HTTP endpoint.   A. True () B. False Correct 100% answered this correctly. 0% answered wrong   Q.65) IIS needs to be installed to listen for the requests in SQL Server 2005   A. True B. Fasle () Incorrect 50% answered this correctly. 50% answered wrong   Q.66) Native HTTP allows implementing a database as a service to be accessed on the Web   A. True () B. False (correct answer) Incorrect 0% answered this correctly. 100% answered wrong   Q.67) WSDL document helps to create a proxy class to call a Web Service   A. True () B. Fasle (correct answer) Correct 100% answered this correctly. 0% answered wrong   Q.68) Web Service methods provide access to database objects   A. True () B. False Correct 100% answered this correctly. 0% answered wrong   Q.69)   Document that helps in creating a proxy class, understand methods and parameters passing.   A. Http.sys <!--[if !supportLineBreakNewLine]--> <!--[endif]--> B. WSDL Document Generation () C. Access to database objects. D. Native HTTP requirements. E. Receiving requests. Correct 100% answered this correctly. 0% answered wrong   Q.70) Requires installation of Windows 2003 to support native HTTP   A. Receiving requests. B. Access to database objects. C. WSDL Document Generation D. Http.sys E. Native HTTP requirements () Incorrect 50% answered this correctly. 50% answered wrong   Q.71) Combines a single method to an individual SQL Server object, to provide access to database objects.   A. WSDL Document Generation B. Native HTTP requirements C. Receiving requests D. Access to database objects. (correct answer) E. Http.sys () Correct 100% answered this correctly. 0% answered wrong   Q.72) Receives the HTTP request from the client   A. Native HTTP requirements B. Http.sys () C. WSDL Document Generation D. Receiving requests E. Access to database objects. Correct 100% answered this correctly. 0% answered wrong   Q.73) The HTTP request is forwarded to SQL Server.   A. Access to database objects. B. Receiving requests () C. Http.sys D. Native HTTP requirements E. WSDL Document Generation Correct 100% answered this correctly. 0% answered wrong   Q.74)    Which one of the following code snippets is a valid code snippet for creating HTTP endpoints?   A. CREATE ENDPOINT sqlEndpoint STATE = STARTED AS HTTP( PATH = ‘/sql’, AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR) ) () B. CREATE sqlEndpoint STATE = STARTED AS HTTP( PATH = ‘/sql’, AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR) ) C. GRANT ENDPOINT sqlEndpoint STATE = STARTED AS HTTP( PATH = ‘/sql’, AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR) ) D. CREATE POINT sqlEndpoint STATE = STARTED AS HTTP( PATH = ‘/sql’, AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR) ) Incorrect 50% answered this correctly. 50% answered wrong   Q.75)   CREATE LOGIN statement is used to add a user to the SQL Server 2005 security system.   A. True (correct answer) B. False () Incorrect 50% answered this correctly. 50% answered wrong   Q.76) GRANT ACCESS statement is used to grant permission to a user for stored procedures   A. True () B. False (correct answer) Correct 100% answered this correctly. 0% answered wrong   Q.77) GRANT CONNECT ON ENDPOINT statement grants permission to the user to connect to the HTTP endpoint.   A. True () B. False Correct 100% answered this correctly. 0% answered wrong   Q.78) Endpoints can be altered by any of the members.   A. True B. False () Correct 100% answered this correctly. 0% answered wrong   Q.79) ALTER ENDPOINT statement permits adding, removing and altering a WEBMETHOD from the endpoints   A. True () B. False Correct 100% answered this correctly. 0% answered wrong   Q.80) Which statement is used to grant permission for stored procedure or user-define function?   A. GRANT ACCESS TO B. GRANT EXECUTE TO C. GRANT EXECUTE ON TO () D. GRANT ACCESS ON TO Correct 100% answered this correctly. 0% answered wrong   Q.81) Uses e-mail, SMS, data files for the channel of communication.   A. Event <!--[if !supportLineBreakNewLine]--> <!--[endif]--> B. Subscription C. Subscriber D. Notification ()