If you’re writing a client using the C language API, your source code should include the following line at the top:

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.*;

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
Page 1 of 3
1 2 3