Q421
Open questionThe log in which data changes received from a replication master server are written is . . . . . . . .
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
22/60
Page
Pick an option on a question to see the right answer and solution.
Q422
Open questionWhich statement on the master expires binary log files?
Select an option to see the answer and solution.
Q423
Open questionSELECT on a MERGE table is like . . . . . . . .
Select an option to see the answer and solution.
Q424
Open questionWhich option is used to specify to the server the IP number of the server host on which the server should listen?
Select an option to see the answer and solution.
Q425
Open questionA FULLTEXT index can be created for multiple columns.
Select an option to see the answer and solution.
Q426
Open questionIn the following SQL query, what does "person_id" stands for?
CREATE TABLE person
(person_ id SMALLINT UNSIGNED,
fname VARCHAR(20),
lname VARCHAR(20),
CONSTRAINT pk_person PRIMARY KEY (person_id));Select an option to see the answer and solution.
Q427
Open questionWhich table option for MyISAM tables reduces index flushing?
Select an option to see the answer and solution.
Q428
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++);Select an option to see the answer and solution.
Q429
Open questionWhich statement is used to access an existing Database?
Select an option to see the answer and solution.
Q430
Open questionThe connection parameters for setting up MySQL can be stored in an option file to save typing the names every time a connection is established.
Select an option to see the answer and solution.
Q431
Open questionWhich clause is used to remove a foreign key constraint?
Select an option to see the answer and solution.
Q432
Open questionThe argument to the function mysql_error() is . . . . . . . .
Select an option to see the answer and solution.
Q433
Open questionThe datatype best suited to store currency values is . . . . . . . .
Select an option to see the answer and solution.
Q434
Open questionIn which context is the privilege 'CREATE TABLESPACE' applied?
Select an option to see the answer and solution.
Q435
Open questionHow many of the following implement the default scheduling property of MySQL?
MyISAM, MERGE, MEMORYSelect an option to see the answer and solution.
Q436
Open questionThe binary protocol is easy to use.
Select an option to see the answer and solution.
Q437
Open questionWhat is the value of val2 in the following MySQL statement?
UPDATE t SET val1 = val1 + 2, val2 = val1;Select an option to see the answer and solution.
Q438
Open questionTo create or drop events for a database, which privilege should be granted?
Select an option to see the answer and solution.
Q439
Open questionWhen building from source, the embedded server library is enabled by what?
Select an option to see the answer and solution.
Q440
Open questionWhich command is used on Mysql command line tool to return to window command shell?
Select an option to see the answer and solution.