Q121
Open questionWhich command is used to show all tables that are stored in a database?
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
7/60
Page
Pick an option on a question to see the right answer and solution.
Q122
Open questionComparing a known value with NULL results into . . . . . . . .
Select an option to see the answer and solution.
Q123
Open questionThe 'SOCKET' protocol is permitted on which operating systems?
Select an option to see the answer and solution.
Q124
Open questionWhat is the property of InnoDB that enforces foreign key relationships stay intact?
Select an option to see the answer and solution.
Q125
Open questionThe following MySQL statement is valid.
SELECT abc, xyz FROM table1 UNION abc, def FROM table2;Select an option to see the answer and solution.
Q126
Open questionWhat is the use of "VIEW" in Mysql?
Select an option to see the answer and solution.
Q127
Open questionSuppose the last row has the AUTO_INCREMENT column value 32. Suppose a new row is added by setting AUTO_INCREMENT value equal to 100. The next row added will have value . . . . . . . .
Select an option to see the answer and solution.
Q128
Open questionSuppose run_me.sh is a script file. Which command is used to make it executable?
Select an option to see the answer and solution.
Q129
Open questionWhich clause specifies periodic execution at fixed intervals?
Select an option to see the answer and solution.
Q130
Open questionThere can be only one column per table with the AUTO_INCREMENT attribute.
Select an option to see the answer and solution.
Q131
Open questionWhich is the correct decreasing order for highly developed text manipulation capabilities?
Select an option to see the answer and solution.
Q132
Open questionWhich privilege must be given to the database to create a stored function or procedure?
Select an option to see the answer and solution.
Q133
Open questionFor which language is the engine specific interface PDO defined?
Select an option to see the answer and solution.
Q134
Open questionWhich keyword used with UNION does not retain duplicate rows?
Select an option to see the answer and solution.
Q135
Open questionOS imposes per process limits on the number of open file descriptors.
Select an option to see the answer and solution.
Q136
Open questionWhich among the following belongs to an "aggregate function"?
Select an option to see the answer and solution.
Q137
Open questionTriggers are not supported for . . . . . . . .
Select an option to see the answer and solution.
Q138
Open questionThe system variable controls the size of the table cache . . . . . . . .
Select an option to see the answer and solution.
Q139
Open questionThe case sensitive among these is . . . . . . . .
Select an option to see the answer and solution.
Q140
Open questionThe size of the BIT type is . . . . . . . .
Select an option to see the answer and solution.