If you’re writing a client using the C language API, your source code should include the following line at the top: September 2, 2021September 2, 2021 administrator If you’re writing a client using the C language API, your source code should include the following line at the top:#includeWell 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 September 2, 2021September 2, 2021 administrator Commands passed to the MySQL daemon are written in the Structured Query LanguageWell Done. Your Answer is Correct Keep it Up!Your choice from Perl, PHP, Java or some other languagesEnglishSwedish
In a LIKE clause, you can could ask for any value ending in “ton” by writing? September 2, 2021September 2, 2021 administrator In a LIKE clause, you can could ask for any value ending in “ton” by writing?LIKE %tonWell Done. Your Answer is Correct Keep it Up!LIKE .*tonLIKE ^.*ton$LIKE ton$
How much character are allowed to create database name? September 2, 2021September 2, 2021 administrator How much character are allowed to create database name?64Well Done. Your Answer is Correct Keep it Up!557240
Which statement is used to count number of rows in table? September 2, 2021September 2, 2021 administrator 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? September 2, 2021September 2, 2021 administrator Which of these commands will delete a table called XXX if you have appropriate authority?DROP TABLE XXXWell 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? September 2, 2021September 2, 2021 administrator 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? September 2, 2021September 2, 2021 administrator Which clause is used to sort the result of SELECT statement?ORDER BYWell Done. Your Answer is Correct Keep it Up!SORT BYARRANGE BYNone of the options are correct
Which datatypes are treated as arrays September 2, 2021September 2, 2021 administrator Which datatypes are treated as arraysStringWell Done. Your Answer is Correct Keep it Up!IntegerFloatBooleans
In order to add a new column to an existing table in SQL, we can use the command September 2, 2021September 2, 2021 administrator In order to add a new column to an existing table in SQL, we can use the commandALTER TABLEWell Done. Your Answer is Correct Keep it Up! ALTER COLUMNSEDIT TABLEMODIFY TABLE