MySQL mcq questions and answers | MySQL MCQs Page-9 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

81.

What will be the result of the following MySQL command?

SELECT emp_id,
‘ACTIVE’ STATUS,
emp_id * 3.14 emp_pi,
UPPER (lname) last_name
FROM employee;

A. emp_id, ACTIVE, emp_id * 314, UPPER(lname)

B. emp_id, Status, emp_pi, last_name

C. Error

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

82.
The exec_stmt_ssl is written in . . . . . . . .

A. C++

B. C

C. Python

D. Perl

Answer & Solution Discuss in Board Save for Later

83.
What is the kind of delete when deletion of an employee from the table also deletes that employee from another table?

A. transparent

B. concrete

C. elaborate

D. cascaded

Answer & Solution Discuss in Board Save for Later

84.
What is the best datatype for a column that is expected to store values up to 2 million?

A. SMALLINT

B. TINYINT

C. MEDIUMINT

D. BIGINT

Answer & Solution Discuss in Board Save for Later

85.
All API calls return a value.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

86.
"Numeric Data" is used to store . . . . . . . .

A. Whole numbers

B. Natural numbers

C. Rational numbers

D. Both Whole and Natural numbers

Answer & Solution Discuss in Board Save for Later

87.
Stored programs degrade database security.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

This question is about the relationship between stored programs and database security in MySQL.
Let's break it down:
Stored Programs: These are like little snippets of code that you store directly in your database. They can be used to perform various tasks like adding data, retrieving information, or making calculations. Think of them as mini-programs that live inside your database.
Database Security: This refers to all the measures you take to protect your database from unauthorized access, data loss, and other threats. It's like a fortress around your data, keeping it safe.
The Question: Do stored programs weaken the security of your database?
The Answer: The correct answer is Option B: False.
Why?
Stored programs, when used properly, actually help improve security:
* Centralized Logic: Stored programs allow you to keep all your data manipulation logic in one place. This makes it easier to control, update, and audit.
* Reduced Code Duplication: Instead of repeating the same code across different applications, you can use a stored program, which reduces the chances of introducing security vulnerabilities.
* Permissions and Access Control: You can grant specific permissions to stored programs, limiting access to your database based on user roles.
However, it's important to use stored programs responsibly. Poor coding practices or insecure permissions can still pose risks.
In Summary: While stored programs can be a powerful tool for managing your database, they don't inherently degrade security.
Key Takeaway: Stored programs can be used to enhance database security when implemented correctly. It's crucial to follow best practices and be aware of potential vulnerabilities.

88.

Is there any error in the following MySQL command?

SELECT emp_id, title, start_date, fname, fed_id
FROM person
ORDER BY LEFT (fed_id, 3);

A. Yes

B. No error

C. Depends

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

89.
mysql_next_result() does not return a status.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

90.

What will be the output of the following MySQL statement?

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

A. Only those employees are selected whose last name started with 'T'

B. Only those employees are selected whose last name started with other than 'T'

C. All of the mentioned

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

81.
What will be the result of the following MySQL command?

`SELECT emp_id, ‘ACTIVE’ STATUS, emp_id * 3.14 emp_pi, UPPER (lname) last_name FROM employee;`

Answer & Solution

82.
The exec_stmt_ssl is written in . . . . . . . .

Answer & Solution

83.
What is the kind of delete when deletion of an employee from the table also deletes that employee from another table?

Answer & Solution

84.
What is the best datatype for a column that is expected to store values up to 2 million?

Answer & Solution

85.
All API calls return a value.

Answer & Solution

86.
"Numeric Data" is used to store . . . . . . . .

Answer & Solution

87.
Stored programs degrade database security.

Answer & Solution

88.
Is there any error in the following MySQL command?

`SELECT emp_id, title, start_date, fname, fed_id FROM person ORDER BY LEFT (fed_id, 3);`

Answer & Solution

89.
mysql_next_result() does not return a status.

Answer & Solution

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

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

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

81. What will be the result of the following MySQL command? SELECT emp_id, ‘ACTIVE’ STATUS, emp_id * 3.14 emp_pi, UPPER (lname) last_name FROM employee;

Answer & Solution

82. The exec_stmt_ssl is written in . . . . . . . .

Answer & Solution

83. What is the kind of delete when deletion of an employee from the table also deletes that employee from another table?

Answer & Solution

84. What is the best datatype for a column that is expected to store values up to 2 million?

Answer & Solution

85. All API calls return a value.

Answer & Solution

86. "Numeric Data" is used to store . . . . . . . .

Answer & Solution

87. Stored programs degrade database security.

Answer & Solution

88. Is there any error in the following MySQL command? SELECT emp_id, title, start_date, fname, fed_id FROM person ORDER BY LEFT (fed_id, 3);

Answer & Solution

89. mysql_next_result() does not return a status.

Answer & Solution

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

Answer & Solution

Read More Section(MySQL Miscellaneous)

81.
What will be the result of the following MySQL command?

`SELECT emp_id, ‘ACTIVE’ STATUS, emp_id * 3.14 emp_pi, UPPER (lname) last_name FROM employee;`

82.
The exec_stmt_ssl is written in . . . . . . . .

83.
What is the kind of delete when deletion of an employee from the table also deletes that employee from another table?

84.
What is the best datatype for a column that is expected to store values up to 2 million?

85.
All API calls return a value.

86.
"Numeric Data" is used to store . . . . . . . .

87.
Stored programs degrade database security.

88.
Is there any error in the following MySQL command?

`SELECT emp_id, title, start_date, fname, fed_id FROM person ORDER BY LEFT (fed_id, 3);`

89.
mysql_next_result() does not return a status.

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

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