MySQL mcq questions and answers | MySQL MCQs Page-3 section-5

Section 1 Section 2 Section 3 Section 4 Section 5 Section 6 Section 7 Section 8 Section 9 Section 10 Section 11 Section 12

21.
The log in which data changes received from a replication master server are written is . . . . . . . .

A. error log

B. general query log

C. binary log

D. relay log

Answer & Solution Discuss in Board Save for Later

22.
Which statement on the master expires binary log files?

A. SHOW SLAVE STATUS

B. PURGE MASTER

C. PURGE SLAVE

D. SHOW MASTER STATUS

Answer & Solution Discuss in Board Save for Later

23.
SELECT on a MERGE table is like . . . . . . . .

A. UNION ALL

B. UNION

C. UNION DISTINCT

D. JOIN

Answer & Solution Discuss in Board Save for Later

24.
Which option is used to specify to the server the IP number of the server host on which the server should listen?

A. -verbose

B. -bind-address

C. -startup

D. -shutdown

Answer & Solution Discuss in Board Save for Later

25.
A FULLTEXT index can be created for multiple columns.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

26.

In the following SQL query, what does "person_id" stands for?

CREATE TABLE person
(person_ id SMALLINT UNSIGNED,
fname VARCHAR(20),
lname VARCHAR(20),
CONSTRAINT pk_person PRIMARY KEY (person_id));

A. Normal attribute of the table

B. Super key

C. Composite key

D. Primary key

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

This question is asking you to identify what "person_id" represents within the given SQL code. The code creates a table named "person" with several columns:

* person_id: This column stores a unique identifier for each person in the table. It is declared as SMALLINT UNSIGNED, meaning it can hold small integer values without negative signs.
* fname: This column stores the first name of each person. It is declared as VARCHAR(20), meaning it can hold strings of up to 20 characters.
* lname: This column stores the last name of each person. It is also declared as VARCHAR(20).

The code also includes a constraint called pk_person, which is a primary key constraint applied to the person_id column.

A primary key is a special type of key in a database that uniquely identifies each row in a table. Here's why "person_id" is the primary key:

* Unique Identification: Each person must have a distinct "person_id", ensuring that no two rows have the same value.
* Data Integrity: The primary key constraint enforces this uniqueness, preventing duplicate entries and maintaining data consistency.

Therefore, the correct answer is Option D: Primary key.

Let's look at the other options and why they're incorrect:

* Option A: Normal attribute of the table - While "person_id" is an attribute of the table, it's not just a normal attribute because of its unique identification role.
* Option B: Super key - A super key is any set of attributes that can uniquely identify a row, but a primary key is the minimal set of attributes that can do so.
* Option C: Composite key - A composite key is a primary key consisting of multiple columns. In this case, "person_id" is a single-column primary key.

27.
Which table option for MyISAM tables reduces index flushing?

A. DELAY_KEY_WRITE

B. DELAY_WRITE_KEY

C. KEY_WRITE_DELAY

D. WRITE_KEY_DELAY

Answer & Solution Discuss in Board Save for Later

28.

Consider a database name "db_name" whose attributes are intern_id (primary key), subject.
Intern_id = {1, 2, 3, 4, 5, 6}
Subject = {sql, oop, sql, oop, c, c++}
If these are one to one relation then what will be the output of the following MySQL statement?

SELECT intern_id
FROM db_name
WHERE subject IN (c, c++);

A. {5, 6}

B. {1, 2, 3}

C. {3, 4}

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

29.
Which statement is used to access an existing Database?

A. Use

B. use database.name

C. USE databasename;

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

30.
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.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

21.
The log in which data changes received from a replication master server are written is . . . . . . . .

Answer & Solution

22.
Which statement on the master expires binary log files?

Answer & Solution

23.
SELECT on a MERGE table is like . . . . . . . .

Answer & Solution

24.
Which option is used to specify to the server the IP number of the server host on which the server should listen?

Answer & Solution

25.
A FULLTEXT index can be created for multiple columns.

Answer & Solution

26.
In the following SQL query, what does "person_id" stands for?

`CREATE TABLE person (person_ id SMALLINT UNSIGNED, fname VARCHAR(20), lname VARCHAR(20), CONSTRAINT pk_person PRIMARY KEY (person_id));`

Answer & Solution

27.
Which table option for MyISAM tables reduces index flushing?

Answer & Solution

Answer & Solution

29.
Which statement is used to access an existing Database?

Answer & Solution

30.
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.

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

21. The log in which data changes received from a replication master server are written is . . . . . . . .

Answer & Solution

22. Which statement on the master expires binary log files?

Answer & Solution

23. SELECT on a MERGE table is like . . . . . . . .

Answer & Solution

24. Which option is used to specify to the server the IP number of the server host on which the server should listen?

Answer & Solution

25. A FULLTEXT index can be created for multiple columns.

Answer & Solution

26. In the following SQL query, what does "person_id" stands for? CREATE TABLE person (person_ id SMALLINT UNSIGNED, fname VARCHAR(20), lname VARCHAR(20), CONSTRAINT pk_person PRIMARY KEY (person_id));

Answer & Solution

27. Which table option for MyISAM tables reduces index flushing?

Answer & Solution

Answer & Solution

29. Which statement is used to access an existing Database?

Answer & Solution

30. 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.

Answer & Solution

Read More Section(MySQL Miscellaneous)

21.
The log in which data changes received from a replication master server are written is . . . . . . . .

22.
Which statement on the master expires binary log files?

23.
SELECT on a MERGE table is like . . . . . . . .

24.
Which option is used to specify to the server the IP number of the server host on which the server should listen?

25.
A FULLTEXT index can be created for multiple columns.

26.
In the following SQL query, what does "person_id" stands for?

`CREATE TABLE person (person_ id SMALLINT UNSIGNED, fname VARCHAR(20), lname VARCHAR(20), CONSTRAINT pk_person PRIMARY KEY (person_id));`

27.
Which table option for MyISAM tables reduces index flushing?

29.
Which statement is used to access an existing Database?

30.
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.