Enter your keyword

MySQL

Definition


MySQL is an open source relational database management system (RDBMS) based on Structured Query Language (SQL). MySQL runs on virtually all platforms, including Linux, UNIX, and Windows. Although it can be used in a wide range of applications, MySQL is most often associated with web-based applications and online publishing and is an important component of an open source enterprise stack called LAMP

Example

".
"Title: {$row[1]}
".
"Author: {$row[2]}
".
"Submission Date : {$row[3]}
".
"--------------------------------
";
}
echo "Fetched data successfully\n";
mysql_close($conn);

Commonly asked interview questions on Constructors

1. What is MySQL?

Answer :MySQL is an open source DBMS which is built, supported and distributed by MySQL AB

2. What are the technical features of MySQL?

Answer :MySQL database software is a client or server system which includes Multithreaded SQL server supporting various client programs and librarie Different backend Wide range of application programming interfaces and

3. Why MySQL is used?

Answer :MySQL database server is reliable, fast and very easy to use. This software can be downloaded as freeware and can be downloaded from the internet.

4. What are Heap tables?

Answer :HEAP tables are present in memory and they are used for high speed storage on temporary

basis.

• BLOB or TEXT fields are not allowed

• Only comparison operators can be used =, <,>, = >,=< • AUTO_INCREMENT is not supported by HEAP tables • Indexes should be NOT NULL

5.What are the advantages of MySQL when compared with Oracle?

Answer :MySQL is open source software which is available at any time and has no cost involved.
MySQL is portable
GUI with command prompt.
Administration is supported using MySQL Query

Take Sample Test

Reference Books


1. Head First Java

No Comments

Add your review

Your email address will not be published.