Interview Questions For PHP and Mysql | Basic and Advanced Level

Written by Bhavya Sri | May 23, 2017 11:50:04 AM

Q1. What is php nd Mysql?

Ans: PHP is the most popular scripting language for web development. It is free, open source and server-side (the code is executed on the server). MySQL is a Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

Q2. Is MySQL is a programming language?

Ans: SQL stands for Structured Query Language, and it is a programming languagedesigned for querying data from a database. MySQL is a relational database management system, which is a completely different thing.

Q3. What is the purpose of my SQL?

Ans: MySQL is a relational database management system based on SQL – Structured Query Language. The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications. The most common use formySQL however is for the purpose of a web database.

Q4. What is the use of mysql?

Ans: MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). SQL is the most popular language for adding, accessing and managing content in a database. It is most noted for its quick processing, proven reliability, ease and flexibility of use.

Q5. Who created SQL?

Ans: SQL was initially developed at IBM by Donald D. Chamberlin and Raymond F. Boyce after learning about the relational model from Ted Codd in the early 1970s.

Click Here For PHP and Mysql

Q6. What is a postgresql database?

Ans: PostgreSQL (pronounced "post-gress-Q-L") is an open source relational databasemanagement system ( DBMS ) developed by a worldwide team of volunteers.PostgreSQL is not controlled by any corporation or other private entity and the source code is available free of charge.

Q7. Why PHP language is used?

Ans: PHP is a general-purpose scripting language that is especially suited to server-side web development, in which case PHP generally runs on a web server. Any PHPcode in a requested file is executed by the PHP runtime, usually to create dynamic web page content or dynamic images used on websites or elsewhere.

Q8. What is my SQL Server?

Ans: MySQL is an open source relational database management system (RDBMS) based on Structured Query Language (SQL). ... LAMP is a Web development platform that uses Linux as the operating system, Apache as the Web server, MySQL as the relational database management system and PHP as the object-oriented scripting language.

Q9. Is SQL a programming language?

Ans: Fourth-generation languages are programming languages that are closer to humanlanguage than high-level languages like Java. These 4GLs are often used to access databases, such as SQL, where humanlike syntax is used to retrieve and manipulate data. SQL may not be a language on par with Java or C#, but it is alanguage.

Q10. What is a Postgis database?

Ans: PostGIS is an open source, freely available, and fairly OGC compliant spatialdatabase extender for the PostgreSQL Database Management System. In a nutshell it adds spatial functions such as distance, area, union, intersection, and specialty geometry data types to the database.

Q11. Is postgresql is Nosql database?

Ans: NoSQL databases like MongoDB or CouchDB generally compete with each other, but now a relational database is positioning itself as a NoSQL player. ThePostgreSQL Project, which EnterpriseDB supports, added NoSQL-style JSON processing features back in 2012.

Q12. Why do we need to use PHP?

Ans: A good benefit of using PHP is that it can interact with many different database languages including MySQL. We work with MySQL at Bluelinemedia since this is also a free language so it makes sense to use PHP. Both PHP and MySQL are compatible with an Apache server which is also free to license.

Q13. What is PHP and what does it do?

Ans: PHP is mainly focused on server-side scripting, so you can do anything any other CGI program can do, such as collect form data, generate dynamic page content, or send and receive cookies. But PHP can do much more. There are three main areas where PHP scripts are used. Server-side scripting.

Q14. What is PHP and what does it do?

Q15. What does it mean in PHP?

Ans: PHP Assignment Operators. The PHP assignment operators are used with numeric values to write a value to a variable. The basic assignment operator in PHP is "=". Itmeans that the left operand gets set to the value of the assignment expression on the right.

Q16. What is the difference between HTML and PHP?

Ans: HTML is a language used to describe to a browser how to display text and other objects in a browser window. It is not a programming language. HTML works on a client computer (the system on which the page is being viewed). PHP is a scripting language, and can be used to create web pages written in HTML.

Q17. Where do you use SQL?

Ans: To build a web site that shows data from a database, you will need:

An RDBMS database program (i.e. MS Access, SQL Server, MySQL)
To use a server-side scripting language, like PHP or ASP.
To use SQL to get the data you want.
To use HTML / CSS to style the page.

Q18. What is SSMS SQL?

Ans: SQL Server Management Studio (SSMS) is a software application first launched with Microsoft SQL Server 2005 that is used for configuring, managing, and administering all components within Microsoft SQL Server. The tool includes both script editors and graphical tools which work with objects and features of the server.

Q19. What is meant by SQL Server?

Ans: SQL Server is Microsoft's relational database management system (RDBMS). It is a full-featured database primarily designed to compete against competitors Oracle Database (DB) and MySQL.. SQL Server is sometimes referred to as MSSQL and Microsoft SQL Server.

Q20. What is my SQL Server?

Q21. What is the difference between mysql and SQL?

Ans: SQL stands for Structured Query Language. It's a standard language for accessing and manipulating databases. MySQL is a database management system, like SQLServer, Oracle, Informix, Postgres, etc. MySQL is an RDMS (Relational Database Management System).

Q22. What is the use of mysql database?

Q23. Why PHP language is used?

MySQL keeps the ACLs (also called grant tables) cached in memory. When a user tries to authenticate or run a command, MySQL checks the authentication information and permissions against the ACLs, in a predetermined order.