Deck 3: Table Creation and Management

Question 1

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.​

Answer 1

True

Question 2

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

Answer 2

False

Question 3

The scale of a NUMBER column indicates the number of digits that can be displayed to the right of the decimal point.​

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

An automatic column will generate a value at runtime and may reference values from other columns.
​

Question 9

The CREATE TABLE cannot contain a subquery.​

Question 10

The default format of a DATE column in Oracle 12c is DD-MON-YY.​

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

A database object is a defined,self-contained structure in Oracle 12c.​

Question 17

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

Question 18

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

Question 19

A datatype identifies the type of data to be stored in a column.​

Question 20

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

Question 21

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

Question 22

You cannot delete the last column in a table.​

Question 23

The scale of a NUMBER column indicates the total number of digits that can be stored in the column._________________________​

Question 24

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

Question 25

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

Question 26

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

Question 27

Using the DESC on a table will display hidden columns.​

Question 28

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

Question 29

SELECT9 is a valid table name._________________________​

Question 30

The USER_TAB_COLS data dictionary object contains a column to identify hidden columns.​

Question 31

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

Question 32

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

Question 33

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

Question 34

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

Question 35

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

Question 36

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

Question 37

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

Question 38

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

Question 39

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

Question 40

The CHAR datatype is used to store variable-length data that can consist of letters and numbers._________________________​

Question 41

The maximum width of a NUMBER column is 25 digits._________________________​

Question 42

​Which of the following is a valid table name?

A) ​MYTABLE
B) ​DISTINCT
C) ​SELECT
D) ​CHAR

Question 43

The MODIFY clause can be included in the ALTER TABLE command to add a default value to an existing column._________________________

Question 44

​Which of the following terms refers to commands that are used to create or modify database tables?

A) ​data manipulation language (DML)
B) ​data control language (DCL)
C) ​data definition language (DDL)
D) ​data formatting language (DFL)

Question 45

Once a column as been set as UNUSED,it cannot be recovered._________________________​

Question 46

The DROP COLUMN clause of the ALTER TABLE command can only be used to delete one column at a time._________________________​

Question 47

The width of a NUMBER column cannot be changed once it contains data._________________________​

Question 48

The data contained in a dropped table can be retrieved if the DROP option was not used in the DROP TABLE command._________________________​

Question 49

The CHANGE TABLE command can be used to modify an existing table._________________________
​

Question 50

The default size of the CHAR column is 2._________________________​

Question 51

The MODIFY clause can be used with the ALTER TABLE command to add a column to an existing table._________________________​

Question 52

The TRUNCATE TABLE command can be used to delete a table from a database._________________________​

Question 53

​The DELETE TABLE command can be used to delete all the data stored in a table and release the storage space,yet retain the structure of the table._________________________

Question 54

A table must contain a minimum of two columns._________________________

Question 55

The abbreviation for the DESCRIBE command is DES._________________________​

Question 56

The syntax of the CREATE TABLE command requires that the column list be enclosed in parentheses._________________________​

Question 57

Seven bytes are allocated in a DATE column to store the century,year,month,day,hour,minute,and second of a date._________________________​

Question 58

Which keywords are used to complete the deletion of a column previously marked with SET UNUSED?​

A) ​DELETE UNUSED COLUMNS
B) ​DROP UNUSED COLUMNS
C) ​UNSET UNUSED COLUMNS
D) ​DROP SET COLUMNS

Question 59

The CREATE TABLE command is used to create a table in Oracle 12c._________________________​

Question 60

More than one column can be changed at a time with the ALTER TABLE...MODIFY command._________________________​

Question 61

Which command instructs Oracle 12c to create a new table from existing data?​

A) ​CREATE NEW TABLE
B) ​CREATE TABLE...FROM
C) ​CREATE TABLE
D) ​CREATE TABLE...AS

Question 62

​Which of the following datatypes refers to fixed-length character data,where n represents the maximum length of the column?

A) ​CHAR(n)
B) ​VARCHAR(n)
C) ​VARCHAR2(n)
D) ​LONG

Question 63

​The column definition of NUMBER(7,4)indicates a precision of ____.

A) ​7
B) ​4
C) ​11
D) ​3

Question 64

In which format does Oracle 12c display a date value?​

A) ​DD-MON-YEAR
B) ​DAY-MM-YY
C) ​DD-MM-YY
D) ​DD-MON-YY

Question 65

The maximum width of the NUMBER datatype is ____ digits.

A) ​7
B) ​30
C) ​38
D) ​255

Question 66

When defining columns for a table in the CREATE TABLE command,the column list must be enclosed in which of the following symbols?​

A) ​" "
B) ​' '
C) ​( )
D) ​| |

Question 67

Which of the following symbols can be used in a column name?​

A) ​%
B) ​*
C) ​#
D) ​'

Question 68

Which of the following is a valid SQL statement?​

A) ​CREATE TABLE newname (colA NUMBER,colB DATE);
B) ​CREATE TABLE newname as SELECT * FROM books;
C) ​CREATE TABLE newname (colA,colB);
D) ​CREATE TABLE newname (colA DATE,colB VARCHAR2(3);

Question 69

​Which of the following is a valid table name in Oracle 12c?

A) ​jimm8 Y%c _5_H76ang
B) ​S_c#oT#2t_321sM#_i_T6h
C) ​2LaN_n23_es#M#m
D) ​mAU$reE78_&_n1

Question 70

Which of the following symbols cannot be used in a table name?​

A) ​_
B) ​%
C) ​#
D) ​none of the above

Question 71

Which of the following rules apply to table names in Oracle 12c?​

A) ​Names can contain blank spaces.
B) ​Names can be up to 225 characters in length.
C) ​Names can begin with a number.
D) ​Names can contain a number sign (#).

Question 72

Which of the following is a valid column name?​

A) ​VARCHAR2
B) ​DISTINCT
C) ​NEW_COLUMN
D) ​CHAR

Question 73

​What is the maximum width that can be assigned to a DATE column?

A) ​1
B) ​8
C) ​12
D) ​none of the above

Question 74

A(n)____ simply identifies the type of data that Oracle 12c will be expected to store in a column.​

A) ​data definition
B) ​data format
C) ​datatype
D) ​data record

Question 75

When defining columns for a table,which of the following symbols is used to separate the column names in the column list?​

A) ​" "
B) ​,
C) ​( )
D) ​| |

Question 76

When creating a table,which of the following statements is correct?​

A) ​The schema of the table must be explicitly stated.
B) ​A user can have two tables with the same name,as long as the column names are different.
C) ​The column list must be enclosed in parentheses ( ).
D) ​Default values cannot be assigned to all columns in a table.

Question 77

If a column is defined as NUMBER(5,2),which of the following is true?​

A) ​The column can store a total of 7 digits,with 5 on the left side of the decimal point,and 2 on the right.
B) ​The column can store a total of 7 digits,all of them on the right side of the decimal point.
C) ​The column can store a total of 5 digits,with 3 on the left side of the decimal point,and 2 on the right.
D) ​The column can store a total of 5 digits,all of them on the left side of the decimal point.

Question 78

Which of the following datatypes refers to variable-length character data,where n represents the maximum length of the column?​

A) ​CHAR(n)
B) ​BFILE
C) ​VARCHAR2(n)
D) ​LONG

Question 79

​Which command instructs Oracle 12c to create a new table?

A) ​CREATE NEW TABLE
B) ​CREATE TABLE...FROM
C) ​CREATE TABLE
D) ​ALTER TABLE

Question 80

Which of the following rules does not apply to column names in Oracle 12c?​

A) ​Column names can contain numbers.
B) ​Column names can be up to 30 characters in length.
C) ​Column names must begin with a letter.
D) ​Column names can contain an ampersand (&).