Q881
Open questionWhat are PHP variables preceded by?
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
45/60
Page
Pick an option on a question to see the right answer and solution.
Q882
Open questionWhen the security context enables carefully written stored programs to be set up that provide controlled access to tables for users, it is called . . . . . . . .
Select an option to see the answer and solution.
Q883
Open questionINT3 maps to MySQL type . . . . . . . .
Select an option to see the answer and solution.
Q884
Open questionWhich "text type" has the maximum number of bytes?
Select an option to see the answer and solution.
Q885
Open questionWhat does 'name' represent in the following SQL code snippet?
CREATE TABLE student
(
name CHAR(30),
roll_num INT,
address CHAR(30),
phone CHAR(12)
);Select an option to see the answer and solution.
Q886
Open questionWhich of these is used during MySQL setup?
Select an option to see the answer and solution.
Q887
Open questionWhich clause is used to display information that matches a given pattern?
Select an option to see the answer and solution.
Q888
Open questionFind the error in the following SQL statement?
SELECT *;Select an option to see the answer and solution.
Q889
Open questionIs duplicate entry of other attributes are allowed in SQL?
Select an option to see the answer and solution.
Q890
Open questionWhat is defined to execute when the table is modified only?
Select an option to see the answer and solution.
Q891
Open questionThe max_binlog_cache_size system variable has default size . . . . . . . .
Select an option to see the answer and solution.
Q892
Open questionWhen building from source, the embedded server library is enabled by . . . . . . . .
Select an option to see the answer and solution.
Q893
Open questionWhich system variable when set to 1, makes all temporary tables to get stored on disk rather than in memory?
Select an option to see the answer and solution.
Q894
Open questionMysql support different character sets, which command is used to display all character sets?
Select an option to see the answer and solution.
Q895
Open questionWhich upgrade involves exporting existing data using mysqldump?
Select an option to see the answer and solution.
Q896
Open questionWhich of the following MySQL statements is valid if '`sampledb`' is a database and '`tbl`' is a table in it?
Select an option to see the answer and solution.
Q897
Open questionThe return value from operations returning a row count is . . . . . . . .
Select an option to see the answer and solution.
Q898
Open questionWhat is the meaning of "REFERENCES" in table definition?
Select an option to see the answer and solution.
Q899
Open questionThe stored-routine privileges are contained in . . . . . . . .
Select an option to see the answer and solution.
Q900
Open questionWhich clause is used to "group rows together by common columns values"?
Select an option to see the answer and solution.