If you’re writing a client using the C language API, your source code should include the following line at the top:
#include
Well Done. Your Answer is Correct Keep it Up!
use mysql;
include (“mysql.h”);
import com.mysql.*;
Tag: MySQL MCQs
Commands passed to the MySQL daemon are written in
Commands passed to the MySQL daemon are written in
the Structured Query Language
Well Done. Your Answer is Correct Keep it Up!
Your choice from Perl, PHP, Java or some other languages
English
Swedish
In a LIKE clause, you can could ask for any value ending in “ton” by writing?
In a LIKE clause, you can could ask for any value ending in “ton” by writing?
LIKE %ton
Well Done. Your Answer is Correct Keep it Up!
LIKE .*ton
LIKE ^.*ton$
LIKE ton$
How much character are allowed to create database name?
How much character are allowed to create database name?
64
Well Done. Your Answer is Correct Keep it Up!
55
72
40
Which statement is used to count number of rows in table?
Which statement is used to count number of rows in table?
SELECT COUNT(*) FROM table_name;
Well Done. Your Answer is Correct Keep it Up!
SELECT COUNT ALL(*) FROM table_name;
SELECT ROWS(*) FROM table_name;
All options are correct
Which of these commands will delete a table called XXX if you have appropriate authority?
Which of these commands will delete a table called XXX if you have appropriate authority?
DROP TABLE XXX
Well Done. Your Answer is Correct Keep it Up!
DROP XXX WHERE confirm = “YES”
DELETE XXX WHERE confirm = “YES”
DROP XXX
Which command returns current version on MySQL?
Which command returns current version on MySQL?
SELECT VERSION();
Well Done. Your Answer is Correct Keep it Up!
SELECT VERSION(“MySQL”);
SELECT MySQLVERSION();
All options are correct
Which clause is used to sort the result of SELECT statement?
Which clause is used to sort the result of SELECT statement?
ORDER BY
Well Done. Your Answer is Correct Keep it Up!
SORT BY
ARRANGE BY
None of the options are correct
Which datatypes are treated as arrays
Which datatypes are treated as arrays
String
Well Done. Your Answer is Correct Keep it Up!
Integer
Float
Booleans
In order to add a new column to an existing table in SQL, we can use the command
In order to add a new column to an existing table in SQL, we can use the command
ALTER TABLE
Well Done. Your Answer is Correct Keep it Up!
ALTER COLUMNS
EDIT TABLE
MODIFY TABLE