MySQL MCQ (Multiple Choice Questions)

Here are 1000 MySQL MCQ (Chapterwise).

1. What is MySQL?
a) An operating system
b) A relational database management system (RDBMS)
c) A programming language
d) A web server
View Answer

2. What does “MySQL” stand for?
a) My Sequence Query Language
b) My Structured Query Language
c) Mine Sequence Query Language
d) My Special Query Language
View Answer

3. Who developed MySQL?
a) MySQL AB
b) Microsoft
c) Oracle Corporation
d) Sun Microsystems
View Answer

4. Which type of database management system is MySQL?
a) Network
b) Object-oriented
c) Relational
d) Hierarchical
View Answer

5. Which of the following best describes the purpose of MySQL?
a) To store and retrieve data
b) To create user interfaces
c) To build websites
d) To manage file systems
View Answer

6. Which query language does MySQL use?
a) NoSQL
b) JavaScript
c) Structured Query Language (SQL)
d) MongoDB Query Language
View Answer

7. Which is the MySQL instance responsible for data processing?
a) MySQL server
b) SQL
c) MySQL client
d) Server daemon program
View Answer

8. MySQL is commonly used as the database component in which software stack?
a) LAMP
b) MERN
c) JAM
d) MEAN
View Answer

9. How are identifiers quoted in MySQL?
a) double quotes
b) backticks
c) can’t be quoted
d) single quotes
View Answer

10. Which of the following is case sensitive in MySQL?
a) Column names
b) Event names
c) Logfile group names
d) Indexes
View Answer

11. What is ‘xyz’ in the following SQL statement?

SELECT abc FROM xyz;

a) database name
b) row name
c) table name
d) column name
View Answer

12. Which storage engine enables to access tables from a MySQL server managed by another server?
a) MyISAM
b) FEDERATED
c) EXAMPLE
d) InnoDB
View Answer

13. What is data in a MySQL database organized into?
a) Tables
b) Networks
c) Objects
d) File systems
View Answer

14. Which operator is used to perform integer divisions in MySQL?
a) /
b) DIV
c) \
d) //
View Answer

15. Which of the following options tells MySQL to ask for entering the password?
a) -u
b) -p
c) -h
d) -e
View Answer

16. Which statement can be used to specify the sql_mode system variable at runtime?
a) ASSIGN
b) SET
c) CHANGE
d) SPECIFY
View Answer

17. The command to move the cursor to the beginning of line in MySQL input editor is?
a) Ctrl-E
b) Ctrl-A
c) Ctrl-D
d) Esc-a
View Answer

18. Which of the following does not support a materialized view?
a) PostgreSQL
b) Oracle
c) MySQL
d) SybaseSQL
View Answer

19. What is x in the following MySQL statement?

DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;

a) column name
b) server name
c) database name
d) table name
View Answer

20. Which command is used for taking “server side help” in MySQL command line tool?
a) /h
b) /c
c) /e
d) None of the mentioned
View Answer

21. What is the role of “CONSTRAINTS” in defining a table in MySQL?
a) Declaring Foreign Key
b) Declaring primary key
c) Restrictions on columns
d) All of the mentioned
View Answer

22. Which Clause is used to select a particular table in MySQL?
a) ALTER
b) SELECT
c) FROM
d) WHERE
View Answer

23. Which data type is used to store data and time in MySQL?
a) Temporal data type
b) Char/Varchar
c) Text data type
d) Numeric data type
View Answer

24. What is def in the following MySQL statement?

CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;

a) trigger name
b) table name
c) trigger statement
d) update statement
View Answer

25. To check how MySQL would execute a SELECT query, which statement is used?
a) EXPLAIN
b) SHOW
c) DISPLAY
d) TELL
View Answer

26. Which of the following are the valid “database datatypes” in MySQL?
a) Temporal
b) Numerical
c) All of the mentioned
d) Text
View Answer

27. What is the meaning of “EMPTY SET” in the following MySQL command?

SELECT fname, lname, person_id
FROM person
WHERE lname=’s’;
/* after Execution*/ Mysql tool RETURNS EMPTY SET 0:00sec

a) Access denied
b) No values
c) Error
d) None of the mentioned
View Answer

28. Which of these is not used to connect to the MySQL server?
a) mysqlcheck
b) mysql
c) mysqladmin
d) mysql_upgrade
View Answer

29. Which of the following can be used interchangeably with MYSQL_VERSION_ID?
a) MYSQL_VERSION_ID
b) MYSQL_ID
c) LIBMYSQL_VERSION
d) LIBMYSQL_VERSION_ID
View Answer

30. Which mode prevents MySQL from performing a full check of date parts?
a) ALLOW_DATES_INVALID
b) STOP_DATES_CHECK
c) PREVENT_DATE_CHECK
d) ALLOW_INVALID_DATES
View Answer

31. What is the most important configurable resource for MyISAM?
a) speed cache
b) time cache
c) key cache
d) memory cache
View Answer

32. Which upgrade involves exporting existing data using mysqldump?
a) logical
b) inplace
c) system
d) illogical
View Answer

33. What enables read and execute access to all users outside of the MySQL group?
a) drwxrwxr-x
b) drwxrwxr-y
c) drwyrwyr-y
d) drwyrwyr-x
View Answer

34. What is the hub of a MySQL installation?
a) mysqlc
b) mysqld
c) mysqla
d) mysqlb
View Answer

35. Where does MySQL Enterprise Backup record details of each backup?
a) backup_history
b) backlog_history
c) history_backup
d) history_backlog
View Answer

36. Which of the following is not a valid MySQL aggregate function?
a) MAX
b) COUNT
c) ADD
d) AVG
View Answer

37. Which classes do spatial data types in MySQL correspond to?
a) ClosedGIS
b) ClosedGSS
c) OpenGIS
d) OpenGSS
View Answer

38. What does mysql_fetch_row() return?
a) integer
b) pointer
c) structure
d) float
View Answer

39. What is the meaning of the “SELECT” clause in MySQL?
a) Show me all rows
b) Show me all columns
c) Show me all Columns and rows
d) None of the mentioned
View Answer

40. Which MySQL clause is used to combine rows from two or more tables?
a) JOIN
b) COMBINE
c) MERGE
d) UNION
View Answer

41. What will be the result of the following MySQL command?

SELECT emp_id,
‘ACTIVE’ AS STATUS,
emp_id * 3.14 AS emp_pi,
UPPER (lname) AS last_name
FROM employee;

a) emp_id, ACTIVE, emp_id * 314, UPPER(lname)
b) emp_id, Status, emp_pi, last_name
c) Error
d) None of the mentioned
View Answer

42. What will be the output of the following MySQL statement “true AND Null”?
a) Null
b) True
c) None of the mentioned
d) Depend
View Answer

43. Which clause is similar to the “HAVING” clause in MySQL?
a) FROM
b) WHERE
c) SELECT
d) None of the mentioned
View Answer

44. Which of the following MySQL data types can hold large amounts of data such as text?
a) INT
b) ENUM
c) BLOB
d) VARCHAR
View Answer

45. What does the function mysql_num_rows() return?
a) A pointer to the result set
b) The number of rows in a result set
c) The current row in a result set
d) The number of columns in a result set
View Answer

46. What will be the order of sorting in the following MySQL statement?

SELECT emp_id, emp_name
FROM person
ORDER BY emp_id, emp_name;

a) Sorting {emp_name, emp_id}
b) None of the mentioned
c) Sorting {emp_id, emp_name}
d) Sorting {emp_id} but not emp_name
View Answer

47. What does the function mysql_fetch_assoc() return?
a) Array of associative key-value pairs
b) Array of indexed values
c) Boolean value
d) String
View Answer

48. Which privileges are required on the source server to use mysqldbcopy?
a) UPDATE
b) CREATE
c) SELECT
d) INSERT
View Answer

1. General MySQL Use
2. Using SQL to Manage Data
3. Data Types
4. Stored Programs
5. Query Optimization
6. MySQL Programming
7. MySQL Programs Using C
8. MySQL Programs Using Perl DBI and PHP
9. MySQL Administration
10. MySQL Data Directory
11. General MySQL Administration
12. Access Control and Security
13. Database Maintenance, Backups and Replication
14. Data Type Reference, Operators and Functions
15. System, Status and User Variables
16. SQL Syntax
17. Select Statement
18. Nulls and Conditions and Miscellaneous