FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Table Creation and Management

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 71

Multiple Choice

Review LaterAdd Note

Review Later

Structure of the PROMOTION table​ -​Which of the following SQL statements was most likely used to create the PROMOTION table?

A) CREATE TABLE promotion
(gift VARCHAR2(15) ,minretail NUMBER(5,2) ,maxretail NUMBER(5,2) ) ;​
B) ​CREATE TABLE promotion
AS (gift VARCHAR2(15) ,minretail NUMBER(5,2) ,maxretail NUMBER(5,2) ) ;
C) ​CREATE TABLE promotion
ADD (gift VARCHAR2(15) ,minretail NUMBER(5,2) ,maxretail NUMBER(5,2) ) ;
D) ​CREATE TABLE promotion
(gift VARCHAR2(15) ,minretail NUMBER(5,2) ,maxretail NUMBER(5,2) ;

Correct Answer

verified

Show Answer

Question 72

Multiple Choice

Review LaterAdd Note

Review Later

If you are creating a new table containing four columns from an existing table and want to change the name of one of the columns when it is created in the new table,add a column list containing ____ names in the CREATE TABLE clause.​

A) ​one
B) ​four
C) ​five
D) ​zero

Correct Answer

verified

Show Answer

Question 73

Multiple Choice

Review LaterAdd Note

A _______ column generates values automatically at runtime and may reference values from other columns.​

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

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

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

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

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

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

Which of the following is displayed by the DESCRIBE command?​

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

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

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

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

A table must contain a minimum of two columns._________________________

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