Related InterviewSolutions

• 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) good(b) bad(c) illegal(d) fareThe question was asked in a job interview.The origin of the question is Setting Up Secure Connections in portion Access Control and Security of MySQL
• The datatype that stores the longest length of strings is ______________(a) CHAR(b) VARCHAR(c) TINYTEXT(d) TEXTThe question was posed to me at a job interview.My question is based upon Setting Up Secure Connections topic in chapter Access Control and Security of MySQL
• 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) BIGINTThis question was posed to me in my homework.This interesting question is from Setting Up Secure Connections in section Access Control and Security of MySQL
• MySQL does not provide a date type that has an optional time part.(a) True(b) FalseI have been asked this question during an online interview.This key question is from Setting Up Secure Connections in division Access Control and Security of MySQL
• Which variable checks for the availability of SSL support?(a) have_ssl(b) has_ssl(c) avail_ssl(d) ssl_availThis question was addressed to me in quiz.Query is from Setting Up Secure Connections topic in section Access Control and Security of MySQL
• The grant table scope columns that is case insensitive is _____________(a) Host(b) User(c) Password(d) DbThe question was posed to me during an internship interview.Enquiry is from Setting Up Secure Connections in section Access Control and Security of MySQL
• The TLS protocol is _____________(a) transparent layer security(b) transport layer security(c) transparent level security(d) transport level securityI had been asked this question in an online interview.My query is from Setting Up Secure Connections topic in division Access Control and Security of MySQL
• How many files does each end of a client/server connection including SSL support use to set up secure communications?(a) 0(b) 1(c) 2(d) 3The question was asked by my school principal while I was bunking the class.My question is based upon Setting Up Secure Connections in division Access Control and Security of MySQL
• The value of event_scheduler that enables checking status but not changing it at runtime is ______________(a) ON(b) OFF(c) DISABLED(d) ENABLEDThe question was posed to me in quiz.My enquiry is from External Security: Preventing Unauthorized Network Access topic in division Access Control and Security of MySQL
• The statement that is used to check the status of the event scheduler at runtime is _____________(a) SHOW STATUS OF ‘event_scheduler’(b) SHOW VARIABLES OF ‘event_scheduler’(c) SHOW STATUS LIKE ‘event_scheduler’(d) SHOW VARIABLES LIKE ‘event_scheduler’I got this question during an online exam.The question is from External Security: Preventing Unauthorized Network Access topic in division Access Control and Security of MySQL