Chapter 12 Test Bank Docx Databases

Starting Out with Visual C#, 5e (Tony Gaddis)

Chapter 12 Databases

TRUE/FALSE

1. If an application needs to store only a small amount of data, sequential and binary files are efficient and easy to use.

2. When developing applications that work with an intensive amount of data most developers prefer to use a database management system.

3. Rather than retrieving or manipulating the data dirctly, applications send instruction to the DBMS and the DBMS carries out those instructions and sends the results back to the application.

4. The application handles the mechanical details of reading, writing, and searching for data in a database.

5. There are numerous DBMSs in use today and Visual C# can interact with many of them.

6. Data stored in databases is organized into one or more tables.

7. Data stored in a database table is organized into rows and columns.

8. Each column in a table must have a name.

9. When you create a database table, you must specify a data type for each column.

10. The table row designated as the primary key must hold a unique value for each column.

11. The table column designated as the primary key must hold a unique value for each row.

12. If a particular column is not allowed to be null, any time you add a row of data to the table, the DBMS will require a value for the column.

13. A .NET application requires a set of special components that let it connect to and work with a database.

14. When you use Visual Studio to create a database the database file will be created in the project folder.

15. Data-bound controls automatically display data from a data source and can be used to modify the data they are bound to.

16. When you place a data-bound control on a form, you should keep in mind that Visual Studio does not automatically generate the code needed for the control to display any data from the database table.

17. Rather than displaying multiple rows at once, a Details view lets the user see one row at a time.

18. Each subsequent time an application runs, it connects to the copy of the database in the output folder, rather than the project folder.

19. It is possible to change the type of control that a column is bound to in a Details view.

20. To bind a ListBox control to a column, you must set either the DataSource property or the DisplayMember property but not both.

21. When you make changes to a database table in one form, the changes automatically appear in other forms that connect to the same table using their own datasets.

22. SQL is a general purpose programming language which can be used to write applications.

23. SQL does not support relational operators.

24. The "equal to" and "not equal to" operators in SQL are different from those in C#.

25. In SQL, if you need to include a single quote as part of a string, you write two consecutive single quotes in its place.

26. You can add your own SQL queries to a table adapter and call them from your C# code.

27. SQL provides several functions for performing calculations.

28. SQL uses database mnemonics to construct statements which are also known as table adapter queries.

29. The Not operator can be used in SQL to disqualify a character pattern in a search criteria.

30. The Desc operator can be used to sort the results of a SQL Select query in descending order.

31. In SQL the asterisk symbol (*) is used as a wildcard to represent a single character.

MULTIPLE CHOICE

1. A(n) __________ is software specifically designed to store, retrieve, and manipulate large amounts of data in an organized and efficient manner.

2. Once data items are stored using a database management system, applications may be written in __________ to communicate with the DBMS.

3. The DBMS works directly with the data and sends the results of operations back to the __________.

4. __________ is automatically installed on your system when you install Visual Studio.

5. A DBMS stores data in a __________.

6. In a database, each __________ holds a collection of related data items.

7. A __________ is a complete set of information about a single item in a table.

8. When specifying a data type for the columns in a database, the data types you can choose from are provided by the __________.

9. Most database tables have a(n) __________ which is a column that can be used to identify a specific row.

10. If a column contains no data, it is said to be __________.

11. A(n) __________ is a column that contains unique values generated by the DBMS, usually using a counter.

12. Excel spreadsheets and databases are examples of __________ which contain data that the application can work with.

13. A __________ gets a copy of a table from the table adapter and keeps the copy of the table in memory.

14. A __________ connects to a data source and can retrieve and update data from a table in a data source.

15. A __________ is a component that can connect user interface controls directly to a dataset.

16. A __________ is a user interface control that is connected to a data source.

17. The __________ can display an entire database table in a scrollable grid on an application's form.

18. When an application runs for the first time, Visual Studio copies the database file from the project's folder to the project's __________ folder which is in the bin/Debug folder.

19. When you click on the __________ in a data-bound control, a tasks panel will appear, giving you a number of options you can perform.

20. The __________ identifies the table from which the data-bound control will get its data.

21. The __________ identifies a column from the table to display in a ListBox control.

22. When working with data-bound controls on multiple forms, you can make sure that a dataset contains a current copy of the data by calling the table adapter's __________ method.

23. SQL, which stands for __________, is a standard language for working with database management systems.

24. In SQL you use keywords to construct statements which are also known as __________.

25. In SQL you use the __________ to retrieve rows in a table.

26. When you use the __________ in a Select statement, only the rows that meet the search criteria are returned.

27. If you wish to sort the results of a SQL Select query you can use the __________.

28. In SQL the __________ can be used to search for a substring.

29. In SQL the __________ is used as a wildcard character and can be used to represent any sequence of zero or more characters.

30. In SQL the __________ requires that both search criteria be true in order for a row to be qualified as a match.

31. In SQL the __________ calculates the average value in a particular column.

32. In a SQL statement, a query parameter variable begins with the __________.

33. SQL provides the __________ function to determine the number of matching rows in a table.

34. In SQL strings are enclosed in __________.

35. A(n) __________ is a SQL statement stored in a table adapter object which can be executed simply by calling a method.

36. A(n) __________ is a file, ending with the .xsd extension, which describes the contents of a dataset.