Q981
Open questionFor which type are illegal values converted to the appropriate 'zero' value?
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
50/60
Page
Pick an option on a question to see the right answer and solution.
Q982
Open questionThe command to move the cursor to the beginning of line in MySQL input editor is?
Select an option to see the answer and solution.
Q983
Open questionWhat will be the output of the following MySQL statement?
SELECT *
FROM employee
WHERE lname LIKE ‘F%’ AND lname LIKE ‘%T’;Select an option to see the answer and solution.
Q984
Open questionmysql_init() returns a . . . . . . . .
Select an option to see the answer and solution.
Q985
Open questionThe columns containing a binary value that include null bytes will print properly using the %s printf() format specifier.
Select an option to see the answer and solution.
Q986
Open questionWhich of the following is case sensitive?
Select an option to see the answer and solution.
Q987
Open questionWhat is the host name in the following MySQL command?
mysql -h cobra.snake.net -p -u sampadamSelect an option to see the answer and solution.
Q988
Open questionTo convert a string to an int, the function is . . . . . . . .
Select an option to see the answer and solution.
Q989
Open questionDoes the following MySQL statement belong to the "Inequality condition"?
SELECT product_type.name, product.name
FROM product_type INNER JOIN Product
ON product_type.dept=Product.dept
WHERE product_type.name<>’customers_accounts’;Select an option to see the answer and solution.
Q990
Open questionThe line that is written at the top of the script to write a Perl script using CGI.pm is . . . . . . . .
Select an option to see the answer and solution.
Q991
Open questionWhich keyword in the UPDATE statement is used to assign values to columns?
Select an option to see the answer and solution.
Q992
Open questionWhich of these has a smaller memory footprint?
Perl, PHPSelect an option to see the answer and solution.
Q993
Open questionWhich keyword is used to create a database?
Select an option to see the answer and solution.
Q994
Open questionBefore relocation of database, the server should be stopped if running.
Select an option to see the answer and solution.
Q995
Open questionWhat is abc in the following SQL statement?
DELETE FROM xyz WHERE abc = 5;Select an option to see the answer and solution.
Q996
Open questionWhich mode tells the server to recognize double quote as an identifier quoting character?
Select an option to see the answer and solution.
Q997
Open questionWhat is abc in the following MySQL statement?
CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;Select an option to see the answer and solution.
Q998
Open questionWhen linking to a static MySQL C client library, the client library and the client application can use different compiler options.
Select an option to see the answer and solution.
Q999
Open questionTo perform a delete on a single-table, how is the name of a column qualified?
Select an option to see the answer and solution.
Q1000
Open questionFor which of the following are triggers not supported?
Select an option to see the answer and solution.