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 61

Short Answer

Review LaterAdd Note

Review Later

​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

Show Answer

Question 62

Multiple Choice

Review LaterAdd Note

Review Later

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?

A) ​ALTER TABLE customers
MODIFY (city VARCHAR2(+8) ,lastname VARCHAR2(+4) ) ;
B) ​ALTER TABLE customers
MODIFY (city VARCHAR2(20) ,lastname VARCHAR2(14) ) ;
C) ​ALTER TABLE customers
MODIFY (city (+8) ,lastname (+4) ) ;
D) ​ALTER TABLE customers
MODIFY (city (20) ,lastname (14) ) ;

Correct Answer

verified

Show Answer

Question 63

True/False

Review LaterAdd Note

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

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

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

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

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

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

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

​Which of the following is a valid table name?

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

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

A DATE column consists of ____________________ bytes.​

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

The CREATE TABLE cannot contain a subquery.​

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

​The default format for a DATE column is ____________________.

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

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

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