Question 1

You use the ____________________ command to describe the layout of a table.​

Accepted Answer

The answer of You use the ____________________ command to describe...

Question 2

The data type DECIMAL(5,2)represents a number with ____________________ places to the left and two places to the right of the decimal.​

Accepted Answer

The answer of The data type DECIMAL(5,2)represents a number with...

Question 3

You can use the ____________________ data type to store date data.​

Accepted Answer

The answer of You can use the ____________________ data type...

Question 4

SQL was developed as the data manipulation language for IBM's prototype relational model DBMS,System R.​

Accepted Answer

A) True 
 B)False

Question 5

In SQL Server,execute the sp_columns command to list all the columns in a table.

Accepted Answer

A) True 
 B)False

Question 6

To display all the rows and columns in a table,type the word SELECT,followed by a(n)____,followed by the word FROM and then the name of the table containing the data you want to view.​

Accepted Answer

A) single quote 
B) ​asterisk 
C) double quote 
D) ​slash

Question 7

The data type DECIMAL(5,2)represents a number with three places to the left and two places to the right of the decimal.​

Accepted Answer

A) True 
 B)False

Question 8

Access does not use script files.

Accepted Answer

A) True 
 B)False

Question 9

In Oracle,what is the script repository?​

Accepted Answer

The answer of In Oracle,what is the script repository?​...

Question 10

Which of the following commands changes the value in a column?​

Accepted Answer

A) UPDATE 
B) ​CHANGE 
C) REPLACE 
D) ​ADD

Question 11

The Oracle Database 11 g Express edition allows you to save a command so you can use it again without retyping it.​

Accepted Answer

A) True 
 B)False

Question 12

In SQL,you cannot enter an apostrophe into a column whose type is character (CHAR).

Accepted Answer

A) True 
 B)False

Question 13

The ____________________ command adds rows to a table.​

Accepted Answer

The answer of The ____________________ command adds rows to a...

Question 14

In Oracle,use the ____________________ command to list all columns in a table and their properties.​

Accepted Answer

The answer of In Oracle,use the ____________________ command to list...

Question 15

Access does not support the ____ data type.​

Accepted Answer

A) DECIMAL 
B) ​CURRENCY 
C) INT 
D) ​NUMBER

Question 16

In Access,use the Documenter tool to describe the tables in a database.​

Accepted Answer

A) True 
 B)False

Question 17

You can use the ____________________ command to update a value in a table.​

Accepted Answer

The answer of You can use the ____________________ command to...

Question 18

The ____ data type is used to store integers.​

Accepted Answer

A) INTEGER 
B) ​NUMERAL 
C) NUMBER 
D) ​INT

Question 19

You can delete the entire table using the ____________________ TABLE command.​

Accepted Answer

The answer of You can delete the entire table using...

Question 20

If you need to delete a row from a table,you can use the ____________________ command.​

Accepted Answer

The answer of If you need to delete a row...

Exam 3: Creating Tables

You use the ____________________ command to describe the layout of a table.

The data type DECIMAL(5,2)represents a number with ____________________ places to the left and two places to the right of the decimal.

You can use the ____________________ data type to store date data.

SQL was developed as the data manipulation language for IBM's prototype relational model DBMS,System R.

In SQL Server,execute the sp_columns command to list all the columns in a table.

To display all the rows and columns in a table,type the word SELECT,followed by a(n) ____,followed by the word FROM and then the name of the table containing the data you want to view.

The data type DECIMAL(5,2)represents a number with three places to the left and two places to the right of the decimal.

Access does not use script files.

In Oracle,what is the script repository?

Which of the following commands changes the value in a column?

The Oracle Database 11 g Express edition allows you to save a command so you can use it again without retyping it.

In SQL,you cannot enter an apostrophe into a column whose type is character (CHAR).

The ____________________ command adds rows to a table.

In Oracle,use the ____________________ command to list all columns in a table and their properties.

Access does not support the ____ data type.

In Access,use the Documenter tool to describe the tables in a database.

You can use the ____________________ command to update a value in a table.

The ____ data type is used to store integers.

You can delete the entire table using the ____________________ TABLE command.

If you need to delete a row from a table,you can use the ____________________ command.

Exam 3: Creating Tables

You use the ____________________ command to describe the layout of a table.​

The data type DECIMAL(5,2)represents a number with ____________________ places to the left and two places to the right of the decimal.​

You can use the ____________________ data type to store date data.​

SQL was developed as the data manipulation language for IBM's prototype relational model DBMS,System R.​

In SQL Server,execute the sp_columns command to list all the columns in a table.

To display all the rows and columns in a table,type the word SELECT,followed by a(n) ____,followed by the word FROM and then the name of the table containing the data you want to view.​

The data type DECIMAL(5,2)represents a number with three places to the left and two places to the right of the decimal.​

Access does not use script files.

In Oracle,what is the script repository?​

Which of the following commands changes the value in a column?​

The Oracle Database 11 g Express edition allows you to save a command so you can use it again without retyping it.​

In SQL,you cannot enter an apostrophe into a column whose type is character (CHAR).

The ____________________ command adds rows to a table.​

In Oracle,use the ____________________ command to list all columns in a table and their properties.​

Access does not support the ____ data type.​

In Access,use the Documenter tool to describe the tables in a database.​

You can use the ____________________ command to update a value in a table.​

The ____ data type is used to store integers.​

You can delete the entire table using the ____________________ TABLE command.​

If you need to delete a row from a table,you can use the ____________________ command.​

You use the ____________________ command to describe the layout of a table.

The data type DECIMAL(5,2)represents a number with ____________________ places to the left and two places to the right of the decimal.

You can use the ____________________ data type to store date data.

SQL was developed as the data manipulation language for IBM's prototype relational model DBMS,System R.

To display all the rows and columns in a table,type the word SELECT,followed by a(n) ____,followed by the word FROM and then the name of the table containing the data you want to view.

The data type DECIMAL(5,2)represents a number with three places to the left and two places to the right of the decimal.

In Oracle,what is the script repository?

Which of the following commands changes the value in a column?

The Oracle Database 11 g Express edition allows you to save a command so you can use it again without retyping it.

The ____________________ command adds rows to a table.

In Oracle,use the ____________________ command to list all columns in a table and their properties.

Access does not support the ____ data type.

In Access,use the Documenter tool to describe the tables in a database.

You can use the ____________________ command to update a value in a table.

The ____ data type is used to store integers.

You can delete the entire table using the ____________________ TABLE command.

If you need to delete a row from a table,you can use the ____________________ command.