Question types

Start with

Question limit

of 50 available terms

Print test

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.
  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 %
  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.
  44. ar INVENTORY
  45. as WROTE.
  46. at Underscore ( _ )
  47. au Commission rate.
  48. av Column