Q661
Open questionWhich of the following characters is illegal in naming an unquoted identifier in SQL?
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
34/60
Page
Pick an option on a question to see the right answer and solution.
Q662
Open questionWhat loads data files into tables?
Select an option to see the answer and solution.
Q663
Open questionThe slow query log is written as . . . . . . . .
Select an option to see the answer and solution.
Q664
Open questionMultiple MySQL servers can be easily run on the same machine.
Select an option to see the answer and solution.
Q665
Open questionWhere does MySQL Enterprise Backup record details of each backup?
Select an option to see the answer and solution.
Q666
Open questionWhich log does the event scheduler log to?
Select an option to see the answer and solution.
Q667
Open questionThe default scheduling property of MySQL is implemented by how many of these?
MyISAM, MERGE, MEMORYSelect an option to see the answer and solution.
Q668
Open questionWhich spatial datatype is used to store a curve?
Select an option to see the answer and solution.
Q669
Open questionThe comma operator can also be used to join tables.
Select an option to see the answer and solution.
Q670
Open questionWhat returns a result to the client?
Select an option to see the answer and solution.
Q671
Open questionConverting a client/server application to embedded server is simpler.
Select an option to see the answer and solution.
Q672
Open questionThe system variable to maintain InnoDB log buffer size is . . . . . . . .
Select an option to see the answer and solution.
Q673
Open questionThe AUTO_INCREMENT column attribute is best used with . . . . . . . .
Select an option to see the answer and solution.
Q674
Open questionHow do the STRICT_ALL_TABLES and STRICT_TRANS_TABLES mode values deal with bad data?
Select an option to see the answer and solution.
Q675
Open questionWhich of the following is the correct order of precedence (high to low)?
Select an option to see the answer and solution.
Q676
Open questionIs it necessary to insert the value in each column of the table?
Select an option to see the answer and solution.
Q677
Open questionIssuing 'SELECT' on a MERGE table is like . . . . . . . .
Select an option to see the answer and solution.
Q678
Open questionThe JDBI interface is available for . . . . . . . .
Select an option to see the answer and solution.
Q679
Open questionWhich system variable enables mysqld to keep more tables open simultaneously?
Select an option to see the answer and solution.
Q680
Open questionThe synonym for last_insert_id session variable is . . . . . . . .
Select an option to see the answer and solution.