Explore topic-wise InterviewSolutions in .

Correct answer is (a) C API

The best I can explain: The C Application Programming Interface provides the lowest LEVEL interface to the server. It enforces the least policy. Therefore it provides the least AMOUNT of safety net.

Right CHOICE is (a) PERL, PHP, C

Easiest explanation: Perl has the most highly developed capabilities in terms of text manipulation, and PHP follows it in the ORDER. C is very rudimentary by comparison. It has the least simplicity.

The correct OPTION is (a) True

Explanation: The startup penalty for a STANDALONE interpreter MAKES it give at least an order of magnitude poorer performance than the module interpreter. Interpreters also have a setup cost.

Right OPTION is (d) common GATEWAY INTERFACE

Explanation: The web server ‘Apache’ uses the interpreters as some CGI programs. This MEANS that it communicates with these programs using the popular ‘Common Gateway Interface (CGI)’ protocol.

Right choice is (a) C

Easy EXPLANATION: C is compiled while PERL and PHP are interpreted. So C PROGRAMS generally will run faster than Perl or PHP scripts. Therefore C should be the best choice for a HEAVILY used program.

The correct CHOICE is (a) True

The best EXPLANATION: For interpreted languages used in web DEVELOPMENT, the performance is better when the interpreter is INVOKED as a module which is a PART of the Web server itself. Compiler is faster generally.

Right choice is (a) PERL

Best EXPLANATION: Like C, Perl is also suitable for writing standalone programs. HOWEVER, Perl is quite useful for Web SITE development. The CGI.pm module of Perl can be extensively used for it.

Correct option is (d) C

The explanation: It is not as easy to PERFORM TEXT processing and MEMORY management in C than it is in languages like Perl and PHP. These capabilities TEND to be heavily used in the web applications.

Right OPTION is (a) C

For explanation: C is a general purpose LANGUAGE, so in principle it can be used for ANYTHING. C tends to be used more often for standalone PROGRAMS rather than for Web PROGRAMMING in practice.

The correct option is (d) Java

For explanation I would SAY: The JDBI INTERFACE is available for the programming language Java. Java is one of the most widely popular LANGUAGES in the world. It is a powerful object ORIENTED programming language.

The correct CHOICE is (c) PHP

For explanation I would SAY: The PEAR database module is specified for the language PHP. PHP is a SERVER side scripting language and it PROVIDES an appropriate METHOD of embedding programs in the web pages.

The correct answer is (c) PHP

Easy explanation: Like DBI, PHP INCLUDES support for accessing several DATABASE engines in addition to MySQL. It has engine specific INTERFACES, and interfaces that are more engine independent.

Right choice is (a) DATABASE interface

Explanation: In MySQL, DBI is IMPLEMENTED as a Perl MODULE. It interfaces with other modules at the DBD (Database Driver) LEVEL. Each of it provides access to a SPECIFIC database engine.

Correct option is (a) C API

To EXPLAIN: The primary PROGRAMMING interface to MySQL is the C API. It is used to implement some of the standard clients in the MySQL distribution INCLUDING mysql, mysqladmin and MYSQLDUMP.

Correct choice is (a) True

The explanation: Each language BINDING defines its own interface that DICTATES all the rules for accessing MySQL. Popular and useful programming languages like C++, JAVA, PYTHON, PHP and others.

Correct CHOICE is (a) C

To ELABORATE: In order to provide application development, MySQL provides a CLIENT library written in the C programming language. It ENABLES the access of MySQL databases from a C program.

Right option is (a) mysqlslap

For EXPLANATION: mysqlslap is a client program designed to emulate client load for a MySQL server. It reports the timing of each stage. It works as if MULTIPLE CLIENTS are accessing the server.

The correct option is (d) mysql_upgrade

The EXPLANATION: mysql_upgrade is used after a MYSQL upgrade operation. It checks TABLES for incompatibilities and repairs them if necessary. It updates the grant tables with any changes that have been made in newer VERSIONS of MySQL.

Right OPTION is (d) comp_err

To EXPLAIN: The program ‘comp_err’ is used during the MySQL BUILD or the MySQL installation process. This program compiles the error MESSAGE files from the error source files. The others are not run during startup.

Correct choice is (c) –force

For explanation I would say: If SQL queries in a file are run using MYSQL in batch MODE, mysql either quits after the first ERROR. If the –force option is specified all the queries are executed indiscriminately.

The CORRECT answer is (a) True

Explanation: Input provided by the user can be validated. For INSTANCE, dates can be CHECKED to make SURE they conform to the format that MYSQL expects, or certain fields can be filled in to check.

Correct choice is (b) mysqladmin

The explanation is: In MySQL, some distributions INCLUDE a set of some client programs. ‘mysqladmin’ PERFORMS the ADMINISTRATIVE OPERATIONS. ‘mysqlimport’ loads the DATA files into the tables.

Correct ANSWER is (c) MYSQLIMPORT

The explanation: ‘mysqlimport’ LOADS the data files into the tables. In MySQL, some distributions INCLUDE a set of some client PROGRAMS. ‘mysqldump’ exports the table definitions and the contents.

Right option is (a) mysqldump

The best I can explain: In MySQL, some distributions include a SET of some client programs. ‘mysqldump’ exports the table DEFINITIONS and the contents. ‘MYSQLADMIN’ performs adminisitrative TASKS.