MySQL MCQ Questions with answers and solutions Page 1

Q. A stored procedure is invoked using the statement __________.

(A) CALL
(B) RETURN
(C) SEE
(D) INVOKE

💬 Discuss

✅ Correct Answer: (A) CALL

Published by Manisha Agrawal ⭐ 9.34K Points at 05-Jun-2022 07:55 am in MySQL

Q. Triggers and events are not invoked automatically by the server.

(A) False
(B) True
(C) NA
(D) NA

💬 Discuss

✅ Correct Answer: (A) False

Published by Manisha Agrawal ⭐ 9.34K Points at 05-Jun-2022 07:55 am in MySQL

Q. The security context when a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access is __________

(A) illegal
(B) fare
(C) bad
(D) good

💬 Discuss

✅ Correct Answer: (C) bad

Published by Manisha Agrawal ⭐ 9.34K Points at 05-Jun-2022 07:56 am in MySQL

Q. The datatype that stores the longest length of strings is ______________.

(A) VARCHAR
(B) TEXT
(C) CHAR
(D) TINYTEXT

💬 Discuss

✅ Correct Answer: (B) TEXT

Published by Manisha Agrawal ⭐ 9.34K Points at 05-Jun-2022 07:56 am in MySQL

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

(A) BIGINT
(B) SMALLINT
(C) TINYINT
(D) MEDIUMINT

💬 Discuss

✅ Correct Answer: (A) BIGINT

Published by Manisha Agrawal ⭐ 9.34K Points at 05-Jun-2022 07:57 am in MySQL

Q. MySQL does not provide a date type that has an optional time part.

(A) False
(B) True
(C) NA
(D) NA

💬 Discuss

✅ Correct Answer: (B) True

Published by Manisha Agrawal ⭐ 9.34K Points at 05-Jun-2022 07:57 am in MySQL

Q. Which variable checks for availability of SSL support?

(A) avail_ssl
(B) ssl_avail
(C) have_ssl
(D) has_ssl

💬 Discuss

✅ Correct Answer: (C) have_ssl

Published by Manisha Agrawal ⭐ 9.34K Points at 05-Jun-2022 07:58 am in MySQL

Q. The grant table scope columns that is case insensitive is _____________.

(A) Password
(B) Db
(C) Host
(D) User

💬 Discuss

✅ Correct Answer: (C) Host

Published by Manisha Agrawal ⭐ 9.34K Points at 05-Jun-2022 07:58 am in MySQL

Q. The TLS protocol is _____________.

(A) transparent level security
(B) transparent layer security
(C) transport level security
(D) transport layer security

💬 Discuss

✅ Correct Answer: (D) transport layer security

Published by Manisha Agrawal ⭐ 9.34K Points at 05-Jun-2022 07:59 am in MySQL

Q. How many files does each end of a client/server connection including SSL support use to set up secure communications?

(A) 3
(B) 2
(C) 1
(D) 0

💬 Discuss

✅ Correct Answer: (A) 3

Published by Manisha Agrawal ⭐ 9.34K Points at 05-Jun-2022 07:59 am in MySQL

MySQL MCQs with answers Page - 1

Q. A stored procedure is invoked using the statement __________.

Q. Triggers and events are not invoked automatically by the server.

Q. The security context when a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access is __________

Q. The datatype that stores the longest length of strings is ______________.

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

Q. MySQL does not provide a date type that has an optional time part.

Q. Which variable checks for availability of SSL support?

Q. The grant table scope columns that is case insensitive is _____________.

Q. The TLS protocol is _____________.

Q. How many files does each end of a client/server connection including SSL support use to set up secure communications?

Programming Categories

📱 Download Our App