03

Topics: SQL, Data Definition Language, Data Manipulation Language Pages: 17 (4187 words) Published: January 30, 2015
Chapter 3: Table Creation and Management

TRUE/FALSE

1.A database object is a defined, self-contained structure in Oracle10g.

ANS:TPTS:1REF:54

2.DML commands are used to create or modify database tables.

ANS:FPTS:1REF:54

3.A table name can be up to 30 characters in length.

ANS:TPTS:1REF:56

4.A column name can consist of up to 225 characters.

ANS:FPTS:1REF:56

5.A table name can consist of numbers, letters, and blank spaces.

ANS:FPTS:1REF:56

6.Every table name within a specific schema must be unique.

ANS:TPTS:1REF:56

7.The maximum width of a VARCHAR2 column is 2000 characters.

ANS:FPTS:1REF: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:TPTS:1REF:57

9.The ALPHANUMERIC datatype can be used to store characters and numbers to a maximum width of 2000.

ANS:FPTS:1REF: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:TPTS:1REF:57

11.A BFILE column stores a file locator to a binary file stored by the operating system.

ANS:TPTS:1REF:58

12.The default size of a VARCHAR2 column is one character.

ANS:FPTS:1REF:57

13.The INTERVAL datatype can be used to identify a specific interval, or amount, of time.

ANS:TPTS:1REF:58

14.The default format of a DATE column in Oracle10g is DD-MON-YY.

ANS:TPTS:1REF:57

15.A table can contain a maximum of 225 columns.

ANS:FPTS:1REF:60

16.The structure of a table can be viewed by issuing the STRUCTURE command.

ANS:FPTS:1REF:63

17.If the CREATE TABLE is being used to create a table from existing data, the SUBQUERY keyword must be used.

ANS:FPTS:1REF:64

18.The CREATE TABLE cannot contain a subquery.

ANS:FPTS:1REF:64

19.The MODIFY TABLE command can be used to change the size of a table.

ANS:FPTS:1REF:66

20.A database must be shut down before the ALTER TABLE command can be executed.

ANS:FPTS:1REF:66

21.Only one column can be added to an existing table at one time.

ANS:FPTS:1REF:68

22.A CHAR column cannot be resized to a width that is smaller than the data it already contains.

ANS:TPTS:1REF:68

23.When a column is deleted, the deletion is permanent.

ANS:TPTS:1REF:71

24.You cannot delete the last column in a table.

ANS:TPTS:1REF:71

25.The ALTER TABLE name can be used to rename a table.

ANS:FPTS:1REF:71 | 73

26.The RENAME command can be used to assign a table to a new schema.

ANS:FPTS:1REF:73

27.To retain the structure of a table, while deleting all its data and releasing their storage space, execute the TRUNC command.

ANS:FPTS:1REF:75

28.The DROP TABLE command can be used to remove a table and all its data from a database.

ANS:TPTS:1REF:77

29.The DELETE TABLE command can be used to remove a table from a database.

ANS:FPTS:1REF:77

30.A table that has been dropped without the PURGE option can be retrieved using the FLASHBACK TABLE command.

ANS:TPTS:1REF:78

MODIFIED TRUE/FALSE

1.Data manipulation language commands are used to create or modify database tables. _________________________

ANS:F, definition

PTS:1REF:54

2.DDL commands are used to create or modify database objects. _________________________

ANS:TPTS:1REF:54

3.A table name must begin with a(n) number. _________________________

ANS:F, letter

PTS:1REF:56

4.SELECT9 is a valid table name. _________________________

ANS:TPTS:1REF:56

5.You cannot specify the width for a(n) NUMBER column. _________________________

ANS:F, DATE

PTS:1REF:57

6.The maximum width of a(n) CHAR column is 4000 characters. _________________________

ANS:F,...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Essay on 03
  • 03 Essay
  • Tma 03 Essay
  • 9697/03 Essay
  • Essay about 03 05 03 Wellness 1
  • 4 03 Essay
  • 03 03 Task2 Essay
  • EFM 03 Essay

Become a StudyMode Member

Sign Up - It's Free