Advanced Web Programming MCQ's | Unit 4 AWP MCQ | WaoFamHub

Advanced Web Programming MCQ's With Answers

AWP UNIT 4 MCQ's 

1. In disconnected data access, _________ object is used to manage the connection with the data source. 

1. DataReader 
2. DataAdpater
3. DataSet
4. SqlCommand

Ans : DataAdpater

2. In disconnected data access model ________ is used to keep copy of data in memory

1. DataReader
2. Database 
3. DataSet 
4. DataAdpater

Ans : DataSet

3. Which of the following is not an ADO.NET object? 

1. Connection 
2. Command 
3. DataReader 
4. Table

Ans : Table

4. ______ is standard data access language used to interact with relational databases.

1. XML 
2. SQL 
3. T-SQL 
4. XSL

Ans : T-SQL

5. The data binding is perform ____________. 

1. Before page init 
2. After page render
3. During page render 
4. Before page render

Ans : Before page render

6. Which of the following is the correct syntax of single value data binding?

1. <% expression %>
2. <%# expression %>
3. <%# expression #%> 
4. <% expression -->

Ans : <%# expression %>

7. If you are using DataSet and you have to display the data in soted order then what will you do? 

1. Use Sort() method of DataTable 
2. Use Sort() method of DataSet 
3. Use DataView object with each sort. 
4. Use DataPaging and sort data

Ans : Use DataView object with each sort. 

8. How do you execute multiple SQL statements using a DataReader? 

1. Call the ExecuteReader method of two Command objects and assign the results tothe same instance of a DataReader 
2. Set the Command.CommandType property to multiple result sets 
3. Call the ExecuteReader method of a single Command object twice 
4. Set the Command.CommandText property to multiple SQL statements delimited by a semicolon.

Ans : Set the Command.CommandText property to multiple SQL statements delimited by a semicolon.

9. Which property can be used to configured the numbers and dates using a format string.

  

1. FormatSting 
2. DataFormatingString 
3. DataFormate 
4. DataFormatSring

Ans : DataFormatingString

10. Which property is perticularly used to specify the data source object to which the control link? 

1. Bind 
2. DataSource 
3. DataTextField 
4. DataValueField

Ans : DataSource

11. ______object can hold more than one rowset from the same data source and the relationships between them. 

1. DataReader 
2. DataSet  
3. OleDB connection  
4. DataAdapter

Ans : DataSet

12. To enables the inserting a row in details view _________________ property is to be true.

1. AutoGenerateInsertButton 
2. AutoInsertButton 
3. InsertButton 
4. GenerateInsertButton

Ans : AutoGenerateInsertButton

13. Optimistic Concurrency control is based on______________. 

1. Record Number 
2. Record ID
3. RecordIndex 
4. Record Version

Ans : Record Version

14. Which of the following is not DataReader mothod?

1. NextResult() 
2. GetName() 
3. GetValue()
4. GetDataType()

Ans : GetDataType()

15. Which of the following is not a connection string property?

1. Data Source 
2. Initial Catalog 
3. Database Name 
4. Integrated Security

Ans : Database Name 

16. ____________works in a connected environment and supports forward-only, read-only access to data in the data source. 

1. DataAdapter
2. DataReader 
3. DataSet
4. DataTable

Ans : DataReader

17. The value of the data-binding-expression will be substituted when you call ____________ method for the page. 

1. Construct() 
2. DataBind() 
3. Eval(String) 
4. LoadControl(String)

Ans : DataBind()

18. In repeated-value data binding ____________method activates the binding.

1. Bind(); 
2. Binding() 
3. Refresh() 
4. DataBind()

Ans : DataBind()

19. Linking __________ control to a data source is an example for repeated-value binding.

1. TextBox
2. Label 
3. ListBox 
4. LinkButton

Ans : ListBox

20. Which of the operation is not supported by GridView? 

1. Select 
2. insert 
3. Edit 
4. Delete

Ans : insert

21. Which of the following is not a valid templates for FormView? 

1. ItemTemplate 
2. EditItemTemplate 
3. InsertItemTemplate 
4. DeleteItemTemplate

Ans : DeleteItemTemplate

22. _____________ is the process how the user interface controls of a client application are configured to retrieve from, or update data into, a data source. 

1. Auto generation of rows 
2. Paging 
3. Data binding 
4. Data formatting

Ans : Data binding 

23. ___________ feature of FormView support backward and forward traversal.   

1. Data binding 
2. BoundField 
3. Paging 
4. TemplateField

Ans : Paging

24. ___________ control displays data provided by a data source in a tabular format.

1. DetailsView
2. GridView 
3. FormView 
4. ListView

Ans : GridView

25. Which of the following is not a property of a GridView? 

1. AutoGenerateInsertButton
2. AutoGenerateDeleteButton
3. AutoGenerateEditButton
4. AutoGenerateSelectButton

Ans : AutoGenerateInsertButton

26. Which of the following is not a style element of a GridView? 

1. RowStyle 
2. SelectedRowStyle 
3. ItemStyle 
4. DataStyle

Ans : DataStyle

27. Which of the following method is wrong for adding a select button for each row of a GridView? 

1. By adding a BoundField with HeaderText = "Select"  
2. By adding a CommandField column with the ShowSelectButton property set to true. 
3. By adding a ButtonField column with the CommandName property set to “Select”. 
4. By setting AutoGenerateSelectButton attribute of GridView to True.

Ans : By adding a BoundField with HeaderText = "Select"  

28. Which of the following is not an ADO.NET class for SQL Server data provider? 

1. sqlConnection 
2. sqlCommand 
3. sqlDataReader
4. sqlTable

Ans : sqlTable

29. Sqlcomma Do class is present in _________________ namespace. 

1. System.Web 
2. System.Data.SqlTypes    
3. System.Data                      
4. System.Data.SqlClient   

Ans : System.Data.SqlClient

30. Which of the following is not an ADO.NET class for SQL Server provider?

1. sqlConnection 
2. sqlCommand 
3. sqlDataReader 
4. sqlTable

Ans : sqlTable

    

<< AWP Unit 3                             AWP Unit 5 >>