Q921
Open questionThe place where the server stores its databases and status files are the database directory.
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
47/60
Page
Pick an option on a question to see the right answer and solution.
Q922
Open questionThe log that contains a record of server startups and shutdowns and the messages about exceptional conditions is . . . . . . . .
Select an option to see the answer and solution.
Q923
Open questionWhat is the datatype for single precision floating point number?
Select an option to see the answer and solution.
Q924
Open questionThe option that suppresses output unless there are errors in the table is . . . . . . . .
Select an option to see the answer and solution.
Q925
Open questionWhat does the default case sensitivity of database and table names depend on?
Select an option to see the answer and solution.
Q926
Open questionWhich variable is a handle to a database object?
Select an option to see the answer and solution.
Q927
Open questionHow many of these are for use with only MyISAM tables?
mysql, mysqladmin, mysqldump, mysqlisamchkSelect an option to see the answer and solution.
Q928
Open questionIs there any error in executing the following MySQL command?
SELECT emp_id, ‘ACTIVE’,
emp_id * 3.145,
UPPER (lname)
FROM Employee;Select an option to see the answer and solution.
Q929
Open questionThe option that executes all SQL statements in a SQL script irrespective of the number of errors is . . . . . . . .
Select an option to see the answer and solution.
Q930
Open questionTo produce a stored function, which statement is used?
Select an option to see the answer and solution.
Q931
Open questionCHECK TABLE works with how many of the following?
MyISAM, ARCHIVE, CSVSelect an option to see the answer and solution.
Q932
Open questionStored programs improve database security.
Select an option to see the answer and solution.
Q933
Open questionWhich is the join in which all the rows from the right table appear in the output irrespective of the content of the other table?
Select an option to see the answer and solution.
Q934
Open questionWhat is the special database that always exists after setting up MySQL on a computer?
Select an option to see the answer and solution.
Q935
Open questionWhat is the general term for information about databases and the objects in MySQL?
Select an option to see the answer and solution.
Q936
Open questionMultiple statement execution is enabled by default.
Select an option to see the answer and solution.
Q937
Open questionThe expression 12 DIV 5 evaluates to . . . . . . . .
Select an option to see the answer and solution.
Q938
Open questionCalculations involving numbers are faster than those involving string.
Select an option to see the answer and solution.
Q939
Open questionTo combine multiple retrievals, we write several SELECT statements and put the keyword between them. What is the keyword?
Select an option to see the answer and solution.
Q940
Open questionIf attribute "fruit" stores data as "apple, mango, banana" in table person then what will be the output of the following SQL command?
SELECT fruit FROM person
WHERE person_id=1
ORDER BY fruit;Select an option to see the answer and solution.