Help with online Microsoft test

[badgers]

I have taken the microsoft self evaluation test.
I don't know the answers to the following questions and I was wondering if someone could help me.
what is the right answer? and maybe why?

1)A Microsoft(R) Windows(R) Forms application connects to a 
Microsoft SQL Server(TM) 2000 data source.
Which code fragment illustrates the preferred method 
of creating the connection to the SQL server?
 	Dim cn As OleDbConnection = New _ OleDbConnection("Provider=MSDAORA.1;User ID=MyID;Password=MyPassword;Data Source=CUSTOMER")
 	Dim cn As OleDbConnection = New OleDbConnection("Provider _ =Microsoft.Jet.OLEDB.4.0;Data Source=\applications\customer.mdb")
 	Dim cn As OleDbConnection = New OleDbConnection("Provider=SQLOLEDB;Data Source=APPLICATION;Initial Catalog=customer;Integrated Security=True")
 	Dim cn As SqlConnection = New SqlConnection("Data _ Source=APPLICATION;Initial Catalog=customer;Integrated _ Security=SSP1")





2)You have added a DataGrid control to a Microsoft(R) Windows(R) form that displays all 
records from a DataSet. What step is necessary to enable the user to make changes to 
the records that the DataGrid control displays?
 	Modify the RowChanging event.
 	Modify the ColumnChanging event.
 	Modify the GotFocus event.
 	Modify the ColumnChanged event.
 	Modify the OnEditCommand method.
 	Modify the RowChanged event




3)You place a ListBox control on a Microsoft(R) Windows(R) form that will display customer names. 
When the user selects a customer name, a DataGrid control displays the associated customer orders. 
What property or properties do you use to bind the ListBox control to the data source?
 	The DisplayMember and DataSource properties
 	The DataMember and DataSource properties
 	The DataSet and DataSource properties
 	The DataBinding property








4)You are part of a team that is developing a database-driven Microsoft(R) 
Windows(R) application. You are looking through code from one of your coworkers, 
and you see the SqlCommand command. 

What can this command do? (Select all that apply.)


 	Execute stored procedures in a Microsoft SQL Server(TM) data source.
 	Manage the interaction between a DataSet and the data in a Microsoft SQL Server(TM) data source.
 	Execute SQL statements in a Microsoft SQL Server(TM) data source.
 	Read a forward-only stream of data from a Microsoft SQL Server(TM) data source.
 	Populate a DataSet from the data in a Microsoft SQL Server(TM) data source











5)You are using Microsoft(R) Visual Studio(R) .NET to develop a
Microsoft Windows(R) 
application for a public library. Your 
application uses a DataSet named 
BookList that is populated from
 a Microsoft SQL Server(TM) database. On your application's main
 form, you would like to add a list box that displays in
 descending order the titles of the books that were published in
 Texas. 

Which of the following code fragments should you use to achieve your goal?
 	Me.DataGrid1.RowFilter = "State = 'TX'" Me.DataGrid1.DataMember = "Title Desc" Me.DataGrid1.DataSource = Me.BookList
 	Me.DataGrid1.Sort = "State = 'TX'" Me.DataGrid1.DataMember = "Title" Me.DataGrid1.DataSource = Me.Booklist
 	Me.DataView1.RowStateFilter=System.Data.DataViewRowState.OriginalRows Me.DataView1.Sort = "State = 'TX'" Me.DataView1.Table = Me.BookList.Titles
 	Me.DataView1.RowFilter = "State = 'TX'" Me.DataView1.Sort = "Title Desc" Me.DataView1.Table = Me.BookList.Titles

[RobDog888]

Is this a public non-paid ms test?

[badgers]

this is just a self assesment located here
http://assessment.learning.microsoft.com/test/home.asp
it is set up to help me figure out what classes and books I should read.
if you take the assesment you may not get these same questions.
sorry if this has upset anyone. I have already finished the assesment and these were the questions that I got wrong.

[badgers]

My answers for
1)B
2)E
3)B
4)Never heard of sqlcommand
5)D

[badgers]

regarding question #2 I set up a datagrid1 control and tied it do an ADODB control as the data source. I can't find any of the events listed as possible choices and I find that I don't need to do anything to allow the user to make changes.

I have to set something to keep them out...

[kfcSmitty]

pretty sure the answer to 1 is

Dim cn As OleDbConnection = New OleDbConnection("Provider=SQLOLEDB;Data Source=APPLICATION;Initial Catalog=customer;Integrated Security=True")

2 -- Not sure

3 -- C I think

4 -- no idea

5 -- no idea


I wonder how well I did :/..failed atleast lol

[badgers]

my research seems to lean to
Dim cn As SqlConnection = New SqlConnection("Data _ Source=APPLICATION;Initial Catalog=customer;Integrated _ Security=SSP1")

integreated security is not a true or false setting and SSPI stands for Security Support Provider Interface and microsofts web site called it the "preferred" authentication method. So I think that is correct.


PS, I have recieved a ton of PM's about if I am cheeting.
I already completed the self evaluation, I got these wrong and I wanted to know what the right answer is.
Moderators, I am not trying to upset anyone, if you want to delete this post.

[conipto]

This is .NET, so SQLConnection, SqlDataAdapter and SqlCommand are typically the preffered methods to access SQL server databases. They are used pretty much the same as OLEDBConnection, OLEDBDataAdapter and OLEDBCommand. I'm not sure why they differentiated SQL Server, other than self-product-promotion

Bill