Q1161
Open questionInstalling more memory into the machine enables to configure larger values for cache server.
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
59/60
Page
Pick an option on a question to see the right answer and solution.
Q1162
Open questionWhat will be the output of the following MySQL statement?
SELECT customer_id, product_id, avail_balance
FROM account
WHERE avail_balance BETWEEN 3000 AND 5000.Select an option to see the answer and solution.
Q1163
Open questionWhich parameter determines the shortest words to index in FULLTEXT indexes?
Select an option to see the answer and solution.
Q1164
Open questionThe privilege that must be given to the database to create a stored function or procedure is . . . . . . . .
Select an option to see the answer and solution.
Q1165
Open questionThe datatype that stores the longest length of strings is . . . . . . . .
Select an option to see the answer and solution.
Q1166
Open questionREGEXP does not take collation into account.
Select an option to see the answer and solution.
Q1167
Open questionWhat will be the output of the following SQL statement?
SELECT person_id, fname, lname
FROM person
WHERE person_id=1;Select an option to see the answer and solution.
Q1168
Open questionThe following MySQL statement belongs to which "Condition Types"?
SELECT emp_id, fname, lname
FROM account
WHERE start_date<’2007-10-08’;Select an option to see the answer and solution.
Q1169
Open questionThe operator that does not perform relative-value comparisons is . . . . . . . .
Select an option to see the answer and solution.
Q1170
Open questionHexadecimal values assigned to user variables are treated as . . . . . . . .
Select an option to see the answer and solution.
Q1171
Open questionIn the following SQL query, what does "person" stands for?
INSERT INTO person
(person_id, fname, lname)
VALUES (1,’S’,’P’);Select an option to see the answer and solution.
Q1172
Open question'2341' is a . . . . . . . .
Select an option to see the answer and solution.
Q1173
Open questionWhat cannot be done on a view?
Select an option to see the answer and solution.
Q1174
Open questionWhat will be the output of the following MySQL statement?
SELECT account_id, product_id, cust_id
FROM account
WHERE product_id NOT IN (‘sav’, ‘chd’, ‘mm’);Select an option to see the answer and solution.
Q1175
Open questionHow many values can be returned from a given stored function?
Select an option to see the answer and solution.
Q1176
Open questionWhich value of event_scheduler enables checking status but not changing it at runtime?
Select an option to see the answer and solution.
Q1177
Open questionWhat is the default format for "Datetime" data type?
Select an option to see the answer and solution.
Q1178
Open questionWhich Clause is used to select a particular table in Mysql?
Select an option to see the answer and solution.
Q1179
Open questionWhich authentications are required for login into Mysql command line tool?
Select an option to see the answer and solution.
Q1180
Open questionHow many options can be used to control LOCAL capability at runtime?
Select an option to see the answer and solution.