Which grant table scope columns are case insensitive?
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
3/60
Page
Pick an option on a question to see the right answer and solution.
The context in which the privilege 'CREATE TABLESPACE' applies is . . . . . . . .
Select an option to see the answer and solution.
Which of the following characters cannot be used as a delimiter?
Select an option to see the answer and solution.
What is abc in the following MySQL statement?
SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');Select an option to see the answer and solution.
The spatial datatype used to store a curve is . . . . . . . .
Select an option to see the answer and solution.
The binary protocol is more difficult to use.
Select an option to see the answer and solution.
In MySQL, the default size of the key buffer in MB is . . . . . . . .
Select an option to see the answer and solution.
The functions in Perl DBI called?
Select an option to see the answer and solution.
Which operator is used to check the expression is not "NULL"?
Select an option to see the answer and solution.
Which declaration represents that "character data will consume the same number of bytes as declared and is right padded"?
Select an option to see the answer and solution.
What is the statement used to select a default database?
Select an option to see the answer and solution.
Multiple MySQL servers can be run on the same machine.
Select an option to see the answer and solution.
Mysql command line tool is used to show "how many rows are returned and how long SQL command took to execute".
Select an option to see the answer and solution.
Find the missing clause from the following SQL statement?
CREATE VIEW person_1 AS
SELECT fname, lname, person_id
_________ person;Select an option to see the answer and solution.
AUTO_INCREMENT columns must be NOT NULL.
Select an option to see the answer and solution.
Which of these take more space?
Variable length columns, Fixed length columnsSelect an option to see the answer and solution.
The server listens on a network port for TCP/IP connections unless started with the option . . . . . . . .
Select an option to see the answer and solution.
Stored routines refers to stored functions and procedures.
Select an option to see the answer and solution.
The maximum length of the varchar columns is . . . . . . . .
Select an option to see the answer and solution.
The keyword used with UNION that does not retain duplicate rows is . . . . . . . .
Select an option to see the answer and solution.