GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Certification  >  Microsoft  >  070-176
Go To First  |  Previous Question  |  Next Question 
 070-176  |  Question 349 of 359    Print  
The stored procedure takes a single parameter, the store number of A particular store,
and returns the product sales for that store. The user can choose A store and view the sales for
that store, and can repeat this operation many times to view the sales for different stores.
Which ADO object should you use to execute the Sp_store_sales stored procedure?
(A) Parameter
(B) Recordset
(C) Connection
*(D) Command

  
Total Answers and Comments: 2 Last Update: February 09, 2006   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
January 06, 2006 10:13:38   #1  
sahu Member Since: December 2005   Contribution: 323    

RE: The stored procedure takes a single parameter, the...

Ans:

(B) Recordset


 
Is this answer useful? Yes | No
February 09, 2006 22:03:42   #2  
anurags76 Member Since: February 2006   Contribution: 1    

RE: The stored procedure takes a single parameter, the...
I dont think B is the correct option. It should be D command object.
 
Is this answer useful? Yes | No

 Related Questions

You use Visual Basic to create a COM DLL project hat contains an ActiveX control named Car View and a class module named sales. You are debugging the interaction between the ActiveX control and a host container. During a debugging session, you want to examine the contents of variables that are only in Car View. How can you accomplish this?A. Set the module context in the Add Watch dialog box to Car View. B. Set the instancing property of sales to private. C. St the public property of Car View to
Answer: A.  

You create a Visual Basic application that uses the Microsoft Internet Explorer object model. You include the following code in the General Declarations sections of a form-level module: Private oIE As new Internet Explorer.When will Visual Basic instantiate this object? A. When the form is loaded. B. When the form is displayed on the screen. C. When the declaration is executed. D. When the object is first referenced in your code.
Answer: D.  

You use Visual Basic to develop a reusable component. To make classes in your project easier to use, you intend to add descriptive text and context-sensitive help for each of the properties, methods, and events in the classes. Which procedure must you follow to add descriptive Help information for each class? A. Open the code Window for the class module. In the procedure Attributes dialog box, enter a description and a HelpcontextID for each procedure. B. Open the code Window for the class module.
Answer: A.  

You are asked to use Visual Basic to create a Human Resources application that will maintain, among other things, employee information. In designing application, you delete to encapsulate the business logic into a COM EXE named HRManager.exe. Within the user interface portion of your application, you want to create an instance of the Employee object exposed by HRManager.exe Which two code fragments will instantiate an Employee object variable? (Choose two) A. Set oEmployee = New HRManager.Employee
Answer: A, B.  

You decide to use a remote server component in your Visual Basic application. You create an installation routine by using the package and deployment wizard. You want to place an entry in the Setup.lst file to mark the appropriate file as a remote server component and specify the connection information. Under which section within the Setup.lst file must you make these changes? A. The setup section. B. The Setup1 Files section. C. The BootStrap section. D. The BootStrap Files section.
Answer: B  

You create a multi-user Visual Basic application that interacts with a database. You are using ADO and need an updatable, disconnected recordset. You need to offer users the ability to add, update, and modify records. What must you do to accomplish this? A. Set the CursorType property to adOpenStatic, and set the LockType property to adLockBatchOptimistic. B. Set the CursorType property to adOpenDynamic, and set the LockType property to adLockPessimitic. C. Set the CurcorType property to adOpenDynamic
Answer: A.  

You compile a Visual Basic application into an .exe file. You will use the package and deployment wizard to distribute the application. What must you do to the application before you can successfully deploy it by using the Package and Deployment Wizard? A. Compress the application into one or more .cab files. B. Assign the application a version number in the registry. C. Create a package by using the package and deployment wizard. D. Assign the application an .lpk file.
Answer: C.  

You create a Visual Basic ActiveX control that you want to distribute on internet Web pages. You want your control to automatically install from your web site to a client computer. What should you do?A. Create a .cab file by using the package and deployment wizard. Compress the .cab file, and transfer it to your server by using FTP. B. Create an .exe file by using the package and deployment wizard. Transfer it to your Web server by using FTP. C. Create a single .cab file by using the package and
Answer: C.  

You create a Visual Basic application that you want to distribute on CD-ROM. You want the setup application to automatically execute when users insert the CD-ROM into their CD-ROM drives. How can you accomplish this? A. Add an Autorun.inf file to the root directory of the CD-ROM. B. Make sure the setup application is named Autorun.exe. C. Add the line Autorun=1 to the project .inf file produced by the Package and deployment wizard. D. Add the name of your setup application to the startup section
Answer: A.  

You are using Visual Basic to create an ActiveX control that you want to distribute to other developers. You want to add an About box to your control to show your e-mail address. How can you implement this About box so that it is available in the Properties Window?A. Add a new property page to your control project. Name this page in the Connect Property Pages dialog box. B. Add a new form to your control project. Create a public procedure to show the form, and set its procedure ID to About Box.
Answer: B.  


 Sponsored Links

 
Related Articles

ODP.NET - OracleCommand Object

ODP NET More About the OracleCommand Object Till now we have seen OracleCommand working with OracleDataReader OracleCommand is not simply meant for OracleDataReader It has got a lot of functionality for itself Let us see few of the most commonly used features of OracleCommand in this section We will
 

ODP.NET - Populating a Dataset with a Single Data Table

ODP NET Populating a Dataset with a Single Data Table A dataset is simply a group of data tables These data tables can be identified with their own unique names within a dataset You can also add relations between data tables available in a dataset mosgoogle The following code gives you the details o
 

ODP.NET - Retrieving a Single Row of Information Using OracleDataAdapter

ODP NET Retrieving a Single Row of Information Using OracleDataAdapter In the previous example we worked with a set of rows in the DataTable object Now we shall work with a particular row using the DataTable object The following code accepts an employee number from the user and gives you the details
 

Microsoft AJAX Library - Creating Object Members on the Fly

Creating Object Members on the Fly One major difference between OOP in C and ASP NET and OOP in JavaScript is that JavaScript allows creating object members on the fly" This is true for objects and classes that you create yourself and also for JavaScript s own objects and types as well He
 

Microsoft AJAX Library - Object-Oriented JavaScript

Object Oriented JavaScript Objects and classes are implemented differently in JavaScript than in languages such as C VB NET Java or C However when it comes to using them you ll feel on familiar ground You create objects using the new operator and you call their methods or access their fields using t
 

Concepts of Object-Oriented Programming

Object Oriented JavaScript In this chapter you ll learn about OOP Object Oriented Programming and how it relates to JavaScript As an ASP NET developer you probably have some experience working with objects and you may even be familiar with concepts such as inheritance However unless you re already a
 

ERP Operation and Control

ERP Operation and Control The selection of the most suitable management system is it a difficult decision to make but once it is decided the next step is the operation and maintenance of ERP It is necessary to know well all the capacities and abilities in order to exploit the system to its fullest e
 

SOA Definitions and Certification

SOA Definitions and Certification Service Oriented Architecture is a design that enables Business and computational resources to be linked together on demand as a means of achieving the results desired for service consumers which may be end users or other services Service Oriented Architecture has
 

ERP: More than a Sales Solution

ERP More than a Sales Solution In this globalized world ERP is no longer just a competitive advantage It is an important requirement for every enterprise Many specialists argue that ERP is completely necessary to deal with businesses in every corner of the market This is because ERP does not work in
 

Object-Oriented Client-Server Internet

Object Oriented Client Server Internet OCSI Environments as IT Infrastructure Client Server Basics Object Oriented Client Server Internet OCSI environments provide the IT infrastructure for supporting OCSI applications For our purposes infrastructure refers to operating systems networks middleware
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape