Q241
Open questionWhich of the following options tells mysql to ask for entering the password?
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
13/60
Page
Pick an option on a question to see the right answer and solution.
Q242
Open questionIs "Datetime" and "Timestamp" are same data type?
Select an option to see the answer and solution.
Q243
Open questionThe bit-field values are prefixed with . . . . . . . .
Select an option to see the answer and solution.
Q244
Open questionIn UNIX, the name of the option file is . . . . . . . .
Select an option to see the answer and solution.
Q245
Open questionIn which table of INFORMATION_SCHEMA is the information about table index characteristics stored?
Select an option to see the answer and solution.
Q246
Open questionmysql_fetch_row() returns . . . . . . . .
Select an option to see the answer and solution.
Q247
Open questionHow would a stored function named PI() written in the database 'sampdb' be called?
Select an option to see the answer and solution.
Q248
Open questionWhat column names are displayed when this SQL command is executed?
SHOW COLUMNS FROM tbl_name LIKE '%name';Select an option to see the answer and solution.
Q249
Open questionWhat does 'A' stand for in the ACID property of transactions?
Select an option to see the answer and solution.
Q250
Open questionWhat is known as the set of SQL statements that either executes successfully or none of them have an effect?
Select an option to see the answer and solution.
Q251
Open questionIs duplicate entry of primary key is allowed in SQL?
Select an option to see the answer and solution.
Q252
Open questionThe columns containing binary value that include null bytes will not print properly using the %s printf() format specifier.
Select an option to see the answer and solution.
Q253
Open questionMySQL uses security based on ACL. What does it stand for?
Select an option to see the answer and solution.
Q254
Open questionFind out the logical error in the following MySQL code snippet?
CREATE TABLE person
( person_id VARCHAR(20),
Name VARCHAR (20),
Address VARCHAR (20),
Mobile_no SMALLINT
);Select an option to see the answer and solution.
Q255
Open questionTo disallow zero month or day parts in dates, the option used is . . . . . . . .
Select an option to see the answer and solution.
Q256
Open questionWhich statement is used to force the optimizer to use tables in a particular order?
Select an option to see the answer and solution.
Q257
Open questionWhich option suppresses output unless there are errors in the table?
Select an option to see the answer and solution.
Q258
Open questionHow many values can be returned from a stored procedure?
Select an option to see the answer and solution.
Q259
Open questionThe server is told to accept spaces after function names by . . . . . . . .
Select an option to see the answer and solution.
Q260
Open questionThe following SQL statement is invalid.
SELECT abc, xyz FROM table1 UNION abc, def FROM table2;Select an option to see the answer and solution.