MYSQL MCQ and Answers – Part 1
MYSQL MCQs questions with answers to prepare for exams, tests, and certifications. These questions are taken from a real written exam and some parts are taken from an interview. So you will find questions on MySQL Database, SQL query, Data Model, and more. This MCQ will easily prepare anyone to pass their exam.
1. MySQL is a(n) _________ database management system ?
A Object oriented
B Hierarchical
C Relational
D Network
C
MySQL is a relational DBMS. It links data in different tables and attaches information to them. Hierarchical and network DBMS are based on parent-child relationships. The object-oriented DBMS uses objects to represent models.
2. What is the data in a MySQL database??
A Objects
B Tables
C Networks
D File systems
B
Since MySQL is an RDBMS, its data is organized in the form of tables to establish relationships. A table is a collection of rows and columns, where each row is a record and the columns describe the functionality of the records.
3. MySQL is available for free? Is it open source?
A True
B False
A
MySQL is free and open source. Its source code is available and can be downloaded for free. It includes a MySQL server, transactional database, etc.
4. How the communication is established with MySQL server?
A SQL
B Network calls
C A programming language like C++
D APIs
A
SQL is the standard language for RDBMS systems like MySQL. SQL queries facilitate quick access to information stored in tables and other basic operations required to maintain an RDBMS system.
5. What is a tuple in a relational database?
A Table
B Row
C Column
D Object
B
Each row in a table represents a record. A tuple is a collection of values that makes a record unique.
6. What represents an attribute in a relational database?
A Table
B Row
C Column
D Object
C
Each column in a table represents a characteristic (attribute) of a record. The table stores information for an entity while a row represents a record.
7. Which statement is used to select a database?
A USE
B CREATE
C DROP
D SCHEMA
A
MySQL has the ability to use different statements specifically at the database level. To select a default database, “USE” keyword is used.
8. What keyword is the synonym for DATABASE?
A TABLE
B OBJECT
C DB
D SCHEMA
D
In any statement where the word “DATABASE” occurs, the keyword “SCHEMA” may be used as a synonym instead of it. In the literal sense, SCHEMA refers to the structure of a database.
9. What keyword is used to create a database?
A CREATE
B SET
C SETUP
D LINK
A
CREATE DATABASE statement is used to create a database. A database qualifier must be used to specify the fully qualified name of the database.
10. The file created by the server to store the database attributes is _____?
A db.otp
B dp.zip
C db.opt
D db.cls
C
Whenever a database is created in MySQL, the MySQL server creates a directory with the same name as the database. It creates the file db.opt to store the attributes.
- MYSQL MCQ and Answers – Part 1
- MYSQL MCQ and Answers – Part 2
- MYSQL MCQ and Answers – Part 3
- MYSQL MCQ and Answers – Part 4
- MYSQL MCQ and Answers – Part 5
- MYSQL MCQ and Answers – Part 6
- MYSQL MCQ and Answers – Query optimization
- MySQL Practice Exercises with Solutions – Part 1
- MySQL Practice Exercises with Solutions – Part 2
- MySQL Practice Exercises with Solutions – Part 3
- MySQL Practice Exercises with Solutions – Part 4
- MySQL Practice Exercises with Solutions – Part 5
- MySQL Practice Exercises with Solutions – Part 6
- MySQL Practice Exercises with Solutions – Part 7
- MySQL Practice Exercises with Solutions – Country Database – Part 8
- MySQL Practice Exercises with Solutions – Ordering System Database – Part 9
Best of best