Grade Details – All Questions
Question 1. Question : (TCO 4) What does a relational database use to uniquely identify each row in a table?

Student Answer: Trigger variable

View variable

Primary key

Host JOIN

Instructor Explanation: Chapter 12, p. 373

Points Received: 3 of 3
Comments:

Question 2. Question : (TCO 4) A _____ in a database can combine two or more tables together.

Student Answer: trigger

view

primary key

join

Instructor Explanation: Chapter 12

Points Received: 3 of 3
Comments:

Question 3. Question : (TCO 4) When you use the Configure Data Source wizard to define the data you want to retrieve from a database, you can _____.

Student Answer: select just one table with all of its columns

select one or more tables with all of their columns

select just one table and just the columns that you want

select one or more tables with just the columns that you want from each table
Instructor Explanation: Chapter 13, p. 409

Points Received: 3 of 3
Comments:

Question 4. Question : (TCO 4) The information that’s displayed in a DataList control is defined by _____.

Student Answer: Query Builder

Solution Explorer

DataAdapter

templates

Instructor Explanation: Chapter 13, p. 421

Points Received: 3 of 3
Comments:

Question 5. Question : (TCO 5) A field in a GridView control that contains one or more buttons is called a _____ field.

Student Answer: command

edit

void

Tree View

Instructor Explanation: Chapter 14, p. 459

Points Received: 3 of 3
Comments:

Question 6. Question : (TCO 5) _____ is the ability for the GridView to display data one page at a time.

Student Answer: Referencing

Block recording

Paging

Locking

Instructor Explanation: Chapter 14, p. 459

Points Received: 3 of 3
Comments:

Question 7. Question : (TCO 5) Which of the following statements sets the value of an insert parameter named LastName for a data source named SqlDataSource1 to the value of the Text property of a control named txtLastName.

Student Answer: SqlDataSource1.InsertParameters[“LastName”].DefaultValue = txtLastName.Text;
SqlDataSource1=txtLastName.Text;

Sql.InsertParameters[“LastName”].DefaultValue = txtLastName.Text;
SqlDataSource1.InsertParameters[“LastName”] = txtLastName.Text;
Instructor Explanation: Chapter 14, p. 463

Points Received: 3 of 3
Comments:

Question 8. Question : When you develop an application using a 3-layer architecture, the layer that provides the user interface is called the _____ layer.

Student Answer: Presentation

Middle/Business

Data

Solution

Instructor Explanation: Chapter 17, p. 533

Points Received: 3 of 3
Comments:

Question 9. Question : (TCO 5) Which of the following methods do you use to read the next row from a SqlDataReader object?

Student Answer: Next

ReadNext

Read

NextRow

Instructor Explanation: Chapter 17, p. 555

Points Received: 3 of 3
Comments:

Question 10. Question : (TCO 5) Displaying data in .NET requires what three objects?

Student Answer: Connection, query, dataset

Connection, query, data field

Server, client, application

Connection, adapter, dataset

Instructor Explanation: Lecture

Points Received: 3 of 3
Comments: