Which of the following ways below are the correct way to get the current date?
All options are correct
Well Done. Your Answer is Correct Keep it Up!
SELECT CURTIME();
SELECT CURDATE();
SLELCT CURRRENT_TIME()
Tag: MySQL MCQs
In a SELECT with a GROUP BY clause, a WHERE clause, and a HAVING clause, the WHERE conditions are applied before the HAVING conditions.
In a SELECT with a GROUP BY clause, a WHERE clause, and a HAVING clause, the WHERE conditions are applied before the HAVING conditions.
TRUE
Well Done. Your Answer is Correct Keep it Up!
FALSE
Primary Key does allow the Null Values. where as in Unique key doesn’t accept the Null values.
Primary Key does allow the Null Values. where as in Unique key doesn’t accept the Null values.
FALSE
Well Done. Your Answer is Correct Keep it Up!
TRUE
Which of the following is used to delete an entire MYSQL database?
Which of the following is used to delete an entire MYSQL database?
mysql_drop_db
Well Done. Your Answer is Correct Keep it Up!
mysql_drop_entiredb
mysql_drop_database
None of the options are correct
In PHP in order to access MySQL database you will use:
In PHP in order to access MySQL database you will use:
mysql_connect() function
Well Done. Your Answer is Correct Keep it Up!
sql_connect() function
mysql-connect() function
mysqlconnect() function
To remove duplicate rows from the result set of a SELECT use the following keyword:
To remove duplicate rows from the result set of a SELECT use the following keyword:
DISTINCT
Well Done. Your Answer is Correct Keep it Up!
UNIQUE
NO DUPLICATE
None of the options are correct
What’s the difference between the DESCRIBE and SHOW FIELDS FROM commands?
What’s the difference between the DESCRIBE and SHOW FIELDS FROM commands?
Nothing – they’re the same thing
Well Done. Your Answer is Correct Keep it Up!
Only DESCRIBE can take a LIKE clause
Only SHOW FIELDS FROM can take a LIKE clause
None of the options are correct
Which of these field types would be best to hold a .jpg image?
Which of these field types would be best to hold a .jpg image?
blob
Well Done. Your Answer is Correct Keep it Up!
text
nchar binary
char binary
Which of the following is available in MySQL:
Which of the following is available in MySQL:
CREATE DATABASE
Well Done. Your Answer is Correct Keep it Up!
CREATE TRIGGER
CREATE SCHEMA
CREATE VIEW
In a LIKE clause, you can ask for any 6 letter value by writing:
In a LIKE clause, you can ask for any 6 letter value by writing:
LIKE ______ (that’s six underscore characters)
Well Done. Your Answer is Correct Keep it Up!
LIKE .{6}
LIKE ^.{6}$
LIKE …… (that’s six dots)