.Which of the following method of the command object is best suited when you have aggregate functions in a SELECT statement?

  1. Home

- Online Exam Test Papers | - MCQs[multiple choice questions and answers ] | - Mock Test Papers | - Practice Papers | - Sample Test Papers |

Question:
.Which of the following method of the command object is best suited when you have
aggregate functions in a SELECT statement?

1.ExecuteScalar

2.ExecuteReader

3.ExecuteNonQuery

4.None of the mentioned

More MCQS Questions and answers

  1. .A developer wanted to achieve graphics in his display using ASP.NET. Which of the following web controls are available in ASP.NET to achieve the above?
  2. .Give One word: Common type system is built into which of the following
  3. .GIVE ONE WORD: In .NET the operation of reading metadata and using its contents is known as
  4. .The .NET Framework provides a runtime environment called
  5. .What tags one need to add within the asp:datagrid tags to bind columns manually.
  6. .Which of the following denote value that can be taken by Cache-Control of ASP.NET?
  7. .Which of the following method is used to obtain details about information types of assembly?
  8. .Which of the following method of the command object is best suited when you have aggregate functions in a SELECT statement?
  9. An e-shopping web portal has a shopping basket control where the list of available items meant for shopping is displayed.The item list remains unchanged for all users irrespective of scenerios and it always populates from a database look up table every time when the page is loaded.For getting better performance and memory effectiveness,it is appropriate to store the data in
  10. Between Windows authentication and SQL Server Authentication, SQL Server authentication is the trusted one.
  11. By default, the pooling property with connection string is set as True/False
  12. DataAdapter object populates a DataSet and resolves updates with the data source. Yes or No?
  13. Find the term: The .NET framework which provides automatic memory management using a technique called.
  14. Forms based authentication is otherwise called in ASP.NET as Cookie Authentication because Forms authentication uses cookies to allow applications to track users throughout their visit
  15. I have an ASP.NET application. I have a page loaded from server memory. At this instance which of the following methods gets fired
  16. If in an ASP.NET application one want to create http handlers which of the interface is used
  17. If one has two different web form controls in a application and if one wanted to know whether the values in the above two different web form control match what control must be used?
  18. In my .NET Framework I have threads. Which of the following denote the possible priority level for the threads?
  19. List the types of Authentication supported by ASP.NET
  20. Suppose a .NET programmer wants to convert an object into a stream of bytes then the process is called
  21. Suppose one wants to modify a SOAP message in a SOAP extension then how this can be achieved. Choose the correct option from below
  22. The feature in ASP.NET 2.0 that is used to fire a normal postback to a different page in the application is called
  23. The namespace within the Microsoft .NET framework which provides the functionality to implement transaction processing is
  24. The technique that allow code to make function calls to .NET applications on other processes and on other machines is
  25. There are two classes named TEACHER and STUDENTS.When TEACHER goes out of the class,STUDENTS should make noise.The scemario best befits to the concept of "association of two classes behavior-where one class watches another class for a behavior change and triggers an action from inside itself based on the behavior change".Which pattern of design it could be?
  26. To improve the performance and scalability of your .NET application. Which one of the following techniques would help?
  27. To perform asynchronous data access, what must be added to the connection string?
  28. When you create a relationship between tables in ADO.NET DataSet
  29. Which method is used to commit all changes in the DataSet or DataTable?
  30. Which method is used to Get a value indicating whether the column contains nonexistent or missing values?
  31. Which of the following can be used to add alternating color scheme in a Repeater control?
  32. Which of the following denote the web control associated with Table control function of ASP.NET?
  33. Which of the following illustrates the benefit of ADO.NET?
  34. Which of the following is a DataView method?
  35. Which of the following is FALSE?
  36. Which of the following is not the method of DataAdapter?
  37. Which of the following is not true about ADO.NET?
  38. Which of the following is not true for ADO.NET DataSet?
  39. Which of the following is the event that is exposed by the DataTable object?
  40. Which of the following is the method provided by the DataSet object to generate XML?
  41. Which of the following is the object of .NET data provider?
  42. Which of the following must be done in order to connect data from some data resource to Repeater control?
  43. You are deploying a Web site to a server managed by a hosting company. The only access you have to the server is through FTP. You need to precompile and deploy the Web site without its source files. What should you do?
  44. You are working with a DataSet and want to be able to display data, sorted different ways. How do you do so?
  45. You are working with a team of developers on a Web site. You copy the Web site from the staging server to work on it locally. While making changes, you create new C# source code files and delete old ones. You need to ensure that your changes propagate to the staging server without affecting any files that you have not modified. Which tool should you use?
  46. You create a large, n-tier Web application that has a custom event tracking system. You need to create a custom event type that enables your event tracking system to record all relevant event details for all types of events. The events must be stored in Microsoft SQL Server. From which base type should your custom event type inherit?
  47. You create a Web Form. You need to add controls that use adaptive rendering to display content.The type of content rendered must depend on the device that is requesting the page. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
  48. You develop a Web application that contains two master pages. You need to dynamically set the master page when a user views pages in the application. What should you do?
  49. You have a Web application that is configured for personalization. You need to access personalization data from one of the pages of the Web application by using the minimum amount of administrative effort. What should you do?
  50. Your team creates a Web site. The Web site needs to be deployed to a staging server for performance testing. You plan to make a number of performance enhancements and then retest.You need to compile and copy the Web site to the staging server. What should you do?
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!