Question 1

Use the ____ data type for columns that contain letters and special characters and for columns containing numbers that will not be used in calculations.​

Accepted Answer

A) CHAR 
B) ​CHARACTER 
C) TEXT 
D) ​STRING 
A) CHAR 
B) ​CHARACTER 
C) TEXT 
D) ​STRING

Question 2

To indicate columns that cannot contain null values,use the ____________________ clause in a CREATE TABLE statement.​

Accepted Answer

The answer of To indicate columns that cannot contain null...

Question 3

In Oracle 11g Express,you enter a command in the SQL editor pane and then click the ____________________ button to execute the command.​

Accepted Answer

The answer of In Oracle 11g Express,you enter a command...

Question 4

To run SQL commands in Access,you must first create a new query.​

Accepted Answer

A) True 
 B)False

Question 5

In Access,it is common to create a table using SQL.​

Accepted Answer

A) True 
 B)False

Question 6

In Access,dates are enclosed in number signs and are entered using the format ____.​

Accepted Answer

A) DD/MM/YY 
B) ​MM/DD/YYYY 
C) YYYY/MON/DD 
D) ​DD/MON/YYYY 
A) DD/MM/YY 
B) ​MM/DD/YYYY 
C) YYYY/MON/DD 
D) ​DD/MON/YYYY

Question 7

A file containing SQL commands is called a(n)____________________ file.​

Accepted Answer

The answer of A file containing SQL commands is called...

Question 8

If you added a row that should not be in a table,use a REMOVE command to remove it.​

Accepted Answer

A) True 
 B)False

Question 9

In Oracle,the date,November 12,2015 would be stored as '12-NOV-2015'.​

Accepted Answer

A) True 
 B)False

Question 10

The ____________________ data type stores integers but uses less space than the INT data type.​

Accepted Answer

The answer of The ____________________ data type stores integers but...

Question 11

The ____ data type stores only the actual character string.​

Accepted Answer

A) CHAR 
B) ​VARCHAR 
C) TEXT 
D) ​STRING 
A) CHAR 
B) ​VARCHAR 
C) TEXT 
D) ​STRING

Question 12

In Access,use the ____________________ tool to describe the tables and other objects in a database.​

Accepted Answer

The answer of In Access,use the ____________________ tool to describe...

Question 13

Table names cannot contain spaces.​

Accepted Answer

A) True 
 B)False

Question 14

In SQL,table names cannot exceed ____ characters.​

Accepted Answer

A) 12 
B) ​14 
C) 24 
D) ​30 
A) 12 
B) ​14 
C) 24 
D) ​30

Question 15

What is the original name of SQL?​

Accepted Answer

A) SEQUEL 
B) ​MYSEQUEL 
C) DBase 
D) ​MySQL 
A) SEQUEL 
B) ​MYSEQUEL 
C) DBase 
D) ​MySQL

Use the ____ data type for columns that contain letters and special characters and for columns containing numbers that will not be used in calculations.

To indicate columns that cannot contain null values,use the ____________________ clause in a CREATE TABLE statement.

In Oracle 11g Express,you enter a command in the SQL editor pane and then click the ____________________ button to execute the command.

To run SQL commands in Access,you must first create a new query.

In Access,it is common to create a table using SQL.

In Access,dates are enclosed in number signs and are entered using the format ____.

A file containing SQL commands is called a(n)____________________ file.

If you added a row that should not be in a table,use a REMOVE command to remove it.

In Oracle,the date,November 12,2015 would be stored as '12-NOV-2015'.

The ____________________ data type stores integers but uses less space than the INT data type.

The ____ data type stores only the actual character string.

In Access,use the ____________________ tool to describe the tables and other objects in a database.

Table names cannot contain spaces.

In SQL,table names cannot exceed ____ characters.

What is the original name of SQL?

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

Use the ____ data type for columns that contain letters and special characters and for columns containing numbers that will not be used in calculations.​

To indicate columns that cannot contain null values,use the ____________________ clause in a CREATE TABLE statement.​

In Oracle 11g Express,you enter a command in the SQL editor pane and then click the ____________________ button to execute the command.​

To run SQL commands in Access,you must first create a new query.​

In Access,it is common to create a table using SQL.​

In Access,dates are enclosed in number signs and are entered using the format ____.​

A file containing SQL commands is called a(n)____________________ file.​

If you added a row that should not be in a table,use a REMOVE command to remove it.​

In Oracle,the date,November 12,2015 would be stored as '12-NOV-2015'.​

The ____________________ data type stores integers but uses less space than the INT data type.​

The ____ data type stores only the actual character string.​

In Access,use the ____________________ tool to describe the tables and other objects in a database.​

Table names cannot contain spaces.​

In SQL,table names cannot exceed ____ characters.​

What is the original name of SQL?​

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

Use the ____ data type for columns that contain letters and special characters and for columns containing numbers that will not be used in calculations.

To indicate columns that cannot contain null values,use the ____________________ clause in a CREATE TABLE statement.

In Oracle 11g Express,you enter a command in the SQL editor pane and then click the ____________________ button to execute the command.

To run SQL commands in Access,you must first create a new query.

In Access,it is common to create a table using SQL.

In Access,dates are enclosed in number signs and are entered using the format ____.

A file containing SQL commands is called a(n)____________________ file.

If you added a row that should not be in a table,use a REMOVE command to remove it.

In Oracle,the date,November 12,2015 would be stored as '12-NOV-2015'.

The ____________________ data type stores integers but uses less space than the INT data type.

The ____ data type stores only the actual character string.

In Access,use the ____________________ tool to describe the tables and other objects in a database.

Table names cannot contain spaces.

In SQL,table names cannot exceed ____ characters.

What is the original name of SQL?