Question 1

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

Accepted Answer

A)  ​DISPLAY 
B)  ​DESC 
C)  ​DSC 
D)  ​VIEW 
A)  ​DISPLAY 
B)  ​DESC 
C)  ​DSC 
D)  ​VIEW

Question 2

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 c 
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 c

Question 3

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 4

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

Accepted Answer

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

Question 5

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...FROM 
A)  ​ALTER TABLE...DELETE 
B)  ​TRUNCATE ROWS 
C)  ​TRUNCATE TABLE 
D)  ​DELETE...FROM

Question 6

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

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

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 subquery 
A)  before the AS clause 
B)  ​after the AS clause 
C)  in the subquery 
D)  after the subquery

Question 11

​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 column 
A)  ​before the GIFT column 
B)  ​after the GIFT column 
C)  ​after the MINRETAIL column 
D)  ​after the MAXRETAIL column

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

RENAME
REN

Question 14

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); 
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);

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

​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)  ​LONG 
A)  ​CHAR(n) 
B)  ​VARCHAR(n) 
C)  ​VARCHAR2(n) 
D)  ​LONG

Question 18

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

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

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

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

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

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.

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

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.

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

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

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

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

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

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

Which of the following is a valid SQL statement?

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

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

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

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

A column name can consist of up to 225 characters.

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

Overview of Database Concepts

Basic SQL Select Statements

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single-Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 3: Table Creation and Management

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

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

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

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

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

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

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

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

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

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

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

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

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

Which of the following is a valid SQL statement?​

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

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

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

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

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

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

Overview of Database Concepts

Basic SQL Select Statements

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single-Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

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

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

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

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

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.

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.

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

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

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

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

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

Which of the following is a valid SQL statement?

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

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

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

A column name can consist of up to 225 characters.

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