MySQL - Creating Databases and Tables MCQ

MySQL – Creating Databases and Tables MCQ

1 / 25

1. What is the primary purpose of creating a database in MySQL?

Storing tables

Running SQL queries

Creating reports

Organizing and structuring data

2 / 25

2. How can you create a new database in MySQL using SQL commands?

CREATE TABLE

NEW DATABASE

CREATE DATABASE

ADD DATABASE

3 / 25

3. Which of the following is NOT a recommended database naming convention in MySQL?

Avoid special characters

Stick to alphanumeric and underscores

Use spaces and symbols

Use clear and meaningful names

4 / 25

4. What is the primary purpose of creating tables in MySQL?

To run SQL queries

To organize and structure data

To store binary data

To define database names

5 / 25

5. Which SQL command is used to create a new table in MySQL?

CREATE TABLE

CREATE DATABASE

NEW TABLE

ADD TABLE

6 / 25

6. What should you consider when choosing table names in MySQL?

Singular names for tables

Avoid using underscores

Use obscure and cryptic names

Use uppercase for all table names

7 / 25

7. What are the primary components of defining a table in MySQL?

Column names, table name, and data types

Data types, column names, and indexes

Indexes, constraints, and column names

Data types, primary keys, and foreign keys

8 / 25

8. Which attribute is used to ensure each row has a unique identifier in a table?

AUTO_INCREMENT

CONSTRAINT UNIQUE

PRIMARY KEY

FOREIGN KEY

9 / 25

9. What is the purpose of a primary key in a MySQL table?

To define relationships between tables

To allow NULL values in a column

To enforce unique values in a column

To store binary data

10 / 25

10. What is the purpose of using AUTO_INCREMENT for a column in MySQL?

To set a default value for the column

To create a foreign key relationship

To enforce data type constraints

To automatically generate unique values

11 / 25

11. Which SQL command is used to add a foreign key constraint to a table in MySQL?

CREATE CONSTRAINT

CREATE FOREIGN KEY

ALTER TABLE ADD CONSTRAINT FOREIGN KEY

ADD FOREIGN KEY

12 / 25

12. What is the primary use of foreign keys in MySQL?

To define primary keys

To enforce unique values in a column

To establish relationships between tables

To create indexes

13 / 25

13. What is an index in a MySQL table?

A constraint on the primary key

A data type used for storing dates

A column with unique values

A data structure for optimizing queries

14 / 25

14. Why is it important to implement indexes in a MySQL table?

To store binary data

To enforce data type constraints

To define relationships between tables

To improve query performance

15 / 25

15. What is a typical use case for a UNIQUE constraint in MySQL?

Creating indexes for faster queries

Enforcing data type constraints

Defining relationships between tables

Ensuring each row has a unique identifier

16 / 25

16. What is the purpose of the AUTO_INCREMENT attribute in MySQL?

To add a default value for a column

To create foreign key relationships

To enforce data type constraints

To automatically generate unique values

17 / 25

17. How can you create a foreign key constraint in a MySQL table?

Using the ADD FOREIGN KEY command

Using the CREATE INDEX statement

Using the ALTER TABLE statement

Using the CREATE CONSTRAINT command

18 / 25

18. What should you consider when defining column names in a MySQL table?

Use meaningful and concise names

Make column names as long as possible

Use cryptic and ambiguous names

Avoid using alphanumeric characters

19 / 25

19. What is the primary purpose of using indexes in a MySQL table?

To create primary keys

To enforce data type constraints

To store binary data

To improve query performance

20 / 25

20. When defining a table in MySQL, what is a recommended practice for column names?

Avoid using alphanumeric characters

Make column names as long as possible

Use meaningful and concise names

Use cryptic and ambiguous names

21 / 25

21. What is the role of a primary key in a MySQL table?

To allow NULL values in a column

To ensure each row has a unique identifier

To create indexes

To enforce data type constraints

22 / 25

22. Which SQL command is used to create an index on a column in a MySQL table?

ADD INDEX

CREATE TABLE

CREATE INDEX

INDEX COLUMN

23 / 25

23. What is the purpose of creating relationships between tables in MySQL?

To define primary keys

To improve query performance

To organize and structure data

To enforce data type constraints

24 / 25

24. In which SQL command would you define the structure of a new MySQL table?

CREATE TABLE

DEFINE TABLE

INSERT TABLE

ADD TABLE

25 / 25

25. What is the primary purpose of defining constraints in a MySQL table?

To enforce data type constraints

To define the table's structure

To improve query performance

To create relationships between tables

Your score is