My Report (&Account)

MySQL Online Test


Correct Answer: 2 points | Wrong: -1 point
Grades: A* (100% score) | A (80%-99%) | B (60%-80%) | C (40%-60%) | D (0%-40%)

Here is the complete list of test quizzes on MySQL.

1. The number of tables for which DELAYED works is _________________

MyISAM, MEMORY, ARCHIVE, BLACKHOLE

Question 1 of 50

2. What is the meaning of the “WHERE” clause in Mysql?

Question 2 of 50

3. A DEFAULT value cannot be supplied to TEXT types.

Question 3 of 50

4. The library file that contains various portability macros and definitions is ______________

Question 4 of 50

5. The BIGINT precision is of bit _________

Question 5 of 50

6. In the following MySQL command how many rows will be deleted?

DELETE FROM person
WHERE person_id=1;
/*person_id is a primary key */

Question 6 of 50

7. Which variable is used to set table alias names as non-case sensitive?

Question 7 of 50

8. If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the following MySQL statement?

SELECT emp_id
FROM person
ORDER BY emp_id;

Question 8 of 50

9. How is the binary log rotated?

Question 9 of 50

10. The data directory subdirectory that corresponds to the nbdinfo database is ______________

Question 10 of 50

11. The 'C' in the ACID property of transactions is _______________

Question 11 of 50

12. Transactional processing requires lesser overhead due to CPU cycles and memory.

Question 12 of 50

13. If a column is expected to store values up to 2 million, the best datatype for it is _____________

Question 13 of 50

14. The connection parameters for setting up MySQL can be stored in an option file to save typing the names every time a connection is established.

Question 14 of 50

15. MySQL uses security based on ACL. What does it stand for?

Question 15 of 50

16. What is the kind of delete when deletion of an employee from the table also deletes that employee from another table?

Question 16 of 50

17. The left and right joins are also known as __________

Question 17 of 50

18. When linking to a static MySQL C client library, the client library and the client application must use the same compiler option.

Question 18 of 50

19. Which of the following statements is/are correct?

Question 19 of 50

20. The special database that always exists after setting up MySQL in a computer is __________

Question 20 of 50

21. To create a database only if it doesn't already exist, which clause is used?

Question 21 of 50

22. What will be the output of the following SQL statement?

SELECT person_id, fname, lname
FROM person
WHERE person_id=1;

Question 22 of 50

23. Illegal values converted to the appropriate 'zero' value for ______________

Question 23 of 50

24. Which of these can be used in place of MYSQL_SERVER_VERSION?

Question 24 of 50

25. The program that copies the databases from one server to another is ____________

Question 25 of 50

26. Which line of the following statements will produce error?

Question 26 of 50

27. Which data type character merges the “Check Constraint” into a data type definition?

Question 27 of 50

28. What is the non handle array representing a row of values?

Question 28 of 50

29. User defined variables are session specific.

Question 29 of 50

30. Which function returns an array of row values?

Question 30 of 50

31. Which table is preferred when there are many updates?

Question 31 of 50

32. The following MySQL statement is valid.

SELECT abc, xyz FROM table1 UNION abc, def FROM table2;

Question 32 of 50

33. Among the following, for which language is image processing least simple?

Question 33 of 50

34. Which among the following is the correct representation of “float(1,1)”?

Question 34 of 50

35. For a heavily used program, which of these languages should be preferred?

Question 35 of 50

36. Which command is used to display all the existing tables in a database?

Question 36 of 50

37. Which of the following functions are not performed by “ALTER” clause?

Question 37 of 50

38. The max_binlog_cache_size system variable has default size ______________

Question 38 of 50

39. In which mode is the indicator of the presence/absence of a word in search used?

Question 39 of 50

40. Which keyword used with UNION retains duplicate rows?

Question 40 of 50

41. The column not returned by 'OPTIMIZE TABLE' is _____________

Question 41 of 50

42. The command to see the warning messages is ______________

Question 42 of 50

43. Which option executes all SQL statements in a SQL script irrespective of the number of errors?

Question 43 of 50

44. What enables the read and execute access to all users outside of mysql group.

Question 44 of 50

45. The maximum number of indexes on MyISAM table is __________

Question 45 of 50

46. Which option is used in 'mysqldump' to make all tables in the destination databases to use a different storage engine?

Question 46 of 50

47. The place where the server stores its databases and status files are the data directory.

Question 47 of 50

48. How many options can be used to control LOCAL capability at runtime?

Question 48 of 50

49. In which mode of search is the search string parsed into words and the search looks for rows?

Question 49 of 50

50. What will be the output of the following MySQL statement “Null AND Null”?

Question 50 of 50


 

Topic wise Test Quizzes on MySQL

MySQL tests, quizzes, and exams are great ways to learn and test your MySQL skills. Whether you’re a beginner or experienced, challenge and boost your confidence with our engaging online quizzes on MySQL Basics, Data Type, Query, Perl DBI, MySQL Administration, Security, Database Maintenance, MySQL Backup, MySQL Operator and Condition. Start the MySQL online test now!

MySQL Basic Quiz

MySQL Data Type Quiz

MySQL Query Quiz

Perl DBI Quiz

MySQL Administration Quiz

MySQL Data Directory Quiz

MySQL Server Administration Quiz

MySQL Security Quiz

Database Maintenance Quiz

MySQL Backup Quiz

MySQL Operator Quiz

SQL Syntax Quiz

Select Statement Quiz

MySQL Condition Quiz


MySQL Certification Test

MySQL Certification Test is a free certification exam. However, you need to score an A grade in each of the "Certification Level Tests 1 to 10" to be eligible to take part in this certification test. So, take all the "10 Tests" starting from Certification Level 1 upto Level 10, before taking the final Certification test.

Level 1 Test Certification Test

Level 1 to 10 Tests:
Total Questions: 25, Total Time: 30 min, Correct Answer: 2 points, Wrong Answer: -1 point

Certification Test:
Total Questions: 50, Total Time: 1 hour, Correct Answer: 2 points, Wrong Answer: -1 point

MySQL Internship Test

If you scored either Grade A* or Grade A in our MySQL Internship Test, then you can apply for Internship at Sanfoundry in MySQL.

MySQL Internship Test

Total Questions: 50, Total Time: 1 hour, Correct Answer: 2 points, Wrong Answer: -1 point

MySQL Job Test

It is designed to test and improve your skills for a successful career, as well as to apply for jobs.

MySQL Job Test

Total Questions: 50, Total Time: 1 hour, Correct Answer: 2 points, Wrong Answer: -1 point

Note: Before you get started on these series of online tests, you should practice our collection of 1000 MCQs on MySQL .

Sanfoundry Scoring & Grading System

Sanfoundry tests and quizzes are designed to provide a real-time online exam experience. Here is what you need to know about them.

  • Scoring System: You get 2 points for each correct answer but lose 1 point for every wrong answer.
  • Grading System: Your grade depends on your final score and can be one of the following:

    • Grade A* - Genius (100%)
    • Grade A - Excellent (80% to 99%)
    • Grade B - Good (60% to 80%)
    • Grade C - Average (40% to 60%)
    • Grade D - Poor (0% to 40%)
advertisement
advertisement
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.