MySQL Basic Questions And Answers

Here you can find MySQL Basic Questions and Answers.

Why MySQL Basic Questions and Answers Required?

In this MySQL Basic Questions and Answers section you can learn and practice MySQL Basic Questions and Answers to improve your skills in order to face technical inerview conducted by organisations. By Practicing these interview questions, you can easily crack any Exams interview.

Where can I get MySQL Basic Questions and Answers?

AllIndiaExams provides you lots MySQL Basic Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students, freshers can download MySQL Basic Questions and Answers as PDF files and eBooks.

How to solve these MySQL Basic Questions and Answers?

You no need to worry, we have given lots of MySQL Basic Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the Competitive Exams interview.

MySQL Basics Questions & Answers

1. Which one of the following databases has PHP supported almost since the beginning?

MySQL Basics Questions & Answers

2. The updated MySQL extension released with PHP 5 is typically referred to as..

MySQL Basics Questions & Answers

3. Which one of the following lines need to be uncommented or added in the php.ini file so as to enable mysqli extension?

MySQL Basics Questions & Answers

4. In which version of PHP was MySQL Native Driver(also known as mysqlnd) introduced?

MySQL Basics Questions & Answers

5. Which one of the following statements is used to create a table?

MySQL Basics Questions & Answers

6. Which one of the following statements instantiates the mysqli class?

MySQL Basics Questions & Answers

7. Which one of the following statements can be used to select the database?

MySQL Basics Questions & Answers

8. Which one of the following methods can be used to diagnose and display information about a MySQL connection error?

MySQL Basics Questions & Answers

9. Which method returns the error code generated from the execution of the last MySQL function?

MySQL Basics Questions & Answers

10. If there is no error, then what will the error() method return?

MySQL Basics - PHP Questions and Answers

This is the questions and answers section on "PHP MySQL Basics" with the explanation for various interview, competitive examination and entrance test. Solved examples with detailed answer description, explanation are given and it would be easy to understand.

PHP MySQL Basics Questions

Online Test Name	PHP MySQL Basics
Exam Type	Multiple Choice Questions
Category	Computer Science Engineering Quiz
Number of Questions	20

1. Which one of the following databases has PHP supported almost since the beginning?

A. Oracle Database
B. SQL
C. SQL+
D. MySQL

Answer & Explanation

Answer: Option D

Explanation:

MySQL

Workspace

Report Error

2. The updated MySQL extension released with PHP 5 is typically referred to as..

A. MySQL
B. mysql
C. mysqli
D. mysqly

Answer & Explanation

Answer: Option C

Explanation:

The updated MySQL extension with PHP 5 is known as MySQL and typically referred to as mysqli.

Workspace

Report Error

3. Which one of the following lines need to be uncommented or added in the php.ini file so as to enable mysqli extension?

A. extension=php_mysqli.dll
B. extension=mysql.dll
C. extension=php_mysqli.dl
D. extension=mysqli.dl

Answer & Explanation

Answer: Option A

Explanation:

Also make sure that extension_dir directive points to the appropriate directory.

Workspace

Report Error

4. In which version of PHP was MySQL Native Driver(also known as mysqlnd) introduced?

A. PHP 5.0
B. PHP 5.1
C. PHP 5.2
D. PHP 5.3

Answer & Explanation

Answer: Option D

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.