Q581
Open questionWhich keyword is used to delete all the rows from the 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
30/60
Page
Pick an option on a question to see the right answer and solution.
Q582
Open questionThe 'A' in the ACID property of transactions is . . . . . . . .
Select an option to see the answer and solution.
Q583
Open questionThe recovery of data changes made since a given point in time is called . . . . . . . .
Select an option to see the answer and solution.
Q584
Open questionWhat is the Perl DBI?
Select an option to see the answer and solution.
Q585
Open questionThe indicator of presence or absence of a word in search is used in which mode?
Select an option to see the answer and solution.
Q586
Open questionTO enable the compressed client/server protocol the option is . . . . . . . .
Select an option to see the answer and solution.
Q587
Open questionIncreasing the value of which system variable enables mysqld to keep more tables open simultaneously?
Select an option to see the answer and solution.
Q588
Open questionWhich mode exists at both global level and session-specific level?
Select an option to see the answer and solution.
Q589
Open questionPHP scripts are located in the web client document tree.
Select an option to see the answer and solution.
Q590
Open questionMultiple statement execution is disabled by default.
Select an option to see the answer and solution.
Q591
Open questionWhich function returns a reference to hash of row values?
Select an option to see the answer and solution.
Q592
Open questionWhat is the default value of column?
Select an option to see the answer and solution.
Q593
Open questionThe default definer of an event is the user who . . . . . . . .
Select an option to see the answer and solution.
Q594
Open questionWhich of these columns are faster?
Variable length, Fixed lengthSelect an option to see the answer and solution.
Q595
Open questionHow many of the following use NULL to indicate failure?
mysql_init(), mysql_real_connect()Select an option to see the answer and solution.
Q596
Open questionWhat will be the output of the following MySQL statement "NOT (Null)"?
Select an option to see the answer and solution.
Q597
Open questionNumbers prefixed with '0x' are in base . . . . . . . .
Select an option to see the answer and solution.
Q598
Open questionTo convert an int to string, the function is . . . . . . . .
Select an option to see the answer and solution.
Q599
Open questionIn PHP, if $a represents an array with numeric indices, how is the first element accessed?
Select an option to see the answer and solution.
Q600
Open questionWhich system variable tells the optimizer to skip certain plans based on estimates of the number of rows accessed for each table?
Select an option to see the answer and solution.