Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A)   ​data definition
B)   ​data format
C)   ​datatype
D)   ​data recordE) B) and D)
F) None of the above

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

Structure of the PROMOTION table​
 
-​Which of the following commands will change the name of the PROMOTION table to GIFT?

Accepted Answer

A)   ALTER TABLE promotion NAME TO gift​
B)   ​ALTER TABLE promotion TO gift;
C)   ​RENAME TABLE promotion TO gift;
D)   ​RENAME promotion TO gift;E) B) and D)
F) B) and C) D

Question 7

​Each ____________________ name within a table must be unique.

Accepted Answer

The answer of ​Each ____________________ name within a table must...

Question 8

​Which of the following keywords can be used to change the size,datatype,and/or default value of an existing column?

Accepted Answer

A)   ​ADD
B)   ​MODIFY
C)   ​CHANGE
D)   ​RESETE) All of the above
F) A) and D)

Question 9

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

Accepted Answer

A)   ​" "
B)   ​' '
C)   ​( ) 
D)   ​| |E) A) and D)
F) None of the above

Question 10

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

Accepted Answer

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 (&) .E) A) and C)
F) B) and C)

Question 11

When using the ALTER TABLE...DROP COLUMN command,which of the following is not correct?​

Accepted Answer

A)   ​The command's effect on the table is permanent.
B)   ​You cannot delete the last remaining column in a table.
C)   ​The command deletes both the column and its contents.
D)   ​The command can be used to delete multiple columns from a table.E) B) and C)
F) B) and D)

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Structure of the CUSTOMERS table
  ​
-​Which of the following commands will display the structure of the CUSTOMERS table?

Accepted Answer

A)   ​DESC customers
B)   ​DESCRIBE customers
C)   ​DSC customers;
D)   ​both a and bE) A) and D)
F) A) and C)

Question 14

If a new table is being created based upon a subquery,the subquery must be enclosed in which of the following symbols?​

Accepted Answer

A)   " "
B)   | |​
C)   ​' '
D)   ​( ) E) None of the above
F) A) and D)

Question 15

​Which command is used to rename a table you own?

Accepted Answer

A)   ​ALTER TABLE...RENAME
B)   ​ALTER TABLE...SET NAME
C)   ​RENAME...AS
D)   ​RENAME...TOE) All of the above
F) C) and D) D

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A)   ​1
B)   ​8
C)   ​12
D)   ​none of the aboveE) C) and D)
F) B) and D)

Question 18

The maximum width of the NUMBER datatype is ____ digits.

Accepted Answer

A)   ​7
B)   ​30
C)   ​38
D)   ​255E) None of the above
F) All of the above C

Question 19

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

Accepted Answer

The answer of A database ____________________ is a defined,self-contained structure...

Question 20

Structure of the CUSTOMERS table
  ​
-Which of the following commands will change the name of the LAST NAME column to LAST_NAME in the CUSTOMERS table?​

Accepted Answer

A)   ALTER TABLE customers MODIFY lastname to last_name;​
B)   ​ALTER TABLE customers CHANGE lastname to last_name;
C)   ​ALTER TABLE customers MODIFY (lastname,last_name) ;
D)   ​none of the aboveE) All of the above
F) A) and B)

Exam 3: Table Creation and Management

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Structure of the PROMOTION table​ -​Which of the following commands will change the name of the PROMOTION table to GIFT?

Correct AnswerverifiedD

​Each ____________________ name within a table must be unique.

Correct AnswerverifiedShow Answer

​Which of the following keywords can be used to change the size,datatype,and/or default value of an existing column?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

When using the ALTER TABLE...DROP COLUMN command,which of the following is not correct?​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Structure of the CUSTOMERS table ​ -​Which of the following commands will display the structure of the CUSTOMERS table?

Correct AnswerverifiedShow Answer

If a new table is being created based upon a subquery,the subquery must be enclosed in which of the following symbols?​

Correct AnswerverifiedShow Answer

​Which command is used to rename a table you own?

Correct AnswerverifiedD

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The maximum width of the NUMBER datatype is ____ digits.

Correct AnswerverifiedC

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

Correct AnswerverifiedShow Answer

Structure of the CUSTOMERS table ​ -Which of the following commands will change the name of the LAST NAME column to LAST_NAME in the CUSTOMERS table?​

Correct AnswerverifiedShow Answer

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Structure of the PROMOTION table -Which of the following commands will change the name of the PROMOTION table to GIFT?

Correct Answer
verified
D

Each ____________________ name within a table must be unique.

Correct Answer
verified

Which of the following keywords can be used to change the size,datatype,and/or default value of an existing column?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

When using the ALTER TABLE...DROP COLUMN command,which of the following is not correct?

Correct Answer
verified

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

Correct Answer
verified

Structure of the CUSTOMERS table -Which of the following commands will display the structure of the CUSTOMERS table?

Correct Answer
verified

If a new table is being created based upon a subquery,the subquery must be enclosed in which of the following symbols?

Correct Answer
verified

Which command is used to rename a table you own?

Correct Answer
verified
D

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified

Structure of the CUSTOMERS table -Which of the following commands will change the name of the LAST NAME column to LAST_NAME in the CUSTOMERS table?

Correct Answer
verified