MySQL mcq questions and answers | MySQL MCQs Page-1 section-11

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

1.
The statement that makes changes to the global attributes of the database is . . . . . . . .

A. CHANGE

B. ALTER

C. ALTERNATE

D. UPDATE

Answer & Solution Discuss in Board Save for Later

2.
Which operator is used to check whether the expression is "NULL"?

A. IS NULL

B. NOT NULL

C. ON

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

3.
What is the synonym for REAL?

A. FLOAT

B. INT

C. DOUBLE

D. BIT

Answer & Solution Discuss in Board Save for Later

What will be the output of the following MySQL statement?

SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (fname, 1) =’F’ OR LEFT (lname, 1) =’F’;

A. Only those employees are selected whose first name and last name started with 'F'

B. Only those employees are selected whose first name started with 'F' but last name can be starts with any other letter

C. Only those employees are selected whose first name and last name started with any other letter except 'F'

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

5.
The logging option to enable binary log index file is . . . . . . . .

A. -log-bin-index

B. -bin-log-index

C. -index-log-bin

D. -index-bin-log

Answer & Solution Discuss in Board Save for Later

6.
The NULL value also means . . . . . . . .

A. value equal to zero

B. unknown value

C. negative values

D. a large value

Answer & Solution Discuss in Board Save for Later

What is the number of attributes in the following SQL table?

CREATE TABLE employee (
		emp_name CHAR(30),
		emp_id INT
	);

A. 1

B. 2

C. 3

D. 30

Answer & Solution Discuss in Board Save for Later

8.
Which statement can produce the same output as 'SHOW COLUMNS'?

A. DESCRIBE

B. DISPLAY

C. SEE

D. GET

Answer & Solution Discuss in Board Save for Later

9.
What is the option for specifying the executable name while compiling with gcc?

A. -e

B. -o

C. -a

D. -b

Answer & Solution Discuss in Board Save for Later

10.
In the CREATE TABLE statement, the engine name specified is case sensitive.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

1.
The statement that makes changes to the global attributes of the database is . . . . . . . .

Answer & Solution

2.
Which operator is used to check whether the expression is "NULL"?

Answer & Solution

3.
What is the synonym for REAL?

Answer & Solution

4.
What will be the output of the following MySQL statement?

`SELECT emp_id, fname, lname FROM employee WHERE LEFT (fname, 1) =’F’ OR LEFT (lname, 1) =’F’;`

Answer & Solution

5.
The logging option to enable binary log index file is . . . . . . . .

Answer & Solution

6.
The NULL value also means . . . . . . . .

Answer & Solution

7.
What is the number of attributes in the following SQL table?

`CREATE TABLE employee ( emp_name CHAR(30), emp_id INT );`

Answer & Solution

8.
Which statement can produce the same output as 'SHOW COLUMNS'?

Answer & Solution

9.
What is the option for specifying the executable name while compiling with gcc?

Answer & Solution

10.
In the CREATE TABLE statement, the engine name specified is case sensitive.

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

1. The statement that makes changes to the global attributes of the database is . . . . . . . .

Answer & Solution

2. Which operator is used to check whether the expression is "NULL"?

Answer & Solution

3. What is the synonym for REAL?

Answer & Solution

4. What will be the output of the following MySQL statement? SELECT emp_id, fname, lname FROM employee WHERE LEFT (fname, 1) =’F’ OR LEFT (lname, 1) =’F’;

Answer & Solution

5. The logging option to enable binary log index file is . . . . . . . .

Answer & Solution

6. The NULL value also means . . . . . . . .

Answer & Solution

7. What is the number of attributes in the following SQL table? CREATE TABLE employee ( emp_name CHAR(30), emp_id INT );

Answer & Solution

8. Which statement can produce the same output as 'SHOW COLUMNS'?

Answer & Solution

9. What is the option for specifying the executable name while compiling with gcc?

Answer & Solution

10. In the CREATE TABLE statement, the engine name specified is case sensitive.

Answer & Solution

Read More Section(MySQL Miscellaneous)

1.
The statement that makes changes to the global attributes of the database is . . . . . . . .

2.
Which operator is used to check whether the expression is "NULL"?

3.
What is the synonym for REAL?

4.
What will be the output of the following MySQL statement?

`SELECT emp_id, fname, lname FROM employee WHERE LEFT (fname, 1) =’F’ OR LEFT (lname, 1) =’F’;`

5.
The logging option to enable binary log index file is . . . . . . . .

6.
The NULL value also means . . . . . . . .

7.
What is the number of attributes in the following SQL table?

`CREATE TABLE employee ( emp_name CHAR(30), emp_id INT );`

8.
Which statement can produce the same output as 'SHOW COLUMNS'?

9.
What is the option for specifying the executable name while compiling with gcc?

10.
In the CREATE TABLE statement, the engine name specified is case sensitive.