Question 1

To remove extra spaces to the right of a value,for example,the value in a FIRST_NAME column,use the ____ function.

Accepted Answer

A) TRUNCATE 
B) ​TRIM 
C) RIGHT 
D) ​RTRIM

Question 2

____________________ is the procedural language that SQL Server uses.

Accepted Answer

The answer of ____________________ is the procedural language that SQL...

Question 3

What are the three advantages of cursors?

Accepted Answer

The answer of What are the three advantages of cursors?...

Question 4

You cannot use functions in WHERE clauses.

Accepted Answer

A) True 
 B)False

Question 5

To handle processing of errors,include a(n)____________________ clause in stored procedure.

Accepted Answer

The answer of To handle processing of errors,include a(n)____________________ clause...

Question 6

In T-SQL,all arguments start with the ampersand (&)symbol.

Accepted Answer

A) True 
 B)False

Question 7

In SQL Server,the cursor property ____________________ means that the cursor is used for retrieval purposes only.

Accepted Answer

The answer of In SQL Server,the cursor property ____________________ means...

Question 8

Microsoft Access supports triggers.

Accepted Answer

A) True 
 B)False

Question 9

Oracle,SQL Server,and Access all use the ADD_MONTHS function to add the number of months to a date.

Accepted Answer

A) True 
 B)False

Question 10

To create a stored procedure,use the CREATE PROCEDURE command.

Accepted Answer

A) True 
 B)False

Question 11

The UPPER function allows you to manipulate numeric data.

Accepted Answer

A) True 
 B)False

Question 12

In Microsoft Access,the ____ function displays a value in uppercase letters.

Accepted Answer

A) CAPITAL 
B) ​LARGE 
C) UPPER 
D) ​UCASE

Question 13

In procedural languages,you can accomplish many tasks using a single command.

Accepted Answer

A) True 
 B)False

Question 14

A function can have more than one argument.

Accepted Answer

A) True 
 B)False

Question 15

To call a procedure in SQL Server,use the EXEC command.

Accepted Answer

A) True 
 B)False

Question 16

In Oracle and SQL Server,use the ____ function to truncate everything to the right of the decimal point.

Accepted Answer

A) TRUNCATE 
B) ​FLOOR 
C) REMOVE 
D) ​TRIM

Question 17

If a price is 24.95,the function ROUND(PRICE,0)would result in 24.

Accepted Answer

A) True 
 B)False

Question 18

In SQL Server,use the & symbol to concatenate columns.

Accepted Answer

A) True 
 B)False

Question 19

In the function UPPER(LAST_NAME),the item in parentheses (LAST_NAME)is called the ____________________ for the function.

Accepted Answer

The answer of In the function UPPER(LAST_NAME),the item in parentheses...

Question 20

In Access,use the & symbol to concatenate columns.

Accepted Answer

A) True 
 B)False

Exam 8: SQL Functions and Procedures

To remove extra spaces to the right of a value,for example,the value in a FIRST_NAME column,use the ____ function.

____________________ is the procedural language that SQL Server uses.

What are the three advantages of cursors?

You cannot use functions in WHERE clauses.

To handle processing of errors,include a(n)____________________ clause in stored procedure.

In T-SQL,all arguments start with the ampersand (&)symbol.

In SQL Server,the cursor property ____________________ means that the cursor is used for retrieval purposes only.

Microsoft Access supports triggers.

Oracle,SQL Server,and Access all use the ADD_MONTHS function to add the number of months to a date.

To create a stored procedure,use the CREATE PROCEDURE command.

The UPPER function allows you to manipulate numeric data.

In Microsoft Access,the ____ function displays a value in uppercase letters.

In procedural languages,you can accomplish many tasks using a single command.

A function can have more than one argument.

To call a procedure in SQL Server,use the EXEC command.

In Oracle and SQL Server,use the ____ function to truncate everything to the right of the decimal point.

If a price is 24.95,the function ROUND(PRICE,0)would result in 24.

In SQL Server,use the & symbol to concatenate columns.

In the function UPPER(LAST_NAME),the item in parentheses (LAST_NAME)is called the ____________________ for the function.

In Access,use the & symbol to concatenate columns.