Chapter 3: Creating Tables
Cengage Learning Testing, Powered by Cognero
Page 1
True / False
1. SQL was developed as the data manipulation language for IBM’s prototype relational model DBMS, System R.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
59
2. This text uses Oracle Database 11g Express Edition as the DBMS in which to create and run SQL commands.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
59
3. To move back one or more pages in Oracle Database 11g Express, click the pages icon in the task bar.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
4. To create a table, type the command DESCRIBE TABLE followed by the name of the table to be created and then by
the names and data types of the columns that will comprise the table.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
5. Table names cannot contain spaces.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
78
6. In general, SQL is case-sensitive.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
7. In SQL, there are special rules that specify that a particular word must begin in a particular position on the line.
Chapter 3: Creating Tables
Cengage Learning Testing, Powered by Cognero
Page 2
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
8. To run SQL commands in Access, you must first create a new query.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
67
9. Unlike Oracle, Access does not support the DECIMAL data type.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
67
10. In Access, it is common to create a table using SQL.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
11. Microsoft SQL Server is a DBMS designed for use in client-server applications.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
68
12. When adding rows to character columns, make sure you enclose the values in single quotation marks.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
72
13. Dropping a table also deletes any data that you entered into the table.
a.
True
b.
False
ANSWER:
True
Cengage Learning Testing, Powered by Cognero
Page 4
20. To enter a null value into a table, you use a special format of the NULL command.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
21. To view data in a table, use the VIEW command.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
22. To change a value in a table, use the CHANGE command.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
23. If you added a row that should not be in a table, use a REMOVE command to remove it.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
24. The Oracle Database 11 g Express edition allows you to save a command so you can use it again without retyping it.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
78
25. Oracle stores script files is a special location called Saved Commands.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
26. Access does not use script files.
a.
True
Chapter 3: Creating Tables
Cengage Learning Testing, Powered by Cognero
Page 5
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
80
27. To list all the columns in a table, use the LIST COLUMNS command.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
28. The DESCRIBE TABLE command defines a table’s structure by listing its columns, data types, and column lengths.
a.
True
b.
False
ANSWER:
POINTS:
REFERENCES:
29. In Access, use the Documenter tool to describe the tables in a database.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
87
30. In SQL Server, execute the sp_columns command to list all the columns in a table.
a.
True
b.
False
ANSWER:
True
POINTS:
1
REFERENCES:
87
Multiple Choice
31. SQL was developed in the mid-____.
a.
1960s
b.
1970s
c.
1980s
d.
1990s
ANSWER:
b
POINTS:
1
REFERENCES:
59
32. What is the original name of SQL?
Chapter 3: Creating Tables
Cengage Learning Testing, Powered by Cognero
Page 6
a.
SEQUEL
b.
MYSEQUEL
c.
DBase
d.
MySQL
ANSWER:
a
POINTS:
1
REFERENCES:
59
33. In SQL, table names cannot exceed ____ characters.
a.
12
b.
14
c.
24
d.
30
ANSWER:
d
POINTS:
1
REFERENCES:
65
34. Which of the following is a valid name for a table?
a.
TBL_1
b.
2_TBL
c.
TBL 3
d.
4 tbl
ANSWER:
a
POINTS:
1
REFERENCES:
65
35. If your screen displays the SQL Scripts page, the Home>SQL Workshop>SQL Scripts reference near the top of the
SQL Scripts page is called a ____.
a.
command sequence
b.
page sequence
c.
breadcrumb
d.
page trail
ANSWER:
c
POINTS:
1
REFERENCES:
63
36. You indicate the end of a command by typing a ____.
a.
column
b.
comma
c.
semicolon
d.
period
ANSWER:
c
POINTS:
1
REFERENCES:
65
Cengage Learning Testing, Powered by Cognero
Page 7
37. To delete an entire table, use the ____ command and then re–create the table.
a.
REMOVE TABLE
b.
DELETE TABLE
c.
ERASE TABLE
d.
DROP TABLE
ANSWER:
d
POINTS:
1
REFERENCES:
65
38. In Oracle, dates have the format ____.
a.
DD-MON-YY
b.
MON-DD–YY
c.
YYYY-MON-DD
d.
DD-MON-YYYY
ANSWER:
d
POINTS:
1
REFERENCES:
69
39. In Access, dates are enclosed in number signs and are entered using the format ____.
a.
DD/MM/YY
b.
MM/DD/YYYY
c.
YYYY/MON/DD
d.
DD/MON/YYYY
ANSWER:
b
POINTS:
1
REFERENCES:
70
40. The ____ data type is used to store integers.
a.
INTEGER
b.
NUMERAL
c.
NUMBER
d.
INT
ANSWER:
d
POINTS:
1
REFERENCES:
70
41. The ____ data type stores only the actual character string.
a.
CHAR
b.
VARCHAR
c.
TEXT
d.
STRING
ANSWER:
b
POINTS:
1
REFERENCES:
70
Cengage Learning Testing, Powered by Cognero
Page 8
42. Use the ____ data type for columns that contain letters and special characters and for columns containing numbers that
will not be used in calculations.
a.
CHAR
b.
CHARACTER
c.
TEXT
d.
STRING
ANSWER:
a
POINTS:
1
REFERENCES:
70
43. Access does not support the ____ data type.
a.
DECIMAL
b.
CURRENCY
c.
INT
d.
NUMBER
ANSWER:
a
POINTS:
1
REFERENCES:
70
44. For any column whose data type is CHAR, values must be enclosed in ____.
a.
double quotation marks
b.
parentheses
c.
single quotation marks
d.
square brackets
ANSWER:
c
POINTS:
1
REFERENCES:
72
45. To display all the rows and columns in a table, type the word SELECT, followed by a(n) ____, followed by the word
FROM and then the name of the table containing the data you want to view.
a.
single quote
b.
asterisk
c.
double quote
d.
slash
ANSWER:
b
POINTS:
1
REFERENCES:
74
46. Which of the following commands changes the value in a column?
a.
UPDATE
b.
CHANGE
c.
REPLACE
d.
ADD
ANSWER:
a
POINTS:
1
Cengage Learning Testing, Powered by Cognero
Page 10
52. In this text, SQL commands are illustrated using ____________________.
ANSWER:
Oracle
Oracle Database Express Edition
Oracle 11g Express
POINTS:
1
REFERENCES:
59
53. In Oracle 11g Express, you enter and run commands using the SQL ____________________ tool.
ANSWER:
Commands
POINTS:
1
REFERENCES:
63
54. In Oracle 11g Express, you enter a command in the SQL editor pane and then click the ____________________
button to execute the command.
ANSWER:
Run
POINTS:
1
REFERENCES:
65
55. You use the ____________________ command to describe the layout of a table.
ANSWER:
CREATE TABLE
POINTS:
1
REFERENCES:
63
56. In Oracle 11 g Express, the results of a SQL command appear in the ____________________ pane.
ANSWER:
Results
POINTS:
1
REFERENCES:
65
57. You can delete the entire table using the ____________________ TABLE command.
ANSWER:
DROP
POINTS:
1
REFERENCES:
69
58. You can use the ____________________ data type to store date data.
ANSWER:
DATE
POINTS:
1
REFERENCES:
70
59. The ____________________ data type stores integers but uses less space than the INT data type.
ANSWER:
SMALLINT
POINTS:
1
REFERENCES:
70
60. The data type DECIMAL(5,2) represents a number with ____________________ places to the left and two places to
the right of the decimal.
ANSWER:
three
3
Chapter 3: Creating Tables
POINTS:
1
REFERENCES:
65
allowed.
POINTS:
1
REFERENCES:
71
POINTS:
1
REFERENCES:
78
POINTS:
1
REFERENCES:
78
ANSWER:
POINTS:
1
REFERENCES:
78
ANSWER:
DESCRIBE
POINTS:
1
REFERENCES:
81
70. In Access, use the ____________________ tool to describe the tables and other objects in a database.
ANSWER:
Documenter
POINTS:
1
REFERENCES:
86