1)

What does the following LINQ query return when it is executed? Dim exp2-Aggregate student In SchoolDataSet.Students Where student.UnitsCompleted> 50 Into Count O Number of students who have completed more than 50 units O Number of students in the Students table O A set of student records whose UnitsCompleted value is greater than 50 O A set of student records in the Students table The records already cached in a DataSet will be lost when O the DataSet application terminates D the connection to the database is lost the database from which the records were retrieved becomes unavailable The user of the application steps away from the computer Which essential statement is missing from the following save procedure in an untyped DataSet application (underscores indicate that th statement continues at the next line)? The save procedure is intended to save changes to the database. (Assume that northwindDataAdapter has been property initialized with an open connection and a valid SELECT SQL statement, write down the missi statement) Dim northwindCommandBuilder As New OleDbCommandBuilder(northwindDataAdapter) northwindDataAdapter.InsertCommand northwindCommandBuilder.GetinsertCommando northwindDataAdapter.DeleteCommand northwindCommandBuilder.GetDeleteCommand0 northwindDataAdapter.UpdateCommand northwindCommandBuilder.GetUpdateCommando D northwindCommandBuilder.update) O northwindDataAdapter read) northwindDataAdapter fillinorthwindDataSet, "suppliers" northwindDataAdapter updatelnorthwindDataSet. "suppliers What does the following LINQ query return when it is executed? Dim exp2-Aggregate student In SchoolDataSet.Students Where student.UnitsCompleted> 50 Into Count O Number of students who have completed more than 50 units O Number of students in the Students table O A set of student records whose UnitsCompleted value is greater than 50 O A set of student records in the Students table The records already cached in a DataSet will be lost when O the DataSet application terminates D the connection to the database is lost the database from which the records were retrieved becomes unavailable The user of the application steps away from the computer Which essential statement is missing from the following save procedure in an untyped DataSet application (underscores indicate that th statement continues at the next line)? The save procedure is intended to save changes to the database. (Assume that northwindDataAdapter has been property initialized with an open connection and a valid SELECT SQL statement, write down the missi statement) Dim northwindCommandBuilder As New OleDbCommandBuilder(northwindDataAdapter) northwindDataAdapter.InsertCommand northwindCommandBuilder.GetinsertCommando northwindDataAdapter.DeleteCommand northwindCommandBuilder.GetDeleteCommand0 northwindDataAdapter.UpdateCommand northwindCommandBuilder.GetUpdateCommando D northwindCommandBuilder.update) O northwindDataAdapter read) northwindDataAdapter fillinorthwindDataSet, "suppliers" northwindDataAdapter updatelnorthwindDataSet. "suppliers