48 Matching questions

1. Which of the following tables relates books to authors?
2. A field is another term for a(n)____
3. You indicate the end of a command by typing a____
4. The correct data type for the BALANCE column in the CUSTOMER table is ____
5. The ___ command defines a table's structure by listing its columns, data types, and column lengths.
6. The ____data type is use to store integers.
7. In relational database each ____ should be unique.
8. The REP table consists of the sales representatives number, last name, first name, address, total commission, and ___
9. The ____ wildcard symbol represents any individual character.
10. Which of the following is the primary key of the ORDER_LINE (ORDER_NUM, PART_NUM, NUM_ORDERED, QUOTED_PRICE) table?
11. In SQL for Orable and SQL Server, the ___ symbol is used as a wildcard to represent any collection of characters.
12. A relation is in ____ if it does not contain any repeating groups.
13. Each publisher has a ___ that uniquely identifies the publisher at Henry Books.
14. Each book at Henry Books is uniquely identified with a(n) ____
15. The ___ clause lets you group data on a particular column.
16. You use the ___ clause to list data in a specific order.
17. The ____ operator finds rows that do not contain null values in the specified column.
18. For any column whose data type is CHAR, values must be enclosed in _____
19. The ____ table indicates the number of copies of a particular book that are currently on hand at a particular branch of Henry Books.
20. You form compound conditions by connecting two or more simple conditions using the ____ operator.
21. In the SELECT clause, you can use the ____ symbol to indicate that you want to include all columns.
22. When you need to sort data on two columns, the less important column is called the ____ sort key.
23. A ____ file is a text file with a .sql extension that contains SQL commands.
24. To display all the rows and columns in a table, type the word SELECT, followed by (n)____, followed by the word FROM and then the name of the table containing the data you want to view.
25. Preceding a condition by the ____ operator reverses the truth of the original condition.
26. Each line in the Premiere Products order form contains a part number, the number of units of the ordered part, the quoted price, and ______
27. The process of determining the particular tables and columns that will comprise a database is known as____
28. When a script file contains more than one command, each command must end with a _____.
29. ____ is one of the categories of update anomalies.
30. To delete an entire table, use the ____ command and then re-create the table.
31. A(n) ____ is a characteristic of property of an entity.
32. Which of the following is a valid name for a table?
33. The ____ operator specifies a range of values in a condition.
34. You can use the ____ operator followed by a collection a values to provide a concise way of phrasing certain conditions.
35. The ___ field of the WROTE table of Henry Books indicates the order in which the authors of a particular are listed on the cover.
36. when you use the ____ function you can use the asterisk (*) to represent any column
37. Use the ____ date type for columns that contain letters and special characters and for columns that will not be use in calculations.
38. Which of the following operators can be used for a column computation?
39. Any column (or collection of columns) that determines another column is called a(n) ___
40. ___ can occur then there is a column in a table that is dependent on only a portion of the primary key.
41. The ____ operator uses one or more wildcard characters to test for a pattern match.
42. The___ clause is used to restrict the groups that will be included.
43. The basic form of the SQL SELECT command is _____
44. The ____ function calculates a total of the values in a column.
45. A(n) ___ is the association between entities.
46. The ____ data type stores only the actual character string.
47. Which of the following command changes the value in a column?
48. In SQL, you use the ____ command to query a database.

1. a ASTERISK.
2. b NOT
3. c Semicolon
4. d second normal form
5. e script.
6. f Part description.
7. g Plus ( + )
8. h COUNT.
9. i HAVING.
10. j BETWEEN.
11. k LIKE.
12. l Determinant.
13. m VARCHAR.
14. n minor
15. o ORDER BY.
16. p CREATE TABLE.
17. q Semicolon.
18. r CHAR.
19. s DECIMAL.
20. t All of the above. (row,record,tuple)
21. u GROUP BY.
22. v SELECT
23. w %
24. x SELECT-FROM-WHERE
25. y All of the above (AND,OR,NOT).
26. z UPDATE.
27. aa IS NOT NULL
28. ab IN
29. ac DROP TABLE.
30. ad relationship.
31. ae Inconsistent data.
32. af Update anomalies.
33. ag TBL_1
34. ah CODE.
35. ai single quotation marks.
36. aj attribute.
37. ak database design
38. al SUM.
39. am INT
40. an code.
41. ao C) *
42. ap SEQUENCE.
43. aq ORDER_NUM ANDPART_NUM.
44. ar INVENTORY
45. as WROTE.
46. at Underscore ( _ )
47. au Commission rate.
48. av Column