InterviewSolution

Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

51.	How is the output from PHP generated?(a) statically generated(b) dynamically generated(c) not generated(d) no outputThis question was addressed to me in an international level competition.The above asked question is from Performing Database Maintenance with the Server Running topic in division Database Maintenance, Backups and Replication of MySQL
Answer» The CORRECT choice is (b) dynamically generated Explanation: The INTERPRETER switches between code mode back and text mode when it sees another special TAG that SIGNALS the end of the code. This ENABLES the mix of static text with dynamically generated results.

52.	What is the default path to Perl in Unix?(a) /usr/bin/perl(b) /usr/bin(c) /usr/perl(d) /usr/perl/binThe question was asked in a job interview.I want to ask this question from Performing Database Maintenance with the Server Running in section Database Maintenance, Backups and Replication of MySQL
Answer» Correct answer is (a) /usr/bin/PERL For EXPLANATION: All Perl scripts generally begin with a #! (shebang) line. A script is a file containing a sequence of COMMANDS. The Perl scripts are text FILES, which can be created using any text editor.

53.	What is the Perl DBI?(a) database inheritance(b) database integrity(c) database interface(d) database isolationThe question was asked in a national level competition.My enquiry is from Performing Database Maintenance with the Server Running topic in division Database Maintenance, Backups and Replication of MySQL
Answer» The correct option is (C) database interface Easiest explanation: The Perl DBI is the Perl Database Interface. The work of the interface is to FORM a LINK between the APPLICATION programming interface in C with all the other programming LANGUAGES.

54.	For which table does ‘REPAIR TABLE’ not work?(a) MyISAM(b) ARCHIVE(c) CSV(d) InnoDBThis question was addressed to me in an online quiz.This intriguing question originated from Performing Database Maintenance with the Server Running topic in portion Database Maintenance, Backups and Replication of MySQL
Answer» The correct option is (d) InnoDB The EXPLANATION: ‘REPAIR TABLE’ works for MyISAM, ARCHIVE, and CSV tables. For MyISAM tables, it has the same EFFECT as ‘myisamchk –recover’ tbl_name by default. This statement does not work with views.

55.	The column not returned by ‘OPTIMIZE TABLE’ is _____________(a) Table(b) Msg_txt(c) Op(d) Msg_typeThe question was posed to me in exam.Enquiry is from Performing Database Maintenance with the Server Running in division Database Maintenance, Backups and Replication of MySQL
Answer» Correct OPTION is (b) Msg_txt To EXPLAIN: ‘OPTIMIZE TABLE’ table catches and throws any errors that occur while copying table statistics from the OLD file to the newly CREATED file. It returns a result SET of columns.

56.	The statement that performs key distribution analysis and stores the distribution for the named tables is _____________(a) CHECK TABLE(b) ANALYZE TABLE(c) CHECKSUM TABLE(d) OPTIMIZE TABLEThe question was posed to me by my college professor while I was bunking the class.My query is from Performing Database Maintenance with the Server Running topic in section Database Maintenance, Backups and Replication of MySQL
Answer» Right answer is (b) ANALYZE TABLE The best explanation: ‘ANALYZE TABLE’ PERFORMS a KEY DISTRIBUTION ANALYSIS and stores the distribution for the named table or tables. For the MyISAM tables, this statement is equivalent to using ‘myisamchk –analyze’.

57.	To perform consistency checks on a MyISAM table the statement is _____________(a) CHECK TABLE(b) REPAIR TABLE(c) ANALYZE TABLE(d) OPTIMIZE TABLEThe question was asked in quiz.The origin of the question is Performing Database Maintenance with the Server Running in chapter Database Maintenance, Backups and Replication of MySQL
Answer» The correct option is (a) CHECK TABLE To EXPLAIN: In order to perform CONSISTENCY CHECKS or table repairs on a MyISAM table a ‘CHECK TABLE’ or ‘REPAIR TABLE’ STATEMENT is issued. The ‘mysqlcheck’ program can also be invoked.

58.	The line which is written at the top of the script to write a Perl script using CGI.pm is ______________(a) use this CGI(b) put CGI(c) use CGI(d) include CGII have been asked this question by my college director while I was bunking the class.My question comes from Principles of Preventive Maintenance in division Database Maintenance, Backups and Replication of MySQL
Answer» Right ANSWER is (c) USE CGI The explanation is: In order to write a Perl script that uses the ‘CGI.pm’ module, a ‘use CGI’ STATEMENT is included near the BEGINNING of the script that imports the FUNCTION names of the module.

59.	What is a synonym for CHARACTER SET?(a) CSET(b) CHSET(c) CHARSET(d) CHCSETThis question was posed to me in homework.Query is from Principles of Preventive Maintenance in division Database Maintenance, Backups and Replication of MySQL
Answer» RIGHT choice is (C) CHARSET To elaborate: ‘CHARACTER SET’ can be abbreviated into ‘CHARSET’ and can be used in the same contexts and statements where ‘CHARACTER SET’ is used. ‘charset’ is the server-supported character set.

60.	The binary protocol is easy to use.(a) True(b) FalseThe question was asked during an internship interview.This question is from Principles of Preventive Maintenance topic in chapter Database Maintenance, Backups and Replication of MySQL
Answer» CORRECT choice is (b) False To elaborate: The BINARY PROTOCOL is more difficult to use because more setup is necessary for transmitting and RECEIVING data values. The binary protocol does not support all statements like ‘USE’.

61.	REPAIR TABLE does not work for _____________(a) MyISAM(b) ARCHIVE(c) InnoDB(d) CSVI got this question during an online interview.I want to ask this question from Principles of Preventive Maintenance topic in portion Database Maintenance, Backups and Replication of MySQL
Answer» CORRECT choice is (c) InnoDB To elaborate: ‘REPAIR TABLE’ works for MYISAM, ARCHIVE, and CSV tables. For MyISAM tables, it has the same EFFECT as ‘myisamchk –recover’ tbl_name by default. This statement does not WORK with views.

62.	Which of the following columns is not returned by ‘OPTIMIZE TABLE’?(a) Table(b) Op(c) Msg_type(d) Msg_txtThe question was posed to me during an interview.My question is based upon Principles of Preventive Maintenance topic in portion Database Maintenance, Backups and Replication of MySQL
Answer» Correct ANSWER is (d) Msg_txt For EXPLANATION: ‘OPTIMIZE TABLE’ table CATCHES and throws any errors that occur while copying table statistics from the old file to the newly created file. It RETURNS a result set of columns.

63.	What performs a key distribution analysis and stores the distribution for the named table or tables?(a) ANALYZE TABLE(b) CHECK TABLE(c) CHECKSUM TABLE(d) OPTIMIZE TABLEThe question was asked in examination.I would like to ask this question from Principles of Preventive Maintenance topic in chapter Database Maintenance, Backups and Replication of MySQL
Answer» Right choice is (a) ANALYZE TABLE For explanation: ‘ANALYZE TABLE’ performs a KEY DISTRIBUTION analysis and stores the distribution for the NAMED table or tables. For the MYISAM tables, this statement is equivalent to USING ‘myisamchk –analyze’.

64.	The recovery of data changes made since a given point in time is called _____________(a) decremental(b) incremental(c) close(d) clearI got this question in final exam.This question is from Principles of Preventive Maintenance topic in division Database Maintenance, Backups and Replication of MySQL
Answer» Right CHOICE is (b) incremental To elaborate: Incremental recovery REFERS to the recovery of data changes made since a GIVEN point in TIME. It is performed after restoring a FULL backup that brings the server to its state as of the time the backup was made.