Explore topic-wise InterviewSolutions in .

The correct answer is (d) more than 1

Explanation: In MySQL, for a MyISAM table, there can be more than one indexes. The DATA ROWS of the MyISAM table are stored in a data FILE and the index values are stored in a separate index file.

Right choice is (b) good

To elaborate: The SECURITY context is good if it enables CAREFULLY written stored programs to be set up that PROVIDE controlled access to tables for users who are not ABLE to access them DIRECTLY.

The CORRECT option is (C) View

To explain I would say: When a stored PROGRAM is created, an object is created that is to be executed later. This also the case when a view is defined: It sets up a SELECT STATEMENT intended for later INVOCATION.

Right answer is (b) Event

The BEST explanation: The MYSQL version 5.1.6 and above has an event scheduler. It ENABLES to perform time activated database operations. An event is a STORED program that is associated with a schedule.

The correct answer is (a) True

The best I can explain: The PHP SCRIPTS are different from DBI scripts SINCE PHP scripts are located within the WEB server document TREE while DBI scripts are located in a cgi-bin directory located outside of document tree.

Correct answer is (B) False

The explanation is: The PHP arrays can even have both numeric and ASSOCIATIVE elements. For example, $x[1] and $x[“LARGE”] can both be the elements of the same array. $x can be an object, WHOSE elements are accessed by the arrow ‘->’ operated.

Correct answer is (b) $a[0]

Best explanation: If $a represents an ARRAY with numeric indices, its elements are accessed as $x[0], $x[1], and so on. In GENERAL TERMS, each element at the position i is accessed and USED as $a[i – 1].

The correct choice is (a) CREATE TRIGGER

The explanation is: In order to create a trigger, the CREATE TRIGGER statement is USED. The definition indicates the particular type of statement for which the trigger ACTIVATES and WHETHER it activates before or after the rows are MODIFIED.

The CORRECT option is (b) 1

The explanation: In MySQL, the STORED function cannot return multiple values. Instead, multiple stored functions can be written and invoked from within a single STATEMENT however, they are DIFFERENT from stored procedures.

Correct choice is (b) CREATE FUNCTION

The BEST I can explain: The ‘CREATE FUNCTION’ statement is used to create a STORED function in MYSQL. The ‘CREATE PROCEDURE’ statement is used to create a stored procedure INSTEAD, from which values are not RETURNED.

The correct option is (c) Triggers

To explain: In MYSQL, triggers are associated with a table. They are DEFINED to EXECUTE when the table is modified VIA INSERT, DELETE or UPDATE statements. MySQL SUPPORTS objects to be stored on server side.

Correct choice is (a) Stored functions

To explain I WOULD say: Stored functions return a result from a calculation and can be USED in EXPRESSIONS. Stored procedures do not return a result directly but can be used to PERFORM general computations.

Correct ANSWER is (d) DECIMAL

The EXPLANATION is: Currency is a numeric information. For monetary calculations, FLOAT and DOUBLE are subject to rounding error and may not be suitable. A DECIMAL(M, 2) type is best SUITED for it.

Correct choice is (c) $

EXPLANATION: All the PHP scripts that use variables have variable names PRECEDED by the dollar sign (‘$’). The variables are SIGNIFIED by this identifier, irrespective of the VALUE it stores.

Correct OPTION is (b) dynamically generated

To explain I would say: The interpreter switches between CODE mode back and text mode when it sees another special tag which SIGNALS the end of the code. This ENABLES the mix of static text with dynamically generated results.

Right OPTION is (a) True

To elaborate: The elementary operation of PHP is interpreting a SCRIPT in ORDER to produce a web page. This is sent to a client. A PHP script generally contains a mix of HTML and executable CODE.

The correct option is (d) DECIMAL

Explanation: CURRENCY is a numeric information. For monetary calculations, FLOAT and DOUBLE are SUBJECT to ROUNDING error and may not be suitable. A DECIMAL(M, 2) TYPE is best suited for it.

The correct option is (B) INT

The EXPLANATION is: The AUTO_INCREMENT is a column attribute and it is BEST used with the integer datatypes. It AUTOMATICALLY assigns monotonically increasing values to the AUTO_INCREMENT columns.

Right ANSWER is (b) 0

For explanation: When the SQL mode PIPES_AS_CONCAT is disabled, the SQL STANDARD ‘||’ operation for string concatenation is not VALID in MySQL. Both operands are converted to zero. So the result is zero.

Right choice is (b) 2

To explain: The ‘DIV’ OPERATOR in MYSQL is USED to perform the integer divisions. The operator ‘/’ performs the quotient of the operands. If result exceeds the 64-bit range, UNPREDICTED results are shown.

The correct answer is (b) 1

Explanation: The AUTO_INCREMENT column attribute PROVIDES UNIQUE numbers for column identification. AUTO_INCREMENT SEQUENCES normally begin at 1 and increase monotonically like 1, 2, 3, and so on.

The correct choice is (b) False

Easy explanation: In MySQL, there can only be one column per table with the AUTO_INCREMENT ATTRIBUTE. It should ALSO have an integer data type. The AUTO_INCREMENT is also allowed for floating POINT types.

The correct choice is (a) True

For explanation: ‘CGI.pm’ supports an object ORIENTED style of USE which ALLOWS to invoke its functions without importing the names. To do this, a use statement is included and a CGI object is created.

Right OPTION is (c) use CGI

The best explanation: 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.

The correct answer is (b) Common GATEWAY Interface

To EXPLAIN: The ‘CGI.pm’ module is so CALLED because it helps write scripts that use the ‘Common Gateway Interface’ protocol which defines how a web server COMMUNICATES with other PROGRAMS.

Correct option is (c) CGI.pm

Easy explanation: The CGI.pm module is used to write scripts that use the ‘Common Gateway Interface’ protocol. It defines how a WEB server communicates with other PROGRAMS. It provides an easy LINK.

The CORRECT answer is (d) TIME

The best I can explain: In MySQL, there are DIFFERENT ways to handle the illegal values for different datatypes for default. For date or time COLUMNS, illegal values are converted to the appropriate “zero” VALUE for the type.

Right OPTION is (a) 3.402823466E+38

Explanation: In MYSQL, each datatype has its own range. Data types give an IDEA of the kind of values and the ranges that a variable is allowed to store. The MAXIMUM non ZERO value for FLOAT is 3.402823466E+38.

The correct ANSWER is (d) fetchrow_hashref()

To explain: The function ‘fetchrow_hashref()’ RETURNS reference to hash of ROW values. ‘fetchrow_arrayref()’ returns a reference to an ARRAY of row values. ‘fetch()’ is the same as fetchrow_arrayref().

The correct OPTION is (a) fetchrow_array()

To explain I would say: The function ‘fetchrow_array()’ RETURNS an ARRAY of row VALUES. ‘fetchrow_arrayref()’ returns a reference to an array of row values. ‘fetch()’ is the same as fetchrow_arrayref().

The CORRECT OPTION is (a) Rich Text Format

Explanation: RTF (Rich Text Format) is a format developed by Microsoft that is UNDERSTOOD by many word processors. MS-Word is one such PROGRAM. Many others such as ‘OpenOffice’ UNDERSTAND it too.

The correct choice is (a) FLOAT

Best EXPLANATION: There are various numeric datatypes in MySQL. Some of them are TINYINT, SMALLINT, BIGINT, FLOAT, DOUBLE and BIT. ‘FLOAT’ is for single precision floating point numbers UNLIKE DOUBLE.

Right answer is (b) ‘\R’

The best I can EXPLAIN: MySQL provides the FACILITY to use a wide range of escape sequences. They are special characters. They begin with the backslash character. For example, ‘\r’ specifies carriage return.

Correct option is (b) 16

Explanation: In MySQL, there are MANY numeric DATATYPES. They include integers and floating points. For example, 34, 12.3, -1.3E11. The NUMBERS that are prefixed with ‘0X’ are in hexadecimal.

Right choice is (b) Boolean mode

The best explanation: A full text search capability is PROVIDED in MySQL. It facilitates to LOOK for words or phrases WITHOUT using pattern-matching operations. Boolean search is ONE of the three MODES.

Right choice is (b) Natural language

For EXPLANATION: In MySQL, a full text search capability is provided, which ENABLES to look for words or PHRASES without using pattern-matching operations. There are three KINDS of full text searches.

The correct choice is (a) True

The best I can EXPLAIN: While using the DBI API functions are called and POINTERS to STRUCTURES are used. The functions are called “methods,” pointers are called “REFERENCES,” POINTER variables are called “handles”.

The correct OPTION is (d) $ary

To explain: The PERL Non-handle variable ‘$ary’ is an array or list representing a row of values returned by a query. ‘$rc’ returns code from OPERATIONS that RETURN true or FALSE. ‘$rv’ returns value from operations that return an integer. ‘$rows’ returns value from operations that return a row count.

The correct option is (d) $h

Easy explanation: The variable named ‘$fh’ is a handle to an OPEN FILE. ‘$h’ is a GENERIC handle and the MEANING depends on context. ‘$dbh’ is a handle to a database object. ‘$sth’ is a handle to a QUERY object.

Correct answer is (a) True

To explain I would say: A FOREIGN key is the one which declares that an index in one table is related to that in another and PLACE constraints. It is useful for HANDLING deletes and updates ALONG with row entries.