Mysql Compound Statements
- Stored programs refer to stored objects of how many of the following types?
functions, procedures, triggers, events
-
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.
- Stored routines refers to stored functions and procedures.
-
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.
- Which of the following characters cannot be used as a delimiter?
-
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.
- Which command is used to redefined the mysql delimiter?
-
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.
- Which character does the mysql client program recognize as a statement delimiter?
-
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.