Which statement can be used for modifying the definition for an existing table?
Select an option to see the answer and solution.
MySQL · all questionsMySQL
MySQL
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
1,185
Questions
4/60
Page
Pick an option on a question to see the right answer and solution.
The function used to convert a string to an int is . . . . . . . .
Select an option to see the answer and solution.
What jobs "Query Optimizer" perform in Mysql?
Select an option to see the answer and solution.
The BIGINT precision is of bit . . . . . . . .
Select an option to see the answer and solution.
The string function that returns the index of the first occurrence of substring is . . . . . . . .
Select an option to see the answer and solution.
Multiple MySQL servers cannot be run on the same machine.
Select an option to see the answer and solution.
What does RTF refer to?
Select an option to see the answer and solution.
The LOCAL capability for client library is enabled by . . . . . . . .
Select an option to see the answer and solution.
The variable used as a handle to an open file is . . . . . . . .
Select an option to see the answer and solution.
What is the maximum length for alias names in terms of characters?
Select an option to see the answer and solution.
The default storage engine used is . . . . . . . .
Select an option to see the answer and solution.
The number of values that can be returned from a given stored function is . . . . . . . .
Select an option to see the answer and solution.
A synonym for CHARACTER SET is . . . . . . . .
Select an option to see the answer and solution.
The IN, OUT and INOUT keywords do not apply to stored functions.
Select an option to see the answer and solution.
To perform consistency checks on a MyISAM table the statement is . . . . . . . .
Select an option to see the answer and solution.
The character that the MySQL client program recognizes as a statement delimiter is . . . . . . . .
Select an option to see the answer and solution.
Which system variable controls the size of the table cache?
Select an option to see the answer and solution.
The embedded server library containing the MySQL server linkable into applications is . . . . . . . .
Select an option to see the answer and solution.
How many of the following return rows?
SELECT, SHOW, DESCRIBESelect an option to see the answer and solution.
Which of these modes is a composite server mode?
Select an option to see the answer and solution.