03
Chapter 3: Table Creation and Management
TRUE/FALSE
1. A database object is a defined, self-contained structure in Oracle10g.
ANS: T PTS: 1 REF: 54
2. DML commands are used to create or modify database tables.
ANS: F PTS: 1 REF: 54
3. A table name can be up to 30 characters in length.
ANS: T PTS: 1 REF: 56
4. A column name can consist of up to 225 characters.
ANS: F PTS: 1 REF: 56
5. A table name can consist of numbers, letters, and blank spaces.
ANS: F PTS: 1 REF: 56
6. Every table name within a specific schema must be unique.
ANS: T PTS: 1 REF: 56
7. The maximum width of a VARCHAR2 column is 2000 characters.
ANS: F PTS: 1 REF: 57
8. The scale of a NUMBER column indicates the number of digits that can be displayed to the right of the decimal point.
ANS: T PTS: 1 REF: 57
9. The ALPHANUMERIC datatype can be used to store characters and numbers to a maximum width of 2000.
ANS: F PTS: 1 REF: 57
10. The precision of a NUMBER does not include the decimal point itself in the total number of digits that can be stored in a column.
ANS: T PTS: 1 REF: 57
11. A BFILE column stores a file locator to a binary file stored by the operating system.
ANS: T PTS: 1 REF: 58
12. The default size of a VARCHAR2 column is one character.
ANS: F PTS: 1 REF: 57
13. The INTERVAL datatype can be used to identify a specific interval, or amount, of time.
ANS: T PTS: 1 REF: 58
14. The default format of a DATE column in Oracle10g is DD-MON-YY.
ANS: T PTS: 1 REF: 57
15. A table can contain a maximum of 225 columns.
ANS: F PTS: 1 REF: 60
16. The structure of a table can be viewed by issuing the STRUCTURE command.
ANS: F PTS: 1 REF: 63
17. If the CREATE TABLE is being used to create a table from existing data, the SUBQUERY keyword must be used.
ANS: F PTS: 1 REF: 64
18. The CREATE TABLE cannot contain a subquery.
ANS: F PTS: 1 REF: 64
19. The MODIFY TABLE command can be used to change the size of a table.
ANS: F PTS: 1 REF: 66
20. A
TRUE/FALSE
1. A database object is a defined, self-contained structure in Oracle10g.
ANS: T PTS: 1 REF: 54
2. DML commands are used to create or modify database tables.
ANS: F PTS: 1 REF: 54
3. A table name can be up to 30 characters in length.
ANS: T PTS: 1 REF: 56
4. A column name can consist of up to 225 characters.
ANS: F PTS: 1 REF: 56
5. A table name can consist of numbers, letters, and blank spaces.
ANS: F PTS: 1 REF: 56
6. Every table name within a specific schema must be unique.
ANS: T PTS: 1 REF: 56
7. The maximum width of a VARCHAR2 column is 2000 characters.
ANS: F PTS: 1 REF: 57
8. The scale of a NUMBER column indicates the number of digits that can be displayed to the right of the decimal point.
ANS: T PTS: 1 REF: 57
9. The ALPHANUMERIC datatype can be used to store characters and numbers to a maximum width of 2000.
ANS: F PTS: 1 REF: 57
10. The precision of a NUMBER does not include the decimal point itself in the total number of digits that can be stored in a column.
ANS: T PTS: 1 REF: 57
11. A BFILE column stores a file locator to a binary file stored by the operating system.
ANS: T PTS: 1 REF: 58
12. The default size of a VARCHAR2 column is one character.
ANS: F PTS: 1 REF: 57
13. The INTERVAL datatype can be used to identify a specific interval, or amount, of time.
ANS: T PTS: 1 REF: 58
14. The default format of a DATE column in Oracle10g is DD-MON-YY.
ANS: T PTS: 1 REF: 57
15. A table can contain a maximum of 225 columns.
ANS: F PTS: 1 REF: 60
16. The structure of a table can be viewed by issuing the STRUCTURE command.
ANS: F PTS: 1 REF: 63
17. If the CREATE TABLE is being used to create a table from existing data, the SUBQUERY keyword must be used.
ANS: F PTS: 1 REF: 64
18. The CREATE TABLE cannot contain a subquery.
ANS: F PTS: 1 REF: 64
19. The MODIFY TABLE command can be used to change the size of a table.
ANS: F PTS: 1 REF: 66
20. A