50 Multiple choice questions

1. ASTERISK.
   1. Which of the following tables relates books to authors?
   2. ___ can occur then there is a column in a table that is dependent on only a portion of the primary key.
   3. 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.
   4. Which of the following is a valid name for a table?
2. LIKE.
   1. The ____ operator specifies a range of values in a condition.
   2. The ____ data type stores only the actual character string.
   3. ____ is one of the categories of update anomalies.
   4. The ____ operator uses one or more wildcard characters to test for a pattern match.
3. GROUP BY.
   1. The ___ clause lets you group data on a particular column.
   2. You use the ___ clause to list data in a specific order.
   3. The ____ function calculates a total of the values in a column.
   4. The ____data type is use to store integers.
4. ORDER BY.
   1. The ____data type is use to store integers.
   2. The ___ clause lets you group data on a particular column.
   3. In SQL, you use the ____ command to query a database.
   4. You use the ___ clause to list data in a specific order.
5. IS NOT NULL
   1. The ____ operator finds rows that do not contain null values in the specified column.
   2. The ____ operator specifies a range of values in a condition.
   3. The ___ clause lets you group data on a particular column.
   4. The ____ function calculates a total of the values in a column.
6. UPDATE.
   1. Which of the following operators can be used for a column computation?
   2. Which of the following command changes the value in a column?
   3. The ____ function calculates a total of the values in a column.
   4. Which of the following tables relates books to authors?
7. SELECT-FROM-WHERE
   1. The basic form of the SQL SELECT command is _____
   2. ____ is one of the categories of update anomalies.
   3. A field is another term for a(n)____
   4. You indicate the end of a command by typing a____
8. Column
   1. Which of the following is a valid name for a table?
   2. The basic form of the SQL SELECT command is _____
   3. A field is another term for a(n)____
   4. The ____data type is use to store integers.
9. NOT
   1. Preceding a condition by the ____ operator reverses the truth of the original condition.
   2. The ____ function determines the number of rows in a table.
   3. To delete an entire table, use the ____ command and then re-create the table.
   4. ____ is one of the categories of update anomalies.
10. relationship.
    1. A(n) ____ is a characteristic of property of an entity.
    2. The ____data type is use to store integers.
    3. ____ is one of the categories of update anomalies.
    4. A(n) ___ is the association between entities.
11. CHAR.
    1. The ____data type is use to store integers.
    2. The ____ wildcard symbol represents any individual character.
    3. The ____ data type stores only the actual character string.
    4. Use the ____ date type for columns that contain letters and special characters and for columns that will not be use in calculations.
12. VARCHAR.
    1. The ____ operator specifies a range of values in a condition.
    2. The ____ function determines the number of rows in a table.
    3. The ____ wildcard symbol represents any individual character.
    4. The ____ data type stores only the actual character string.
13. INVENTORY
    1. The ___ clause lets you group data on a particular column.
    2. The ____ function determines the number of rows in a table.
    3. The ____ table indicates the number of copies of a particular book that are currently on hand at a particular branch of Henry Books.
    4. The ____ wildcard symbol represents any individual character.
14. Semicolon.
    1. A field is another term for a(n)____
    2. In SQL, you use the ____ command to query a database.
    3. You indicate the end of a command by typing a____
    4. The basic form of the SQL SELECT command is _____
15. C) *
    1. In SQL, you use the ____ command to query a database.
    2. In the SELECT clause, you can use the ____ symbol to indicate that you want to include all columns.
    3. The___ clause is used to restrict the groups that will be included.
    4. To delete an entire table, use the ____ command and then re-create the table.
16. DROP TABLE.
    1. A relation is in ____ if it does not contain any repeating groups.
    2. In relational database each ____ should be unique.
    3. To delete an entire table, use the ____ command and then re-create the table.
    4. In SQL, you use the ____ command to query a database.
17. Determinant.
    1. Any column (or collection of columns) that determines another column is called a(n) ___
    2. Which of the following command changes the value in a column?
    3. Use the ____ date type for columns that contain letters and special characters and for columns that will not be use in calculations.
    4. When you need to sort data on two columns, the less important column is called the ____ sort key.
18. ORDER_NUM ANDPART_NUM.
    1. Which of the following is the primary key of the ORDER_LINE (ORDER_NUM, PART_NUM, NUM_ORDERED, QUOTED_PRICE) table?
    2. Which of the following command changes the value in a column?
    3. Which of the following tables relates books to authors?
    4. Which of the following operators can be used for a column computation?
19. SUM.
    1. The ____ function determines the number of rows in a table.
    2. The ____ operator specifies a range of values in a condition.
    3. Which of the following command changes the value in a column?
    4. The ____ function calculates a total of the values in a column.
20. Inconsistent data.
    1. A(n) ___ is the association between entities.
    2. The ____data type is use to store integers.
    3. A(n) ____ is a characteristic of property of an entity.
    4. ____ is one of the categories of update anomalies.
21. All of the above. (row,record,tuple)
    1. The ____data type is use to store integers.
    2. In relational database each ____ should be unique.
    3. In SQL, you use the ____ command to query a database.
    4. A field is another term for a(n)____
22. HAVING.
    1. The ___ clause lets you group data on a particular column.
    2. The ____data type is use to store integers.
    3. The ____ data type stores only the actual character string.
    4. The___ clause is used to restrict the groups that will be included.
23. code.
    1. Each publisher has a ___ that uniquely identifies the publisher at Henry Books.
    2. A relation is in ____ if it does not contain any repeating groups.
    3. The ____ data type stores only the actual character string.
    4. The ____ function determines the number of rows in a table.
24. WROTE.
    1. Which of the following is a valid name for a table?
    2. Which of the following command changes the value in a column?
    3. Which of the following tables relates books to authors?
    4. Which of the following operators can be used for a column computation?
25. CODE.
    1. Each book at Henry Books is uniquely identified with a(n) ____
    2. Which of the following is a valid name for a table?
    3. A field is another term for a(n)____
    4. The basic form of the SQL SELECT command is _____
26. Part description.
    1. The ___ clause lets you group data on a particular column.
    2. Which of the following is the primary key of the ORDER_LINE (ORDER_NUM, PART_NUM, NUM_ORDERED, QUOTED_PRICE) table?
    3. A relation is in ____ if it does not contain any repeating groups.
    4. 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. second normal form
    1. A(n) ___ is the association between entities.
    2. You use the ___ clause to list data in a specific order.
    3. You indicate the end of a command by typing a____
    4. A relation is in ____ if it does not contain any repeating groups.
28. All of the above (AND,OR,NOT).
    1. The ____ operator specifies a range of values in a condition.
    2. When you need to sort data on two columns, the less important column is called the ____ sort key.
    3. Any column (or collection of columns) that determines another column is called a(n) ___
    4. You form compound conditions by connecting two or more simple conditions using the ____ operator.
29. IN
    1. You use the ___ clause to list data in a specific order.
    2. The ____ function calculates a total of the values in a column.
    3. You can use the ____ operator followed by a collection a values to provide a concise way of phrasing certain conditions.
    4. The ____ operator specifies a range of values in a condition.
30. Plus ( + )
    1. Which of the following is a valid name for a table?
    2. Which of the following operators can be used for a column computation?
    3. The ____ operator specifies a range of values in a condition.
    4. Which of the following command changes the value in a column?
31. %
    1. In the SELECT clause, you can use the ____ symbol to indicate that you want to include all columns.
    2. In SQL for Orable and SQL Server, the ___ symbol is used as a wildcard to represent any collection of characters.
    3. In relational database each ____ should be unique.
    4. In SQL, you use the ____ command to query a database.
32. CREATE TABLE.
    1. The ___ command defines a table's structure by listing its columns, data types, and column lengths.
    2. The ____ operator specifies a range of values in a condition.
    3. The ____ function calculates a total of the values in a column.
    4. The___ clause is used to restrict the groups that will be included.
33. SELECT
    1. ____ is one of the categories of update anomalies.
    2. A(n) ___ is the association between entities.
    3. In SQL, you use the ____ command to query a database.
    4. You use the ___ clause to list data in a specific order.
34. COUNT.
    1. The ____data type is use to store integers.
    2. The ____ function calculates a total of the values in a column.
    3. The ____ operator specifies a range of values in a condition.
    4. The ____ function determines the number of rows in a table.
35. Underscore ( _ )
    1. The ___ clause lets you group data on a particular column.
    2. The ____ data type stores only the actual character string.
    3. The ____data type is use to store integers.
    4. The ____ wildcard symbol represents any individual character.
36. script.
    1. The ____ function calculates a total of the values in a column.
    2. A ____ file is a text file with a .sql extension that contains SQL commands.
    3. A relation is in ____ if it does not contain any repeating groups.
    4. ____ is one of the categories of update anomalies.
37. Commission rate.
    1. The ____ function determines the number of rows in a table.
    2. The REP table consists of the sales representatives number, last name, first name, address, total commission, and ___
    3. Which of the following is a valid name for a table?
    4. The ____ table indicates the number of copies of a particular book that are currently on hand at a particular branch of Henry Books.
38. Update anomalies.
    1. ___ can occur then there is a column in a table that is dependent on only a portion of the primary key.
    2. 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.
    3. Which of the following command changes the value in a column?
    4. Which of the following tables relates books to authors?
39. minor
    1. When you need to sort data on two columns, the less important column is called the ____ sort key.
    2. The correct data type for the BALANCE column in the CUSTOMER table is ____
    3. Any column (or collection of columns) that determines another column is called a(n) ___
    4. Which of the following command changes the value in a column?
40. single quotation marks.
    1. You indicate the end of a command by typing a____
    2. The ____data type is use to store integers.
    3. The basic form of the SQL SELECT command is _____
    4. For any column whose data type is CHAR, values must be enclosed in _____
41. database design
    1. The process of determining the particular tables and columns that will comprise a database is known as____
    2. The ____ function determines the number of rows in a table.
    3. The___ clause is used to restrict the groups that will be included.
    4. The ____ operator specifies a range of values in a condition.
42. TBL_1
    1. Which of the following command changes the value in a column?
    2. Which of the following operators can be used for a column computation?
    3. Which of the following is a valid name for a table?
    4. Which of the following tables relates books to authors?
43. INT
    1. The ____data type is use to store integers.
    2. A(n) ___ is the association between entities.
    3. The ____ function determines the number of rows in a table.
    4. A field is another term for a(n)____
44. BETWEEN.
    1. The ____ function determines the number of rows in a table.
    2. the ____ operator is inclusive meaning that a value equal to either value would be selected.
    3. The ____ operator finds rows that do not contain null values in the specified column.
    4. The ____ operator uses one or more wildcard characters to test for a pattern match.
45. COUNT.
    1. You use the ___ clause to list data in a specific order.
    2. Which of the following command changes the value in a column?
    3. when you use the ____ function you can use the asterisk (*) to represent any column
    4. The ____ function calculates a total of the values in a column.
46. Semicolon
    1. The correct data type for the BALANCE column in the CUSTOMER table is ____
    2. The basic form of the SQL SELECT command is _____
    3. You indicate the end of a command by typing a____
    4. When a script file contains more than one command, each command must end with a _____.
47. SEQUENCE.
    1. The ____ operator specifies a range of values in a condition.
    2. The ___ field of the WROTE table of Henry Books indicates the order in which the authors of a particular are listed on the cover.
    3. The ____ function determines the number of rows in a table.
    4. Which of the following command changes the value in a column?
48. attribute.
    1. ____ is one of the categories of update anomalies.
    2. A(n) ____ is a characteristic of property of an entity.
    3. A field is another term for a(n)____
    4. The ____data type is use to store integers.
49. DECIMAL.
    1. The correct data type for the BALANCE column in the CUSTOMER table is ____
    2. The ____data type is use to store integers.
    3. The basic form of the SQL SELECT command is _____
    4. The ____ data type stores only the actual character string.
50. BETWEEN.
    1. The ____ function determines the number of rows in a table.
    2. The ____ function calculates a total of the values in a column.
    3. The ____ operator specifies a range of values in a condition.
    4. The ____data type is use to store integers.