Question 1

The DROP UNUSED COLUMNS clause can be used with the ____________________ command to delete any column previously set as unused.

Accepted Answer

The answer of The DROP UNUSED COLUMNS clause can be...

Question 2

To delete all the rows in a table and free up the storage space that was occupied by those rows,the ____ command should be used.​

Accepted Answer

A)   ​ALTER TABLE...DELETE
B)   ​TRUNCATE ROWS
C)   ​TRUNCATE TABLE
D)   ​DELETE...FROME) None of the above
F) A) and C)

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is a valid SQL statement?​

Accepted Answer

A)   ​CREATE TABLE newname (colA NUMBER,colB DAT
E)  ;
B)   ​CREATE TABLE newname as SELECT * FROM books;
C)   ​CREATE TABLE newname (colA,col
B)  ;
D)   ​CREATE TABLE newname (colA DATE,colB VARCHAR2(3) ;E) All of the above
F) A) and C)

Question 5

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

Accepted Answer

A)   ​CHAR(n) 
B)   ​VARCHAR(n) 
C)   ​VARCHAR2(n) 
D)   ​LONGE) A) and D)
F) A) and C)

Question 6

A table name can contain the number sign and ____________________ symbols.

Accepted Answer

The answer of A table name can contain the number...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)   ​_
B)   ​%
C)   ​#
D)   ​none of the aboveE) A) and B)
F) A) and C)

Question 11

If you are creating a new table from data contained in an existing table,new column names can be specified by including a list of column names ____.​

Accepted Answer

A)   before the AS clause
B)   ​after the AS clause
C)   in the subquery
D)   after the subqueryE) B) and D)
F) B) and C)

Question 12

The ____________________ clause of the ALTER TABLE command can be used to change the size of a column.

Accepted Answer

The answer of The ____________________ clause of the ALTER TABLE...

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

If the MAXRETAIL column of the PROMOTION table has been set as unused,which of the following commands is valid?​

Accepted Answer

A)   ​ALTER TABLE promotion RESET maxretail USED;
B)   ​ALTER TABLE promotion DROP COLUMN maxretail;
C)   ​ALTER TABLE promotion DROP UNUSED COLUMNS;
D)   ​both b and cE) A) and B)
F) None of the above

Question 15

Which of the following SQL*Plus commands will display the structure of a table?​

Accepted Answer

A)   ​DISPLAY
B)   ​DESC
C)   ​DSC
D)   ​VIEWE) None of the above
F) All of the above

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

The name of a table can be changed with the ____________________ command.​

Accepted Answer

RENAME
REN...

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

​If a new column is added to the PROMOTION table,where will the new column be listed?

Accepted Answer

A)   ​before the GIFT column
B)   ​after the GIFT column
C)   ​after the MINRETAIL column
D)   ​after the MAXRETAIL columnE) C) and D)
F) B) and C)

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 3: Table Creation and Management

If the MAXRETAIL column of the PROMOTION table has been set as unused,which of the following commands is valid?​

Correct AnswerverifiedShow Answer

The name of a table can be changed with the ____________________ command.​

Correct AnswerverifiedRENAMEREN...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following SQL*Plus commands will display the structure of a table?​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

To delete all the rows in a table and free up the storage space that was occupied by those rows,the ____ command should be used.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

​If a new column is added to the PROMOTION table,where will the new column be listed?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A table name can contain the number sign and ____________________ symbols.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The ____________________ clause of the ALTER TABLE command can be used to change the size of a column.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

If you are creating a new table from data contained in an existing table,new column names can be specified by including a list of column names ____.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The DROP UNUSED COLUMNS clause can be used with the ____________________ command to delete any column previously set as unused.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following is a valid SQL statement?​

Correct AnswerverifiedShow Answer

If the MAXRETAIL column of the PROMOTION table has been set as unused,which of the following commands is valid?

Correct Answer
verified

The name of a table can be changed with the ____________________ command.

Correct Answer
verified
RENAME
REN...
View Answer

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

Correct Answer
verified

Which of the following SQL*Plus commands will display the structure of a table?

Correct Answer
verified

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.

Correct Answer
verified

To delete all the rows in a table and free up the storage space that was occupied by those rows,the ____ command should be used.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

If a new column is added to the PROMOTION table,where will the new column be listed?

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

If you are creating a new table from data contained in an existing table,new column names can be specified by including a list of column names ____.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

A column name can consist of up to 225 characters.

Correct Answer
verified

Which of the following is a valid SQL statement?

Correct Answer
verified