This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Basic Database Terminology”.
1. Which type of database management system is MySQL?
Explanation: MySQL is a ‘relational’ DBMS. It is efficient at relating data in two different tables and joining information from them. Hierarchical and Network DBMS are based on parent-child relationships of records. Object-oriented DBMS use objects to represent models.
2. What is data in a MySQL database organized into?
d) File systems
Explanation: Since MySQL is an RDBMS, it’s data is organised in tables for establishing relationships. A table is a collection of rows and columns, where each row is a record and columns describe the feature of records.
3. MySQL is freely available and is open source.
Explanation: MySQL is free and open source. It’s source code is available for use and is freely downloadable. It includes the MySQL Server, the world’s most popular open source database, and MySQL Cluster, a real-time, open source transactional database.
4. What represents an ‘attribute’ in a relational database?
Explanation: Each column in a table represents a feature (attribute) of a record. Table stores the information for an entity whereas a row represents a record. Object has no relevance in an RDBMS.
5. What represents a ‘tuple’ in a relational database?
Explanation: Each row in a table represents a record. A tuple is a collection of attribute values that makes a record unique. A tuple is a unique entity whereas attribute values can be duplicate in the table.
6. How is communication established with MySQL?
b) Network calls
c) A programming language like C++
Explanation: SQL is the standard language for RDBMS systems like MySQL. SQL queries facilitate quick information retrieval from tables and other elementary operations required to maintain an RDBMS system.
7. What does ‘name’ represent in the following code snippet?
CREATE TABLE student ( name CHAR(30), roll_num INT, address CHAR(30), phone CHAR(12) );
a) A table
b) A row
c) A column
d) An object
Explanation: ‘name’, ‘roll_num’, ‘address’ and ‘phone’ are the attributes in the table ‘student’. The CREATE TABLE construct in SQL creates a table, assigns a name to it and its attributes, and specifies the type of fields used in the table.
8. Which is the MySQL instance responsible for data processing?
a) MySQL client
b) MySQL server
d) Server daemon program
Explanation: MySQL uses the client-server architecture. The MySQL server program runs on the machine where databases are stored. SQL is a query language used for querying the tables and information retrieval.
9. The MySQL server used in its client/server architecture is _______________
Explanation: mysqld is the MySQL server program. It serves the incoming client requests by accessing the database. The others are not valid MySQL programs. MySQL implements a client/server architecture wherein mysqld is the server program.
10. In MySQL databases, the structure representing the organizational views of the entire databases is ____________
Explanation: The schema in a database gives a blueprint of the structure. A view is an object that can be generated with a query. A table is a collection of records. An instance is analogous to a class object.
Sanfoundry Global Education & Learning Series – MySQL Database.
To practice all areas of MySQL Database, here is complete set of 1000+ Multiple Choice Questions and Answers.