Question 1

You indicate the end of a command by typing a ____.​

Accepted Answer

A) column 
B) ​comma 
C) semicolon 
D) ​period 
A) column 
B) ​comma 
C) semicolon 
D) ​period

Question 2

In Oracle,dates have the format ____.​

Accepted Answer

A) DD-MON-YY 
B) ​MON-DD-YY 
C) YYYY-MON-DD 
D) ​DD-MON-YYYY 
A) DD-MON-YY 
B) ​MON-DD-YY 
C) YYYY-MON-DD 
D) ​DD-MON-YYYY

Question 3

Dropping a table also deletes any data that you entered into the table.​

Accepted Answer

A) True 
 B)False

Question 4

When a script file contains more than one command,each command must end with a(n)____.​

Accepted Answer

A) apostrophe 
B) ​semicolon 
C) period 
D) ​colon 
A) apostrophe 
B) ​semicolon 
C) period 
D) ​colon

Question 5

In SQL,there are special rules that specify that a particular word must begin in a particular position on the line.​

Accepted Answer

A) True 
 B)False

Question 6

The correct data type for the BALANCE column in the CUSTOMER table is ____.​

Accepted Answer

A) CHAR 
B) ​INT 
C) SMALLINT 
D) ​DECIMAL 
A) CHAR 
B) ​INT 
C) SMALLINT 
D) ​DECIMAL

Question 7

When you enter a new row into a table or modify an existing row,the values for one or more columns can be unknown or unavailable.​

Accepted Answer

A) True 
 B)False

Question 8

To change a value in a table,use the CHANGE command.​

Accepted Answer

A) True 
 B)False

Question 9

If your screen displays the SQL Scripts page,the Home>SQL Workshop>SQL Scripts reference near the top of the SQL Scripts page is called a ____.​

Accepted Answer

A) command sequence 
B) ​page sequence 
C) breadcrumb 
D) ​page trail 
A) command sequence 
B) ​page sequence 
C) breadcrumb 
D) ​page trail

Question 10

What are the common restrictions placed on table and column names?​

Accepted Answer

The names cannot exceed 30 cha

Question 11

To delete an entire table,use the ____ command and then re-create the table.​

Accepted Answer

A) REMOVE TABLE 
B) ​DELETE TABLE 
C) ERASE TABLE 
D) ​DROP TABLE 
A) REMOVE TABLE 
B) ​DELETE TABLE 
C) ERASE TABLE 
D) ​DROP TABLE

Question 12

In Oracle 11 g Express,the results of a SQL command appear in the ____________________ pane.​

Accepted Answer

The answer of In Oracle 11 g Express,the results of...

Question 13

To view the data in a table,you use the ____________________ command.​

Accepted Answer

The answer of To view the data in a table,you...

Question 14

Which of the following is a valid name for a table?​

Accepted Answer

A) TBL_1 
B) ​2_TBL 
C) TBL 3 
D) ​4 tbl 
A) TBL_1 
B) ​2_TBL 
C) TBL 3 
D) ​4 tbl

Question 15

SQL was developed in the mid-____.​

Accepted Answer

A) 1960s 
B) ​1970s 
C) 1980s 
D) ​1990s 
A) 1960s 
B) ​1970s 
C) 1980s 
D) ​1990s

Question 16

Oracle stores script files is a special location called Saved Commands.​

Accepted Answer

A) True 
 B)False

Question 17

To create a table,type the command DESCRIBE TABLE followed by the name of the table to be created and then by the names and data types of the columns that will comprise the table.​

Accepted Answer

A) True 
 B)False

Question 18

The data type indicates the type of data that a column can contain.​

Accepted Answer

A) True 
 B)False

Question 19

To move back one or more pages in Oracle Database 11g Express,click the pages icon in the task bar.​

Accepted Answer

A) True 
 B)False

Question 20

The DESCRIBE TABLE command defines a table's structure by listing its columns,data types,and column lengths.​

Accepted Answer

A) True 
 B)False

You indicate the end of a command by typing a ____.

In Oracle,dates have the format ____.

Dropping a table also deletes any data that you entered into the table.

When a script file contains more than one command,each command must end with a(n)____.

In SQL,there are special rules that specify that a particular word must begin in a particular position on the line.

The correct data type for the BALANCE column in the CUSTOMER table is ____.

When you enter a new row into a table or modify an existing row,the values for one or more columns can be unknown or unavailable.

To change a value in a table,use the CHANGE command.

If your screen displays the SQL Scripts page,the Home>SQL Workshop>SQL Scripts reference near the top of the SQL Scripts page is called a ____.

What are the common restrictions placed on table and column names?

To delete an entire table,use the ____ command and then re-create the table.

In Oracle 11 g Express,the results of a SQL command appear in the ____________________ pane.

To view the data in a table,you use the ____________________ command.

Which of the following is a valid name for a table?

SQL was developed in the mid-____.

Oracle stores script files is a special location called Saved Commands.

To create a table,type the command DESCRIBE TABLE followed by the name of the table to be created and then by the names and data types of the columns that will comprise the table.

The data type indicates the type of data that a column can contain.

To move back one or more pages in Oracle Database 11g Express,click the pages icon in the task bar.

The DESCRIBE TABLE command defines a table's structure by listing its columns,data types,and column lengths.

Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group

Database Design Fundamentals

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters

Exam 3: Creating Tables

You indicate the end of a command by typing a ____.​

In Oracle,dates have the format ____.​

Dropping a table also deletes any data that you entered into the table.​

When a script file contains more than one command,each command must end with a(n)____.​

In SQL,there are special rules that specify that a particular word must begin in a particular position on the line.​

The correct data type for the BALANCE column in the CUSTOMER table is ____.​

When you enter a new row into a table or modify an existing row,the values for one or more columns can be unknown or unavailable.​

To change a value in a table,use the CHANGE command.​

If your screen displays the SQL Scripts page,the Home>SQL Workshop>SQL Scripts reference near the top of the SQL Scripts page is called a ____.​

What are the common restrictions placed on table and column names?​

To delete an entire table,use the ____ command and then re-create the table.​

In Oracle 11 g Express,the results of a SQL command appear in the ____________________ pane.​

To view the data in a table,you use the ____________________ command.​

Which of the following is a valid name for a table?​

SQL was developed in the mid-____.​

Oracle stores script files is a special location called Saved Commands.​

To create a table,type the command DESCRIBE TABLE followed by the name of the table to be created and then by the names and data types of the columns that will comprise the table.​

The data type indicates the type of data that a column can contain.​

To move back one or more pages in Oracle Database 11g Express,click the pages icon in the task bar.​

The DESCRIBE TABLE command defines a table's structure by listing its columns,data types,and column lengths.​

Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group

Database Design Fundamentals

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters

You indicate the end of a command by typing a ____.

In Oracle,dates have the format ____.

Dropping a table also deletes any data that you entered into the table.

When a script file contains more than one command,each command must end with a(n)____.

In SQL,there are special rules that specify that a particular word must begin in a particular position on the line.

The correct data type for the BALANCE column in the CUSTOMER table is ____.

When you enter a new row into a table or modify an existing row,the values for one or more columns can be unknown or unavailable.

To change a value in a table,use the CHANGE command.

If your screen displays the SQL Scripts page,the Home>SQL Workshop>SQL Scripts reference near the top of the SQL Scripts page is called a ____.

What are the common restrictions placed on table and column names?

To delete an entire table,use the ____ command and then re-create the table.

In Oracle 11 g Express,the results of a SQL command appear in the ____________________ pane.

To view the data in a table,you use the ____________________ command.

Which of the following is a valid name for a table?

SQL was developed in the mid-____.

Oracle stores script files is a special location called Saved Commands.

To create a table,type the command DESCRIBE TABLE followed by the name of the table to be created and then by the names and data types of the columns that will comprise the table.

The data type indicates the type of data that a column can contain.

To move back one or more pages in Oracle Database 11g Express,click the pages icon in the task bar.

The DESCRIBE TABLE command defines a table's structure by listing its columns,data types,and column lengths.