home   Query   contact
 
    logo  
  About
meet the crew
  Portfolio
have a look
  Courses
what we do
  Careers
step forward
  Gallery
our Album
     
         
   
MySql Quiz  Back
     

1. What SQL clause is used to restrict the rows returned by a query?

     WHEN
     WHERE
     FROM
     HAVING

2. Which one of the following represents a correct order for

     INSERT, INTO, SELECT, FROM, WHERE
     INSERT, INTO, WHERE, AND, VALUES
     INTO, INSERT, VALUES, FROM, WHERE
     SELECT, FROM, WHERE, INSERT, INTO

3. Which of the following commands should be used to create a database named “anderson”?

     CREATE DATABASE anderson
     CREATE –I anderson
     DATABASE /anderson
     SAVE

4. In a LIKE clause, you can could ask for any value ending in "qpt" by writing

     LIKE %qpt
     LIKE *ton
     LIKE ton$
     LIKE ^.*ton$

5. A NULL value is treated as a blank or 0.

     True
     False
     None of the above  

6. To remove duplicate rows from the result set of a SELECT use the following keyword:

     NO DUPLICATE
     UNIQUE
     DISTINCT
     None of the above

7. MySQL is

     A Programming language
     A Structure language
     A technique for writing reliable programs
     A Relational Database Management System

8. The result of a SELECT statement can contain duplicate rows.

     False
     True
     None of the above   

9. Which function used to get the current time in mysql?

     getTime()      
     Time()
     NOW()
     None of the above    

10. Which of the following is not a valid aggregate function?

     COUNT
     MIN
     MAX
     COMPUTE

11. The main MySQL program that does all the data handling is called?

     mysql.exe
     mysql
     mysqld
     httpd

12. Which of the following is used to delete an entire MYSQL database?

     mysql_drop_database
     mysql_drop_entiredb
     mysql_drop_db
     mysql_drop_dbase

13. A SELECT command without a WHERE clause returns?

     All the records from a table that match the previous WHERE clause
     All the records from a table, or information about all the records
     SELECT is invalid without a WHERE clause
     Nothing

14. MySQL supports the complete SQL99 standard

     True         False

15. Primary Key does allow the Null Values. where as in Unique key doesn't accept the Null values.

     True          False
    
 
 
 
   
 
 
footer