Explore topic-wise InterviewSolutions in .

Correct choice is (b) PHP 5

The EXPLANATION is: In PHP 4, all properties were declared with VAR keyword, which is identical in effect to using public. For the SAKE of backward COMPATIBILITY, PHP 5 accepts var in place of public for properties.

Right answer is (c) INSTANCE

Best explanation: An OBJECT is SAID to be an instance of its class. It is of the type DEFINED by the class.

Right CHOICE is (d) 1shopproduct

To elaborate: You declare a class with the class keyword and an arbitrary class name. Class names can be any combination of numbers and letters, although they must not BEGIN with a NUMBER.

Correct ANSWER is (d) mysqli_fetch_row()

Explanation: The function mysqli_fetch_row() is used to fetche ROW from a RESULT-set and returns it as an enumerated array.

Its syntax is mysqli_fetch_row(result);

The correct OPTION is (c) mysqli_rollback()

The explanation: The function mysqli_rollback() is used to ROLL back from the current transaction for the specified database CONNECTION. Its syntax is: mysqli_rollback(connection);

Rollback() was used in PREVIOUS version of PHP.

Right option is (c) mysqli_close()

The explanation: The FUNCTION mysqli_close() is used to CLOSE an opened database connection. Once you’ve finished using a PREPARED statement, the resources it requires can be recuperated with the mysqli_close() method. Close() was used in PREVIOUS version of PHP.

Correct option is (a) bind_param()

The explanation: Once the statement has been prepared, it NEEDS to be executed. Exactly when it’s executed depends upon WHETHER you WANT to work with BOUND parameters or bound results. In the case of bound parameters, you’d execute the statement after the parameters have been bound with the bind_param() method.

The correct option is (b) MYSQL 4.1

To explain I would say: When the query() method is LOOPED repeatedly it comes at a cost of both overhead, because of the NEED to repeatedly parsing of the almost identical query for validity, and CODING convenience, because of the need to repeatedly reconfigure the query using the new values for each iteration. To help resolve the issues incurred by repeatedly executed queries, MySQL INTRODUCED prepared statements.

The correct option is (d) mysqli_affected_rows()

Easy explanation: The method mysqli_num_rows() is only useful for determining the number of ROWS RETRIEVED by a SELECT QUERY. But to retrieve the number of rows affected by INSERT, UPDATE, or DELETE query, use mysqli_affected_rows(). Num_rows() andaffected_rows() were used in previous version of PHP.

The CORRECT answer is (B) mysqli_free_result()

Easiest explanation: The function mysqli_free_result() is USED to free the memory which is associated with the result. Once this method is executed, the result set is no longer AVAILABLE. Free() function was used in the previous version of PHP.

Right choice is (d) mysqli_query()

To explain I would say: The METHOD mysqli_query() is responsible for SENDING the query to the database. Query() method was previously USED in older versions of PHP.

Correct answer is (a) errno()

EXPLANATION: Error numbers are often USED in lieu of natural-language message to ease software INTERNATIONALIZATION efforts and ALLOW for customization of error messages.

Right ANSWER is (C) mysqli_connect_errno()

To explain: The mysqli extension includes a few features that can be used to capture ERROR messages or alternatively you can USE exceptions.

The CORRECT OPTION is (d) $mysqli->select_db('DATABASENAME');

To explain I would say: $mysqli->select_db(‘databasename’); can be used to select the DATABASE.

Right choice is (B) $mysqli = new mysqli()

Best explanation: If you CHOOSE to INTERACT with MySQL SERVER using the object-oriented INTERFACE, you need to first instantiate the mysqli class via its constructor.

The correct option is (a) CREATE TABLE table_name (column_name column_type);

To explain: The example creates a table CALLED “student” that CONTAINS five columns: SID, LastName, FirstName, Address, and City:

Correct option is (d) PHP 5.3

The explanation: PHP required that MYSQL client LIBRARY be installed on the server from which PHP was communicating with MySQL, whether the MySQL server also HAPPENED to reside locally or elsewhere. PHP 5.3 removes this problem by introducing MySQL NATIVE Driver.

Right answer is (a) extension=php_mysqli.dll

Easiest explanation: ALSO MAKE sure that extension_dir directive points to the APPROPRIATE DIRECTORY.

Correct CHOICE is (d) MYSQL

The best explanation: We can connect, insert, UPDATE, delete and retrieve data from the databases with the help of PHP and MySQL is the most popular database system used with PHP.

Correct option is (d) PHP 4.3

For explanation: PARAMETER FLAGS was added in PHP 4.3 VERSION.

Right ANSWER is (b) preg_split()

For explanation: The string is broken up into different VALUES in the ARRAY based UPON your INPUT.

Right CHOICE is (b) Array([2]=>two [3]=>THREE [4]=>four)

To elaborate: When we include PREG_GREP_INVERT, this will invert our data, so instead of OUTPUTTING NUMBERS it will output our non-numeric VALUES.