What causes a replication master server to delete all the binary log files even if they are still in use?(a) RESET MASTER LOGS(b) FLUSH TABLES(c) RELOAD(d) FLUSH LOGSThis question was posed to me by my school teacher while I was bunking the class.My question is based upon External Security: Preventing Unauthorized Network Access in division Access Control and Security of MySQL

What causes a replication master server to delete all the binary log f

1.	What causes a replication master server to delete all the binary log files even if they are still in use?(a) RESET MASTER LOGS(b) FLUSH TABLES(c) RELOAD(d) FLUSH LOGSThis question was posed to me by my school teacher while I was bunking the class.My question is based upon External Security: Preventing Unauthorized Network Access in division Access Control and Security of MySQL
Answer» The correct choice is (a) RESET MASTER LOGS Explanation: ‘RESET MASTER LOGS’ causes a replication master server to DELETE all binary log files even if they are in use which REMOVES the information NECESSARY to maintain the replication INTEGRITY.

Discussion

No Comment Found

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

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment