Q341
Open questionIn the following SQL command "person" stands for?
SELECT person_id, fname, lname, Birth_date FROM person;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
18/60
Page
Pick an option on a question to see the right answer and solution.
Q342
Open questionIP numbers can be represented as . . . . . . . .
Select an option to see the answer and solution.
Q343
Open questionWhat will be the output of the following MySQL statement?
SELECT *
FROM employee
WHERE lname LIKE ‘F%’ OR lname LIKE ‘%T’;Select an option to see the answer and solution.
Q344
Open questionWhat is the meaning of "Range Conditions"?
Select an option to see the answer and solution.
Q345
Open questionWhat is a synonym for CHARACTER SET?
Select an option to see the answer and solution.
Q346
Open questionWhich program emulates the client load for a MySQL server?
Select an option to see the answer and solution.
Q347
Open questionUsage of aggregates in WHERE clause is not allowed.
Select an option to see the answer and solution.
Q348
Open questionThe clause that can be used to sort string values according to a specific collation is . . . . . . . .
Select an option to see the answer and solution.
Q349
Open questionWhich column attribute provides unique numbers for identification?
Select an option to see the answer and solution.
Q350
Open questionWhich among the following is the correct syntax for modifying the definition of an existing table?
Select an option to see the answer and solution.
Q351
Open questionWhat produces result sets?
Select an option to see the answer and solution.
Q352
Open questionWhich command is used to redefined the mysql delimiter?
Select an option to see the answer and solution.
Q353
Open questionHow is the binary log rotated?
Select an option to see the answer and solution.
Q354
Open questionThe place where the server stores its databases and status files are called the data directory.
Select an option to see the answer and solution.
Q355
Open questionWhich script initializes the data directory during installation?
Select an option to see the answer and solution.
Q356
Open questionThe mode used to turn off the special meaning of backslash and treat it as an ordinary character is . . . . . . . .
Select an option to see the answer and solution.
Q357
Open questionWhich of the following columns is not returned by 'OPTIMIZE TABLE'?
Select an option to see the answer and solution.
Q358
Open questionWhat is the name of the format file for a table named my_tbl?
Select an option to see the answer and solution.
Q359
Open questionThe Perl DBI is . . . . . . . .
Select an option to see the answer and solution.
Q360
Open questionSelect odd one out?
Select an option to see the answer and solution.