Mysql Compound Statements


  1. Stored programs refer to stored objects of how many of the following types?
    functions, procedures, triggers, events











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: A

    In MySQL, the “stored programs” refers collectively to the stored objects of all types, namely, the functions, procedures, triggers, and events. They improve database security.


  1. Stored routines refers to stored functions and procedures.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    In MySQL, the stored routines is a limited term. It refers only to the stored functions and procedures. Both types of objects are defined using the similar syntax and are discussed together.



  1. Which of the following characters cannot be used as a delimiter?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    In MySQL, the character backslash character is reserved for specifying escape sequences. For example, the escape sequence ‘\t’ specifies a tab space character. It cannot be used as a delimiter.


  1. Which command is used to redefined the mysql delimiter?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    To redefine the mysql delimiter, the delimiter command is used. A delimiter is a sequence of characters. It specifies the boundary between the separate regions in data streams.



  1. Which character does the mysql client program recognize as a statement delimiter?











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    By default, mysql itself recognizes the semicolon as a statement delimiter, so the delimiter must be redefined temporarily to cause mysql to pass the entire stored program definition to the server.