Machine-translated by Google. Questions are authored in English.
Top

Discussion

Which of the following is true concerning a procedure?

  • A.You do not create them with SQL.
  • B.They do not need to have a unique name.
  • C.They include procedural and SQL statements.
  • D.They are the same thing as a function.

Answer: C

Correct answer: They include procedural and SQL statements.

A stored procedure combines SQL with the procedural constructs SQL lacks - variables, conditionals, loops, exception handling - so logic that would otherwise sit in an application can live in the database. It is created with SQL, must be uniquely named, and differs from a function in that it need not return a value.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.