ADO .Net Quiz 2

Description: ADO .Net Quiz 2
Number of Questions: 16
Created by:
Tags: .net ado
Attempted 0/16 Correct 0 Score 0

Which database is the ADO.NET SqlConnection object designed for?

  1. Access

  2. Microsoft SQL Server

  3. MySQL

  4. Oracle

  5. None of the above.


Correct Option: B

Which is not a tab on the DataLink Property window?

  1. Advanced

  2. All

  3. Adapter

  4. Connection

  5. Provider


Correct Option: C
  1. Database login

  2. Database name

  3. Database type

  4. Both a and b.

  5. All of the above.


Correct Option: D
  1. an adapter object.

  2. a connection object.

  3. a database object.

  4. a dataset object.

  5. None of the above.


Correct Option: B
  1. Use SQL statements.

  2. Create new stored procedure.

  3. Use existing stored procedure.

  4. Both a and b.

  5. All of the above.


Correct Option: A
  1. OleDbDataAdapter

  2. SQLDataAdapter

  3. QueryDataAdapter

  4. Both a and b.

  5. All of the above.


Correct Option: C
  1. Adapter object

  2. Connection object

  3. Database object

  4. Dataset object

  5. None of the above.


Correct Option: A

Which is the appropriate prefix for a Dataset object?

  1. da

  2. das

  3. dat

  4. ds

  5. dst


Correct Option: D
  1. Dataset

  2. DataAdapter

  3. Connection

  4. Both a and b.

  5. All of the above.


Correct Option: A

What is the proper code to put data into the dataset called CustomerDataset using the CustomerDataAdapter object?

  1. CustomerDataset.Fill(CustomerDataAdapter)

  2. CustomerDataAdapter.Fill(CustomerDataset)

  3. CustomerDataset.Load(CustomerDataAdapter)

  4. CustomerDataAdapter.Load(CustomerDataset)

  5. None of the above.


Correct Option: B

Which object contains the Position property of the current record in a dataset?

  1. BindingContext

  2. BindingData

  3. DataBinding

  4. DataBound

  5. DataContext


Correct Option: A

The first record in a dataset has a position property of:

  1. zero

  2. one

  3. any value defined by the programmer

  4. Both a and b

  5. All of the above


Correct Option: A

Which below is specified by the DataMember Property?

  1. Connection object

  2. DataAdapter object

  3. Database field

  4. Database table

  5. Dataset object


Correct Option: D
  1. Connection object

  2. DataAdapter object

  3. Database field

  4. Database table

  5. Dataset object


Correct Option: E

Which is a property of the DataGrid control?

  1. DataMember

  2. DataSource

  3. DataQuery

  4. Both a and b.

  5. All of the above.


Correct Option: D
- Hide questions