Q181
Open questionThe left and right joins are also known as . . . . . . . .
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
10/60
Page
Pick an option on a question to see the right answer and solution.
Q182
Open questionHow is the output from PHP generated?
Select an option to see the answer and solution.
Q183
Open questionWhich upgrade involves shutting down the old MySQL version and replacing the old binaries?
Select an option to see the answer and solution.
Q184
Open questionMySQL does not automatically convert a date or time value to a number if the value is used in a numeric context.
Select an option to see the answer and solution.
Q185
Open questionArrays can have associative indices in PHP.
Select an option to see the answer and solution.
Q186
Open questionA password applies globally to an account.
Select an option to see the answer and solution.
Q187
Open questionThe table that lists the column level privileges is . . . . . . . .
Select an option to see the answer and solution.
Q188
Open questionWhich among the following is the correct syntax for creating table?
Select an option to see the answer and solution.
Q189
Open questionWhich search mode uses natural language search as a subroutine?
Select an option to see the answer and solution.
Q190
Open questionThe ALL subquery performs the operation . . . . . . . .
Select an option to see the answer and solution.
Q191
Open questionWhat will be the result of the following MySQL command?
WHERE end_date IS NULL
AND NOT (title=’teller’ OR start_date < ‘2007-01-01’)Select an option to see the answer and solution.
Q192
Open questionHow many among the following use NULL to indicate failure?
mysql_init(), mysql_real_connect()Select an option to see the answer and solution.
Q193
Open questionTo minimize disk I/O, which of these should be chosen?
CHAR, VARCHARSelect an option to see the answer and solution.
Q194
Open questionThe statement to remove indexes on tables is . . . . . . . .
Select an option to see the answer and solution.
Q195
Open questionArrays cannot have associative indices in PHP.
Select an option to see the answer and solution.
Q196
Open questionWhich keyword suppresses errors?
Select an option to see the answer and solution.
Q197
Open questionWhich declaration doesn't use the same number of bytes and consumption of bytes depends on the input data?
Select an option to see the answer and solution.
Q198
Open questionThe option that is necessary to compile a C program having math functions is . . . . . . . .
Select an option to see the answer and solution.
Q199
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, SQL);Select an option to see the answer and solution.
Q200
Open questionFor a heavily used program, which of these languages should be preferred?
Select an option to see the answer and solution.