Interview Questions in PHP and MySQL - 1

# How can we repair a MySQL table?
Ans: REPAIR TABLENAME, [TABLENAME, ], [Quick],[Extended]
This command will repair the table specified
if the quick is given the mysql will do a repair of only the index tree if the extended is given it will create index row by row

# What are the advantages of stored procedures, triggers, indexes?
# What is the maximum length of a table name, database name, and fieldname in MySQL?
Ans: database- 64
table -64
columns-64
alias-255

# How many values can the SET function of MySQL take?
# What are the other commands to know the structure of table using MySQL commands except explain command?

# How many tables will create when we create table, what are they?
# What is the purpose of the following files having extensions 1) .frm 2) .myd 3) .myi? What do these files contain?
# What is maximum size of a database in MySQL?
# Give the syntax of Grant and Revoke commands?
# Explain Normalization concept?
# How can we find the number of rows in a table using MySQL?
# How can we find the number of rows in a result set using PHP?
# How many ways we can we find the current date using MySQL?
# What are the advantages and disadvantages of Cascading Style Sheets?
# What type of inheritance that PHP supports?
# How can increase the performance of MySQL select query?
# The structure of table view buyers is as follows:

+----------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+----------------+
| user_pri_id | int(15) | | PRI | NULL | auto_increment |
| userid | varchar(10) | YES | | NULL | |
+----------------+-------------+------+-----+---------+----------------+

the value of user_pri_id the last row 2345 then What will happen in the following conditions?

Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id ,
Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id
# What are the advantages/disadvantages of MySQL and PHP?
# What is the difference between GROUP BY and ORDER BY in Sql?
# What is the difference between char and varchar data types?
# What is the functionality of md5 function in PHP?
# How can I load data from a text file into a table?
# How can we know the number of days between two given dates using MySQL?
# How can we know the number of days between two given dates using PHP?
# How can we change the name of a column of a table?
# How can we change the name and data type of a column of a table?
# What are the differences between drop a table and truncate a table?
# When you want to show some part of a text displayed on an HTML page in red font color, what different possibilities are there to do this? What are the advantages/disadvantages of these methods?
# When viewing an HTML page in a Browser, the Browser often keeps this page in its cache. What can be possible advantages/disadvantages of page caching? How can you prevent caching of a certain page (please give several alternate solutions)?
# What are the different methods of passing data or information between two calls of a web page? What are the advantages/disadvantages of these methods?
# An Apache web server is running on a Linux system. Suddenly, the web server delivers the pages very slow. How could you find out possible reasons for that (when using system commands, please specify their names)?
# What are the different ways to login to a remote server? Explain the means, advantages and disadvantages?
# Please give a regular expression (preferably Perl/PREG style), which can be used to identify the URL from within a HTML link tag. Example: The regular expression should match the tag <A HREF=”http://www.yoursite.com/”> and give the URL (”http://www.yoursite.com /”) as a return result. Tags should also be matched if they contain other attributes than the HREF attribute.
# A select query over a large table runs very slow because of the growing number of entries in that table. What different measures could be taken to improve speed?
# A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.
# For the database from the previous question, please give an SQL query which returns the invoice number of all invoices which contain the article with the number “1234?. The query should be able to run under a MySQL 4.0 database.
# How would you backup and restore a big MySQL database? What are the advantages of the approach which you have taken over the others?
# Create a PHP web script with the following attributes: on start, three HTML form elements are shown: an string input field, a checkbox field, a dropdown/pull down list with 5 elements and a submit button. On submission, the form should be redisplayed (while remaining all options/inputs as the user has selected/entered them). Additionally, the selections/inputs of the user should be displayed in text. Please solve this without the use of any external libraries.
# What is MIME?
Ans: MIME is Multipurpose Internet Mail Extensions is an internet standard for the format of e-mail. Howewer browsers also uses MIME standart to transmit files. MIME has a header wich is added to a begining of the data. When browser sees such header it shows the data as it would be a file (for example image)

# What is PEAR in PHP?
Ans: PEAR is short for “PHP Extension and Application Repository” and is pronounced just like the fruit. The purpose of PEAR is to provide:
A structured library of open-sourced code for PHP users
A system for code distribution and package maintenance
A standard style for code written in PHP
The PHP Foundation Classes (PFC),
The PHP Extension Community Library (PECL),
A web site, mailing lists and download mirrors to support the PHP/PEAR community
PEAR is a community-driven project with the PEAR Group as the governing body. The project has been founded by Stig S. Bakken in 1999 and quite a lot of people have joined the project since then.
http://pear.php.net/manual/en/introduction.php

# How can I use the COM components in PHP?
# How can I load the DLLs dynamically?
# How many ways we can give the output to a browser?
# How can we know that a session is started or not?
# What is the default session time in PHP and how can I change it?
# What changes I have to done in PHP.ini file for file uploading?
# What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?
# How can I set a cron and how can i execute it in Unix, Linux, and windows?
# Steps for the payment gateway processing?
# How many ways I can register the variables into session?
# Explain different types of errors in PHP (i.e. arguments in errorreporting function)?
# How many ways I can redirect a PHP page?
# List out different arguments in PHP header function?
# What type of headers have to add in the mail function in which file a attached?
# What is the difference between
# What are the differences between include() and include_once() functions?
# Describe the importance of database abstraction layers in PHP and database connection?
# Explain MySQL optimization?
# What is the difference between using copy() and move() function in PHP file uploading?
# What is the difference between Reply-to and Return-path in the headers of a mail function?
# Explain about Type Juggling in PHP?
# How can I get the only name of the current executing file?
# How can I embed a Java program in PHP file and what changes have to be done in PHP.ini file?
# How can I find what type of images that the PHP version supports?
# The table tbl_sites contains the following data: