Q1101
Open questionWhat is the synonym for CHARACTER SET?
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
56/60
Page
Pick an option on a question to see the right answer and solution.
Q1102
Open questionWhich statement is used to check how MySQL would execute a SELECT query?
Select an option to see the answer and solution.
Q1103
Open questionThe most important configurable resource for MyISAM is . . . . . . . .
Select an option to see the answer and solution.
Q1104
Open questionWhat is the table name in the following SQL code?
INSERT INTO student VALUES('Kyle','M',NULL);Select an option to see the answer and solution.
Q1105
Open questionWhat does mysql_query() return on failure?
Select an option to see the answer and solution.
Q1106
Open questionQualifying the name of column with the table name is not necessary in single-table updates.
Select an option to see the answer and solution.
Q1107
Open questionThe security context when a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access is . . . . . . . .
Select an option to see the answer and solution.
Q1108
Open questionConsider a database name "db_name" whose attributes are intern_id (primary key), subject.
Intern_id = {1, 2, 3, 4, 5, 6}
Subject = {sql, oop, sql, oop, c, c++}
If these are one to one relation then what will be the output of the following MySQL statement?
Intern_id = {1, 2, 3, 4, 5, 6}
Subject = {sql, oop, sql, oop, c, c++}
If these are one to one relation then what will be the output of the following MySQL statement?
SELECT intern_id
FROM db_name
WHERE subject IN (c, c++, oop);Select an option to see the answer and solution.
Q1109
Open questionThe following MySQL statement belongs to which condition types?
SELECT fname
FROM person
WHERE dept_id= (SELECT dept_id FROM department WHERE names=’s’);Select an option to see the answer and solution.
Q1110
Open questionThe program that copies the databases from one server to another is . . . . . . . .
Select an option to see the answer and solution.
Q1111
Open questionWhich among the following is not a "query clause"?
Select an option to see the answer and solution.
Q1112
Open questionThe function used to convert an int to string is . . . . . . . .
Select an option to see the answer and solution.
Q1113
Open questionBy default, the AUTO_INCREMENT sequences begin at . . . . . . . .
Select an option to see the answer and solution.
Q1114
Open questionWhich MySQL statement is used to find out which character sets are available?
Select an option to see the answer and solution.
Q1115
Open questionIn Perl DBI, functions are called . . . . . . . .
Select an option to see the answer and solution.
Q1116
Open questionSuppose a stored function named PI() is written in the database 'sampdb'. How would it be called?
Select an option to see the answer and solution.
Q1117
Open questionWhich string function returns the index of the first occurrence of substring?
Select an option to see the answer and solution.
Q1118
Open questionThe server sets its default time zone by examining its environment.
Select an option to see the answer and solution.
Q1119
Open questionThe superuser account of the grant tables in the mysql database is called . . . . . . . .
Select an option to see the answer and solution.
Q1120
Open questionWhile using DBI API functions are called and pointers to structures are used.
Select an option to see the answer and solution.