Exam 3: Table Creation and Management

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

(True/False)

4.8/5

(38)

Question 101

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

(Short Answer)

4.8/5

(38)

Question 102

Which of the following is a valid table name?

(Multiple Choice)

4.8/5

(40)

Question 103

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

(Multiple Choice)

4.9/5

(36)

Question 104

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

(True/False)

4.7/5

(41)

Question 105

The default format for a DATE column is ____________________.

(Short Answer)

4.8/5

(34)

Question 106

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

(True/False)

4.9/5

(36)

Question 107

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

(True/False)

4.7/5

(27)

Question 108

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

(Multiple Choice)

4.9/5

(36)

Question 109

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

(Multiple Choice)

4.7/5

(34)

Question 110

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

(True/False)

4.8/5

(35)

Question 111

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

(True/False)

4.9/5

(34)

Question 112

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

(True/False)

4.8/5

(36)

Question 113

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

(True/False)

4.9/5

(37)

Question 114

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?

(Multiple Choice)

4.7/5

(35)

Question 115

A DATE column consists of ____________________ bytes.

(Short Answer)

4.8/5

(28)

Question 116

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.

(Short Answer)

4.9/5

(32)

Question 117

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

(True/False)

4.8/5

(36)

Question 118

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

(True/False)

4.8/5

(31)

Question 119

The CREATE TABLE cannot contain a subquery.

(True/False)

4.9/5

(29)

Question 120

Showing 101 - 120 of 136

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

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

Which of the following is a valid table name?

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

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

The default format for a DATE column is ____________________.

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

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

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

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.

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

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

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

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 DATE column consists of ____________________ bytes.

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.

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

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

The CREATE TABLE cannot contain a subquery.

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

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

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

​Which of the following is a valid table name?

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

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

​The default format for a DATE column is ____________________.

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

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

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

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

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

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

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

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 DATE column consists of ____________________ bytes.​

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

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

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

The CREATE TABLE cannot contain a subquery.​

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

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

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

Which of the following is a valid table name?

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

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

The default format for a DATE column is ____________________.

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

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

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

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.

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

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

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

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 DATE column consists of ____________________ bytes.

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.

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

The CREATE TABLE cannot contain a subquery.