Question 1

Why does the POSTAL_CODE column in the REP table have a data type of CHAR,if a postal code is made up of numbers?​

Accepted Answer

Even though the POSTAL_CODE column contains numbers,those numbers are not used in calculations.Therefore,the column should have a CHAR data type.​

Question 2

SQL is Structured ____________________ Language.​

Accepted Answer

Query​

Question 3

To list all the columns in a table,use the LIST COLUMNS command.​

Accepted Answer

A) True 
 B)False  False

Question 4

In Oracle 11g Express,you enter and run commands using the SQL ____________________ tool.​

Accepted Answer

The answer of In Oracle 11g Express,you enter and run...

Question 5

Unlike Oracle,Access does not support the DECIMAL data type.​

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Microsoft SQL Server is a DBMS designed for use in client-server applications.​

Accepted Answer

A) True 
 B)False

Question 8

This text uses Oracle Database 11g Express Edition as the DBMS in which to create and run SQL commands.​

Accepted Answer

A) True 
 B)False

Question 9

When adding rows to character columns,make sure you enclose the values in single quotation marks.​

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) NEW TABLE 
B) ​DEFINE TABLE 
C) CREATE TABLE 
D) ​ADD TABLE 
A) NEW TABLE 
B) ​DEFINE TABLE 
C) CREATE TABLE 
D) ​ADD TABLE

Question 11

A ____ file is a text file with a .sql extension that contains SQL commands.​

Accepted Answer

A) command 
B) ​batch 
C) sequel 
D) ​script 
A) command 
B) ​batch 
C) sequel 
D) ​script

Question 12

You can use a special value to represent situations in which an actual value is unknown,unavailable,or not applicable.This special value is called a(n)____________________ data value.​

Accepted Answer

The answer of You can use a special value to...

Question 13

You must enclose values in ____________________ quotation marks for any column whose type is character (CHAR),even when the data contains numbers.​

Accepted Answer

The answer of You must enclose values in ____________________ quotation...

Question 14

In general,SQL is case-sensitive.​

Accepted Answer

A) True 
 B)False

Question 15

In Oracle,the data type STRING(n)stores a character string n characters long.​

Accepted Answer

A) True 
 B)False

Question 16

In this text,SQL commands are illustrated using ____________________.​

Accepted Answer

Oracle
Oracle Databa

Question 17

For any column whose data type is CHAR,values must be enclosed in ____.​

Accepted Answer

A) double quotation marks 
B) ​parentheses 
C) single quotation marks 
D) ​square brackets 
A) double quotation marks 
B) ​parentheses 
C) single quotation marks 
D) ​square brackets

Question 18

To enter a null value into a table,you use a special format of the NULL command.​

Accepted Answer

A) True 
 B)False

Question 19

Should a user be allowed to enter null values for the primary key?​

Accepted Answer

No,The primary key should uniq

Question 20

How can you correct errors in data?​

Accepted Answer

It depends on the type of error.If there

Why does the POSTAL_CODE column in the REP table have a data type of CHAR,if a postal code is made up of numbers?

SQL is Structured ____________________ Language.

To list all the columns in a table,use the LIST COLUMNS command.

In Oracle 11g Express,you enter and run commands using the SQL ____________________ tool.

Unlike Oracle,Access does not support the DECIMAL data type.

To view data in a table,use the VIEW command.

Microsoft SQL Server is a DBMS designed for use in client-server applications.

This text uses Oracle Database 11g Express Edition as the DBMS in which to create and run SQL commands.

When adding rows to character columns,make sure you enclose the values in single quotation marks.

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

A ____ file is a text file with a .sql extension that contains SQL commands.

You can use a special value to represent situations in which an actual value is unknown,unavailable,or not applicable.This special value is called a(n)____________________ data value.

You must enclose values in ____________________ quotation marks for any column whose type is character (CHAR),even when the data contains numbers.

In general,SQL is case-sensitive.

In Oracle,the data type STRING(n)stores a character string n characters long.

In this text,SQL commands are illustrated using ____________________.

For any column whose data type is CHAR,values must be enclosed in ____.

To enter a null value into a table,you use a special format of the NULL command.

Should a user be allowed to enter null values for the primary key?

How can you correct errors in data?

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

Why does the POSTAL_CODE column in the REP table have a data type of CHAR,if a postal code is made up of numbers?​

SQL is Structured ____________________ Language.​

To list all the columns in a table,use the LIST COLUMNS command.​

In Oracle 11g Express,you enter and run commands using the SQL ____________________ tool.​

Unlike Oracle,Access does not support the DECIMAL data type.​

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

Microsoft SQL Server is a DBMS designed for use in client-server applications.​

This text uses Oracle Database 11g Express Edition as the DBMS in which to create and run SQL commands.​

When adding rows to character columns,make sure you enclose the values in single quotation marks.​

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

A ____ file is a text file with a .sql extension that contains SQL commands.​

You can use a special value to represent situations in which an actual value is unknown,unavailable,or not applicable.This special value is called a(n)____________________ data value.​

You must enclose values in ____________________ quotation marks for any column whose type is character (CHAR),even when the data contains numbers.​

In general,SQL is case-sensitive.​

In Oracle,the data type STRING(n)stores a character string n characters long.​

In this text,SQL commands are illustrated using ____________________.​

For any column whose data type is CHAR,values must be enclosed in ____.​

To enter a null value into a table,you use a special format of the NULL command.​

Should a user be allowed to enter null values for the primary key?​

How can you correct errors in data?​

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

Why does the POSTAL_CODE column in the REP table have a data type of CHAR,if a postal code is made up of numbers?

SQL is Structured ____________________ Language.

To list all the columns in a table,use the LIST COLUMNS command.

In Oracle 11g Express,you enter and run commands using the SQL ____________________ tool.

Unlike Oracle,Access does not support the DECIMAL data type.

To view data in a table,use the VIEW command.

Microsoft SQL Server is a DBMS designed for use in client-server applications.

This text uses Oracle Database 11g Express Edition as the DBMS in which to create and run SQL commands.

When adding rows to character columns,make sure you enclose the values in single quotation marks.

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

A ____ file is a text file with a .sql extension that contains SQL commands.

You can use a special value to represent situations in which an actual value is unknown,unavailable,or not applicable.This special value is called a(n)____________________ data value.

You must enclose values in ____________________ quotation marks for any column whose type is character (CHAR),even when the data contains numbers.

In general,SQL is case-sensitive.

In Oracle,the data type STRING(n)stores a character string n characters long.

In this text,SQL commands are illustrated using ____________________.

For any column whose data type is CHAR,values must be enclosed in ____.

To enter a null value into a table,you use a special format of the NULL command.

Should a user be allowed to enter null values for the primary key?

How can you correct errors in data?