Q321
Open questionWhich is the library file that contains various portability macros and definitions?
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
17/60
Page
Pick an option on a question to see the right answer and solution.
Q322
Open question"COUNT" keyword belongs to which categories in Mysql?
Select an option to see the answer and solution.
Q323
Open questionWhich clause can be used to sort string values according to a specific collation?
Select an option to see the answer and solution.
Q324
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 NOT IN (c, c++);Select an option to see the answer and solution.
Q325
Open questionWhich statement is used to delete an existing row from the table?
Select an option to see the answer and solution.
Q326
Open questionIn the following MySQL command how many rows will be updated?
UPDATE person
SET lname=’s’,
Fname=’p’,
WHERE person_id<10;
/* person_id is a primary key */Select an option to see the answer and solution.
Q327
Open questionA stored program associated with a schedule is . . . . . . . .
Select an option to see the answer and solution.
Q328
Open questionIn MySQL databases, the structure representing the organizational views of the entire databases is . . . . . . . .
Select an option to see the answer and solution.
Q329
Open questionOn UNIX, statements entered in 'MySQL' are saved in which file?
Select an option to see the answer and solution.
Q330
Open questionWhich is the correct format to store date in the SQL?
Select an option to see the answer and solution.
Q331
Open questionThe function load_defaults() reads the option files.
Select an option to see the answer and solution.
Q332
Open questionWhich of these operators does not perform relative-value comparisons?
Select an option to see the answer and solution.
Q333
Open questionWhen a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access, the security context is . . . . . . . .
Select an option to see the answer and solution.
Q334
Open questionWhat is the TLS protocol?
Select an option to see the answer and solution.
Q335
Open questionWhich table in the 'INFORMATION_SCHEMA' stores information about storage engines and server plugins?
Select an option to see the answer and solution.
Q336
Open questionIs there any error in the following MySQL statement?
SELECT e.emp_id, e.fname,e.lname,d.name
FROM employee e INNER JOIN department d
ON e.dept_id=e.dept_id;Select an option to see the answer and solution.
Q337
Open questionThe variable that is a handle to a database object is . . . . . . . .
Select an option to see the answer and solution.
Q338
Open questionWhat is def in the following MySQL statement?
DECLARE abc HANDLER FOR def ghi;Select an option to see the answer and solution.
Q339
Open questionA multiple-table delete can apply any join.
Select an option to see the answer and solution.
Q340
Open questionThe header that should be included first is . . . . . . . .
Select an option to see the answer and solution.