Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

​Which of the following commands will set the MINRETAIL column of the PROMOTION table as unused?

Accepted Answer

A)   ​ALTER TABLE promotion SET UNUSED (minretail) ;
B)   ​ALTER TABLE promotion SET minretail UNUSED;
C)   ​ALTER TABLE promotion SET UNUSED COLUMN minretail;
D)   ​both a and cE) C) and D)
F) B) and D)

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)   ​%
B)   ​*
C)   ​#
D)   ​'E) A) and D)
F) A) and B)

Question 7

A DATE column consists of ____________________ bytes.​

Accepted Answer

The answer of A DATE column consists of ____________________ bytes.​...

Question 8

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

Accepted Answer

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.E) A) and B)
F) All of the above

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Structure of the CUSTOMERS table
  ​
-Which of the following commands will increase the size of the CITY column in the CUSTOMERS table from 12 to 20 and increase size of the LASTNAME column from 10 to 14?

Accepted Answer

A)   ​ALTER TABLE customersMODIFY (city VARCHAR2(+8) ,lastname VARCHAR2(+4) ) ;
B)   ​ALTER TABLE customersMODIFY (city VARCHAR2(20) ,lastname VARCHAR2(14) ) ;
C)   ​ALTER TABLE customersMODIFY (city (+8) ,lastname (+4) ) ;
D)   ​ALTER TABLE customersMODIFY (city (20) ,lastname (14) ) ;E) A) and C)
F) B) and D)

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

​The ____________________ TABLE command can be used to delete and release the storage space of all data contained in a database table,while still retaining the table's structure.

Accepted Answer

The answer of ​The ____________________ TABLE command can be used...

Question 14

​Which of the following is a valid table name?

Accepted Answer

A)   ​MYTABLE
B)   ​DISTINCT
C)   ​SELECT
D)   ​CHARE) All of the above
F) A) and B)

Question 15

​The default format for a DATE column is ____________________.

Accepted Answer

The answer of ​The default format for a DATE column...

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

The CREATE TABLE cannot contain a subquery.​

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

​A column's ____________________ identifies the type of data that can be stored in a column.

Accepted Answer

The answer of ​A column's ____________________ identifies the type of...

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 3: Table Creation and Management

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Structure of the CUSTOMERS table ​ -Which of the following commands will increase the size of the CITY column in the CUSTOMERS table from 12 to 20 and increase size of the LASTNAME column from 10 to 14?

Correct AnswerverifiedShow Answer

The CREATE TABLE cannot contain a subquery.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

​A column's ____________________ identifies the type of data that can be stored in a column.

Correct AnswerverifiedShow Answer

​Which of the following is a valid table name?

Correct AnswerverifiedShow Answer

​The default format for a DATE column is ____________________.

Correct AnswerverifiedShow Answer

​Which of the following commands will set the MINRETAIL column of the PROMOTION table as unused?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A DATE column consists of ____________________ bytes.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

​The ____________________ TABLE command can be used to delete and release the storage space of all data contained in a database table,while still retaining the table's structure.

Correct AnswerverifiedShow Answer

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Structure of the CUSTOMERS table -Which of the following commands will increase the size of the CITY column in the CUSTOMERS table from 12 to 20 and increase size of the LASTNAME column from 10 to 14?

Correct Answer
verified

The CREATE TABLE cannot contain a subquery.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

A column's ____________________ identifies the type of data that can be stored in a column.

Correct Answer
verified

Which of the following is a valid table name?

Correct Answer
verified

The default format for a DATE column is ____________________.

Correct Answer
verified

Which of the following commands will set the MINRETAIL column of the PROMOTION table as unused?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

A DATE column consists of ____________________ bytes.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

The ____________________ TABLE command can be used to delete and release the storage space of all data contained in a database table,while still retaining the table's structure.

Correct Answer
verified