A.QueryString
2. Which of the following codes retrieves the number of items in the control?
- int count = objlstCountries.ItemCount;
3. Which of the following codes correctly removes the item named StudentsDataTable from the cache ?
- Cache.Remove("StudentsDataTable");
4. The ......element in the Web.config file stores the connection string.
A.connectionStrings
5. Which approach specifies the location of output cache using the Location attribute of @OutputCache directive?
A.Declarative approach
6. Items stored on the cache are removed using the....... method.
- Cache.Remove()
7. Which of the following statements about untyped datasets are true?
- Untyped datasets require you to create the schema for the dataset.
- The NewRow() method is used to add rows into an untypted DataTable that is part of an untyped dataset.
8. How many instances of the Cache class representing a Cache object Web application?
A.One
9. A user control is cached by including an ....... directive in the .ascx file of control?
A.@OutputCache
10. Which of the following statement correctly describe the usage of the XmlReader.ReadString() method ?
- It reads the content of an element or text node as a string.
11. Which of the following techniques can be used to add parameters queries as design time?
- Using Configure Data Source dialog box
- Using markup elements such as
and .
A.1 and 2
12. You want to add SQL dependency for a connection string ... database should be polled every 7 minutes. Which one.....you to accomplish this?
A. (pollTime tính bằng millisecond tương đương 60 giây là 60000 mili giây)
13. Which property of data source controls retrieves the time in seconds for which the control caches the data ?
A.CacheDuration
14. Which of the following Boolean properties in a SiteMapDataSource control sets or gets a value to indicate whether the start node is displayed?
A.ShowStartingNode
15. .................. represents a query or a command that is to be executed by a data source
A.Command
16. ......... is a mobile control that is exclusively designed for mobile data access and can display a list as well as a detail view.
A.ObjectList
17. ....... is a group of class that enables the developers to connect to RDBMS
A.ADO.NET
18. Which of the following codes retrieves the connection string from....
- String conString = WebConfigurationManager.ConnectionStrings["TestConnection"].ToString();
19. Which of the following dataset class represents the data type of Column of DataTable ?
A.DataColumnCollection
20. Which of the following classes stores the frequently used application for a Web application?
- System.Web.Caching
21. Which of the following are the new features provided in ASP.NET 2.0 ?
- Control that access data from the back-end database.
- Control that can display data in various formats.
- Direct connections can be established as a local file to an SQL Express database.
A.2 3
22. Which property of the GridView control regarding paging functionality indicates whether the paging buttons are displayed?
- PagerSettings.PreviousPageText
B. PagerSettings.Visible
23. ...... is a process by which the data in the control belonging to the UI have a direct link to the data in the database.
A.Data binding
24. The ....... method of a SqlCommand object returns an instance of SqlDataReader class .
- ExecuteReader()
25. Which of the following are valid events of DataList control ?
- SelectedIndexChanged
B. UpdateCommand
- EditCommand
26. Which event is raised when each item in a mobile List control is being data bound?
A.ItemDataBind
27. Which property of @OutputCache directive creates a new version of a page if the request for the same page comes from a different browser ?
A.VaryByCustom
28. The.....object is used to fetch and update the data from the database.
A.DataSet
29. The.... data source control enables you to work with ASP.NET site navigation through XML-based site maps.
A.SiteMapDataSource
30. Which of the following represents the correct directive to be used when working with data sources associated with an OracleConnection ?
- using System.Data.Odbc;
31. The..... Datasets require the user to hard-code the schema of the dataset.
A.untyped
32. Which of the following codes correctly clears the content of the dataset and fills it with rows of data ?
D. dsetFootwear.Tables["Footwear"].Clear();
sdaFootwear.Fill(dsetFootwear,"Footwear");
33. Which one of the following statement stating the characteristics of OleDbDataReader class is true ?
- It reads a stream of rows from a data source that is associated with an OleDbConnection.
34. Which of the following classes generates dynamic customized views of your data which you can then display and manipulate?
A.DataView
35. Which of the following are the ways to add items to a cache?
- Using key/value pairs
- Using Cache.Insert() method
- Using Cache.Add() method
A.1 2
36. The ...... property specifies whether the display of records will be repeated horizontally or vertically.
A.RepeatDirection
37. Which of the following Web server control presents the data in a list?
- DataControl
B. DataList
38. Following is a series of steps to bind a data source control to a data-bound control on a Web form .
- Bind the data source control to a data-bound control.
- Add the data source control to the Web form.
- Configure the properties of the data source control.
- Select the kind of data source control.
- Select the data provider.
A.4 5 2 3 1
39. Which of the following codes will allow you to fill an untyped dataset named dsetEmplyees with the data from the Employees table in a SQL Server 2005 database?
SqlConnection sqlconPubs = new SqlConnection("Data Source=10.2.1.51;Initial Catalog=pubs;User ID =sa;Password=playware");
SqlDataAdapter sdaEmployee = new SqlDataAdapter("select * from Employees",sqlconPubs);
DataSet dsetEmployee = new DataSet();
sdaEmployee.Fill(dsetEmployee,"Employees");
