All India Exams
Home AptitudeBankEngineeringEnglishGKInterviewOnline TestPlacement PapersReasoning
  • Home
  • Aptitude
  • Bank
  • Engineering
  • English
  • GK
  • Interview
  • Online Test
  • Placement Papers
  • Reasoning

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?

Home EngineeringComputer Science & EngineeringPHP Questions and AnswersMySQL Basics

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
  • View Answer
  • Workspace
  • Report
  • Discuss

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
  • View Answer
  • Workspace
  • Report
  • Discuss

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
  • View Answer
  • Workspace
  • Report
  • Discuss

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
  • View Answer
  • Workspace
  • Report
  • Discuss

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.

Workspace

Report Error


5. Which one of the following statements is used to create a table?
  • A. CREATE TABLE table_name (column_name column_type);
  • B. CREATE table_name (column_type column_name);
  • C. CREATE table_name (column_name column_type);
  • D. CREATE TABLE table_name (column_type column_name);
  • View Answer
  • Workspace
  • Report
  • Discuss

Answer & Explanation

Answer: Option A

Explanation:

CREATE TABLE table_name (column_name column_type);

Workspace

Report Error


  • «
  • 1
  • 2
  • 3
  • 4
  • »

Related Topics:

  • Variables
  • Exception Handling
  • Object Oriented PHP
  • HTML Forms
  • Arrays
  • Functions
  • Strings & Regular Expressions
  • PHP Basics

Mock Tests & Online Quizzes

  • Aptitude Online Test

  • Reasoning Online Test

  • GK Online Test

  • English Online Test

  • RRB Mock Test

  • RBI Mock Test

  • Free SBI Mock Test

  • IBPS Mock Test FREE

  • SSC Mock Test

  • CAT Exam Mock Test

  • GATE Mock Test

  • IT Courses Quiz

Questions and Answers

  • Aptitude Questions
  • Verbal Reasoning Questions
  • Non Verbal Reasoning
  • Logical Reasoning Questions
  • Data Sufficiency Questions
  • Data Interpretation
  • eLitmus Sample Papers
  • ECE Questions and Answers
  • EEE Questions and Answers
  • Verbal Ability Questions
  • GK Questions

Programming Quiz

  • C Programming
  • C++ Programming
  • PHP Programming
  • Java Programming
  • Python Programming
  • DataScience MCQ
  • Hadoop MCQ
  • Mongo DB MCQ
  • MySQL MCQ

Interview Questions

  • Java Interview Questions
  • .Net Interview Questions
  • Networking Interview Questions
  • C Language Interview Questions
  • C++ Interview Questions
  • Testing Interview Questions
  • Android Interview Questions
  • HR Interview Questions
  • Group Discussion Topics

Mock Tests

  • CAT Mock Test
  • SSC Mock Test
  • AMCAT Mock Online Test
  • LIC Mock Test
  • IBPS Mock Test
  • RRB Mock Test
  • RBI Mock Test
  • Free SBI Mock Test
© by AllIndiaExams.in. All Rights Reserved | Copyright | Terms of Use & Privacy Policy