NAME

Question types


Start with


Question limit

of 50 available terms

Print test

50 True/False questions

  1. Which of the following operators can be used for a column computation?Plus ( + )

          

  2. Each book at Henry Books is uniquely identified with a(n) ____CODE.

          

  3. The correct data type for the BALANCE column in the CUSTOMER table is ____DECIMAL.

          

  4. The ____ table indicates the number of copies of a particular book that are currently on hand at a particular branch of Henry Books.INVENTORY

          

  5. A ____ file is a text file with a .sql extension that contains SQL commands.script.

          

  6. The ____ data type stores only the actual character string.INT

          

  7. In SQL for Orable and SQL Server, the ___ symbol is used as a wildcard to represent any collection of characters.C) *

          

  8. Which of the following is the primary key of the ORDER_LINE (ORDER_NUM, PART_NUM, NUM_ORDERED, QUOTED_PRICE) table?ORDER_NUM ANDPART_NUM.

          

  9. Each line in the Premiere Products order form contains a part number, the number of units of the ordered part, the quoted price, and ______Part description.

          

  10. Which of the following command changes the value in a column?TBL_1

          

  11. Preceding a condition by the ____ operator reverses the truth of the original condition.BETWEEN.

          

  12. A relation is in ____ if it does not contain any repeating groups.second normal form

          

  13. Which of the following tables relates books to authors?WROTE.

          

  14. Each publisher has a ___ that uniquely identifies the publisher at Henry Books.COUNT.

          

  15. A field is another term for a(n)____SELECT-FROM-WHERE

          

  16. You use the ___ clause to list data in a specific order.ORDER BY.

          

  17. The ___ field of the WROTE table of Henry Books indicates the order in which the authors of a particular are listed on the cover.UPDATE.

          

  18. The ____data type is use to store integers.INT

          

  19. ____ is one of the categories of update anomalies.Inconsistent data.

          

  20. when you use the ____ function you can use the asterisk (*) to represent any columnCOUNT.

          

  21. In the SELECT clause, you can use the ____ symbol to indicate that you want to include all columns.C) *

          

  22. Any column (or collection of columns) that determines another column is called a(n) ___Determinant.

          

  23. In SQL, you use the ____ command to query a database.SELECT

          

  24. The ____ function determines the number of rows in a table.SUM.

          

  25. In relational database each ____ should be unique.INT

          

  26. The ____ operator specifies a range of values in a condition.BETWEEN.

          

  27. When you need to sort data on two columns, the less important column is called the ____ sort key.minor

          

  28. You form compound conditions by connecting two or more simple conditions using the ____ operator.All of the above (AND,OR,NOT).

          

  29. You can use the ____ operator followed by a collection a values to provide a concise way of phrasing certain conditions.IN

          

  30. The ____ function calculates a total of the values in a column.SUM.

          

  31. A(n) ____ is a characteristic of property of an entity.attribute.

          

  32. ___ can occur then there is a column in a table that is dependent on only a portion of the primary key.Update anomalies.

          

  33. You indicate the end of a command by typing a____Semicolon.

          

  34. When a script file contains more than one command, each command must end with a _____.Semicolon

          

  35. 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.Update anomalies.

          

  36. To delete an entire table, use the ____ command and then re-create the table.DROP TABLE.

          

  37. The ____ operator finds rows that do not contain null values in the specified column.BETWEEN.

          

  38. Use the ____ date type for columns that contain letters and special characters and for columns that will not be use in calculations.CHAR.

          

  39. The process of determining the particular tables and columns that will comprise a database is known as____HAVING.

          

  40. The___ clause is used to restrict the groups that will be included.VARCHAR.

          

  41. For any column whose data type is CHAR, values must be enclosed in _____SELECT-FROM-WHERE

          

  42. The ___ command defines a table's structure by listing its columns, data types, and column lengths.CREATE TABLE.

          

  43. A(n) ___ is the association between entities.attribute.

          

  44. Which of the following is a valid name for a table?WROTE.

          

  45. The ___ clause lets you group data on a particular column.SUM.

          

  46. The ____ wildcard symbol represents any individual character.VARCHAR.

          

  47. The REP table consists of the sales representatives number, last name, first name, address, total commission, and ___Commission rate.

          

  48. The ____ operator uses one or more wildcard characters to test for a pattern match.LIKE.

          

  49. The basic form of the SQL SELECT command is _____Semicolon.

          

  50. the ____ operator is inclusive meaning that a value equal to either value would be selected.BETWEEN.