State whether each of the following is true or false. If false, explain why.

1. Providing the same value for a foreign key in multiple rows causes the DBMS to report
an error.
2. Providing a foreign-key value that does not appear as a primary-key value in another
table is an error.
3.The result of a query can be sorted in ascending or descending order
4. A BindingNavigator object can extract data from a database
5. A DbContext automatically saves changes made back to the database


1. False. Multiple rows can have the same value for a foreign key. Providing the same
value for the primary key in multiple rows causes the DBMS to report an error, because
duplicate primary keys would prevent each row from being identified uniquely.
2. True
3. True
4. False. A BindingNavigator allows users to browse and manipulate data displayed by
another GUI control. A DbContext can extract data from a database.
5. False. You must call the SaveChanges method of the DbContext to save the changes
made back to the database.

Computer Science & Information Technology

You might also like to view...

List the nine organizational metaphors and the hypothesized success of each type of system given their presence.

What will be an ideal response?

Computer Science & Information Technology

Immediately after inserting an Excel spreadsheet into a PowerPoint presentation the ________ appear(s) at the top of the screen

A) Word Ribbon B) PowerPoint and Excel Ribbon C) Excel Ribbon D) PowerPoint Ribbon

Computer Science & Information Technology

The credit department

A. prepares credit memos when goods are returned B. approves credits to accounts receivable when payments are received C. authorizes the granting of credit to customers D. none of the above

Computer Science & Information Technology

After typing a URL in the Address bar, press the Go button to open the Web site. 

Answer the following statement true (T) or false (F)

Computer Science & Information Technology