Q441
Open questionAn uncorrelated subquery does not contain any reference to the values from the outer query.
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
23/60
Page
Pick an option on a question to see the right answer and solution.
Q442
Open questionWhich of these return a result to the client?
Select an option to see the answer and solution.
Q443
Open questionPHP variables are preceded by . . . . . . . .
Select an option to see the answer and solution.
Q444
Open questionSymlink is an applicable relocation method for . . . . . . . .
Select an option to see the answer and solution.
Q445
Open questionHow many of the following take a connection handler as an argument?
mysql_store_result(), mysql_use_result()Select an option to see the answer and solution.
Q446
Open questionFind the error in the following SQL statement?
CREATE TABLE person
( person_id SMALLINT, name VARCHAR, LAST VARCHAR
CONSTRAINTS pk_person PRIMARY KEY (person_id));
INSERT INTO person
VALUES( person_id, name, LAST)
(1, ’s’, ’p’);
INSERT INTO person
( person_id, name, LAST)
VALUES(1,’s’,’p’);Select an option to see the answer and solution.
Q447
Open questionThe statement used to find out which character sets are available is . . . . . . . .
Select an option to see the answer and solution.
Q448
Open questionIs there any error in the following MySQL command?
SELECT emp_id, title, start_date, fname, fed_id
FROM person
ORDER BY RIGHT (fed_id, 3);Select an option to see the answer and solution.
Q449
Open questionAvoiding NULL in columns may make queries simpler.
Select an option to see the answer and solution.
Q450
Open questionWhich clause is used to "Identifies table from which to draw table and how the table should be joined"?
Select an option to see the answer and solution.
Q451
Open questionWhat is 'tamp' in the following MySQL command?
mysql -h xyz.host.try.net -p -u tampSelect an option to see the answer and solution.
Q452
Open questionWhat does 'abc' & 'xyz' specify in the following SQL statement?
CREATE TABLE abc (xyz);Select an option to see the answer and solution.
Q453
Open questionWhich server mode value disables use of built in function names as identifiers?
Select an option to see the answer and solution.
Q454
Open questionIf a string is to be converted to a number, it is converted into a . . . . . . . .
Select an option to see the answer and solution.
Q455
Open questionTo determine whether query cache is supported by the server the variable is . . . . . . . .
Select an option to see the answer and solution.
Q456
Open questionThe number of options that can be used to control LOCAL capability at runtime is . . . . . . . .
Select an option to see the answer and solution.
Q457
Open questionThe UNION ALL has a higher precedence than UNION DISTINCT.
Select an option to see the answer and solution.
Q458
Open questionThe number of attributes in the following SQL table is . . . . . . . .
CREATE TABLE employee (
emp_name CHAR(30),
emp_id INT
);Select an option to see the answer and solution.
Q459
Open questionThe facility that allows nesting one select statement into another is called . . . . . . . .
Select an option to see the answer and solution.
Q460
Open questionCGI.pm also supports an object oriented style of use.
Select an option to see the answer and solution.