Question 1

You cannot use functions in WHERE clauses.

Accepted Answer

A) True 
 B)False

Question 2

In Oracle, SQL Server, and MySQL, you can round a numeric value to a desired number of decimal places using the _____.

Accepted Answer

A)   INT function
B)   FLOOR function
C)   ROUND function
D)   TRUNCATE functionE) None of the above
F) A) and C)

Question 3

Variable names in PL/SQL must start with a letter and can contain letters, dollar signs, underscores, and number signs, but cannot exceed _____.

Accepted Answer

A)   15 characters
B)   30 characters
C)   45 characters
D)   60 charactersE) B) and C)
F) A) and D)

Question 4

What are the three major advantages of cursors?

Accepted Answer

The coding in the procedure is greatly simplified. Normally in a program, the programmer must determine the most efficient way to access the data. In a program or procedure using embedded SQL, the optimizer determines the best way to access the data. The programmer isn't concerned with the best way to retrieve the data. In addition, when an underlying structure changes (for example, an additional index is created), the optimizer determines the best way to execute the query with the new structure. The program or procedure does not have to change at all. When the database structure changes in such a way that the necessary information is still obtainable using a different query, the only change required in the program or procedure is the cursor definition. The procedural code is not affected.

Question 5

When you need to complete tasks that are beyond the capabilities of SQL, you need to use a procedural language.

Accepted Answer

A) True 
 B)False

Question 6

When you use a cursor in a procedure, what command advances the cursor to the next row in the set of rows retrieved by the query and places the contents of the row in the indicated variables?

Accepted Answer

A)   RETRIEVE
B)   FETCH
C)   GET
D)   ADVANCEE) All of the above
F) C) and D)

Question 7

Identify and explain the error handling strategy used in the following procedure.

Accepted Answer

This MySQL procedure that takes a custom...

Question 8

Which function can you use in Oracle, MySQL, and SQL Server to truncate everything to the right of the decimal point?

Accepted Answer

A)   TRUNCATE
B)   FLOOR
C)   ROUND
D)   TRIME) C) and D)
F) B) and D)

Question 9

To remove extra spaces to the right of a value after concatenating two or more columns, use the _____.

Accepted Answer

A)   TRUNCATE function
B)   TRIM function
C)   FLOOR function
D)   RTRIM functionE) B) and C)
F) C) and D)

Question 10

In Oracle, to add a specific number of months to a date, use the _____.

Accepted Answer

A)   MONTHS function
B)   ADD_DATE function
C)   ADD_MONTHS function
D)   CALC_MONTHS functionE) A) and C)
F) B) and C)

Question 11

In MySQL, Oracle, and SQL server, you can display a value in lowercase letters using the _____.

Accepted Answer

A)   REGULAR function
B)   LCASE function
C)   SMALL function
D)   LOWER functionE) B) and D)
F) A) and B)

Question 12

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

Accepted Answer

A) True 
 B)False  False

Question 13

When you execute a stored procedure to retrieve a single row with embedded SQL, you need MySQL to treat several statements ending in a semicolon as if they were a single statement. What keyword do you use to tell MySQL to use a different character to signal the end of a statement in this situation?

Accepted Answer

A)   DELIMITER
B)   END
C)   OUT
D)   STATEMENTE) B) and C)
F) A) and D)

Question 14

Displaying a full name in query results when the first and last names are stored in separate columns in the database table is a typical use case for _____.

Accepted Answer

A)   calculations
B)   concatenation
C)   the UPPER function
D)   the ALTER TABLE commandE) C) and D)
F) A) and B) B

Question 15

Which command is used to call a procedure in SQL Server?

Accepted Answer

A)   CALL
B)   RUN
C)   DO
D)   EXECE) A) and B)
F) None of the above

Question 16

In SQL Server, you can obtain today's date using the _____.

Accepted Answer

A)   DATEDIFF()  function
B)   GETDATE()  function
C)   CURRENTDATE()  function
D)   SYSDATE functionE) A) and C)
F) A) and B)

Question 17

A stored procedure that includes an UPDATE command between the BEGIN and END commands is known as a(n)  _____.

Accepted Answer

A)   cursor procedure
B)   retrieval procedure
C)   display procedure
D)   update procedureE) A) and D)
F) C) and D)

Question 18

Which function displays a value in uppercase letters in Oracle and SQL Server?

Accepted Answer

A)   CAPITAL
B)   UPPER
C)   LARGE
D)   UCASEE) B) and D)
F) C) and D)

Question 19

Which of the following statements can you add to a stored procedure to provide meaningful feedback to a user who attempts to execute the procedure with an argument that is invalid because it is missing from the table column being queried?

Accepted Answer

A)   DECLARE EXIT HANDLER FOR NOT FOUND
B)   DECLARE EXIT HANDLER FOR INVALID ARGUMENT
C)   ERROR MESSAGE FOR NOT FOUND
D)   ERROR MESSAGE FOR INVALID ARGUMENTE) A) and B)
F) A) and C)

Question 20

Which statement about triggers is correct?

Accepted Answer

A)   In a trigger, the action that should cause the procedure to execute appears between BEGIN and END commands.
B)   In SQL Server, you create triggers using T-SQL.
C)   In a trigger, the actions the database should perform automatically appear in the AFTER clause.
D)   In Oracle, you cannot create triggers.E) A) and B)
F) A) and C)

Exam 8: Functions Procedures and Triggers

You cannot use functions in WHERE clauses.

Correct Answer
verified

In Oracle, SQL Server, and MySQL, you can round a numeric value to a desired number of decimal places using the _____.

Correct Answer
verified

Variable names in PL/SQL must start with a letter and can contain letters, dollar signs, underscores, and number signs, but cannot exceed _____.

Correct Answer
verified

What are the three major advantages of cursors?

When you need to complete tasks that are beyond the capabilities of SQL, you need to use a procedural language.

Correct Answer
verified

When you use a cursor in a procedure, what command advances the cursor to the next row in the set of rows retrieved by the query and places the contents of the row in the indicated variables?

Correct Answer
verified

Identify and explain the error handling strategy used in the following procedure.

Correct Answer
verified
This MySQL procedure that takes a custom...
View Answer

Which function can you use in Oracle, MySQL, and SQL Server to truncate everything to the right of the decimal point?

Correct Answer
verified

To remove extra spaces to the right of a value after concatenating two or more columns, use the _____.

Correct Answer
verified

In Oracle, to add a specific number of months to a date, use the _____.

Correct Answer
verified

In MySQL, Oracle, and SQL server, you can display a value in lowercase letters using the _____.

Correct Answer
verified

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

Correct Answer
verified
False

When you execute a stored procedure to retrieve a single row with embedded SQL, you need MySQL to treat several statements ending in a semicolon as if they were a single statement. What keyword do you use to tell MySQL to use a different character to signal the end of a statement in this situation?

Correct Answer
verified

Displaying a full name in query results when the first and last names are stored in separate columns in the database table is a typical use case for _____.

Correct Answer
verified
B

Which command is used to call a procedure in SQL Server?

Correct Answer
verified

In SQL Server, you can obtain today's date using the _____.

Correct Answer
verified

A stored procedure that includes an UPDATE command between the BEGIN and END commands is known as a(n) _____.

Correct Answer
verified

Which function displays a value in uppercase letters in Oracle and SQL Server?

Correct Answer
verified

Which of the following statements can you add to a stored procedure to provide meaningful feedback to a user who attempts to execute the procedure with an argument that is invalid because it is missing from the table column being queried?

Correct Answer
verified

Which statement about triggers is correct?

Correct Answer
verified

Exam 8: Functions Procedures and Triggers

You cannot use functions in WHERE clauses.

Correct AnswerverifiedShow Answer

In Oracle, SQL Server, and MySQL, you can round a numeric value to a desired number of decimal places using the _____.

Correct AnswerverifiedShow Answer

Variable names in PL/SQL must start with a letter and can contain letters, dollar signs, underscores, and number signs, but cannot exceed _____.

Correct AnswerverifiedShow Answer

What are the three major advantages of cursors?

When you need to complete tasks that are beyond the capabilities of SQL, you need to use a procedural language.

Correct AnswerverifiedShow Answer

When you use a cursor in a procedure, what command advances the cursor to the next row in the set of rows retrieved by the query and places the contents of the row in the indicated variables?

Correct AnswerverifiedShow Answer

Identify and explain the error handling strategy used in the following procedure.

Correct AnswerverifiedThis MySQL procedure that takes a custom...View AnswerShow Answer

Which function can you use in Oracle, MySQL, and SQL Server to truncate everything to the right of the decimal point?

Correct AnswerverifiedShow Answer

To remove extra spaces to the right of a value after concatenating two or more columns, use the _____.

Correct AnswerverifiedShow Answer

In Oracle, to add a specific number of months to a date, use the _____.

Correct AnswerverifiedShow Answer

In MySQL, Oracle, and SQL server, you can display a value in lowercase letters using the _____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse

When you execute a stored procedure to retrieve a single row with embedded SQL, you need MySQL to treat several statements ending in a semicolon as if they were a single statement. What keyword do you use to tell MySQL to use a different character to signal the end of a statement in this situation?

Correct AnswerverifiedShow Answer

Displaying a full name in query results when the first and last names are stored in separate columns in the database table is a typical use case for _____.

Correct AnswerverifiedB

Which command is used to call a procedure in SQL Server?

Correct AnswerverifiedShow Answer

In SQL Server, you can obtain today's date using the _____.

Correct AnswerverifiedShow Answer

A stored procedure that includes an UPDATE command between the BEGIN and END commands is known as a(n) _____.

Correct AnswerverifiedShow Answer

Which function displays a value in uppercase letters in Oracle and SQL Server?

Correct AnswerverifiedShow Answer

Which of the following statements can you add to a stored procedure to provide meaningful feedback to a user who attempts to execute the procedure with an argument that is invalid because it is missing from the table column being queried?

Correct AnswerverifiedShow Answer

Which statement about triggers is correct?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
This MySQL procedure that takes a custom...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified