PHP Interview question 6

 11)  What are the different tables(Engine) present in MySQL, which one is default?

Ans :      Following tables (Storage Engine) we can create

1. MyISAM(The default storage engine IN MYSQL Each MyISAM table is stored on disk in three files. The files have names that begin with the table name and have an extension to indicate the file type. An .frm file stores the table format. The data file has an .MYD (MYData) extension. The index file has an .MYI (MYIndex) extension. )

2. InnoDB(InnoDB is a transaction-safe (ACID compliant) storage engine for MySQL that has commit, rollback, and crash-recovery capabilities to protect user data.)

3. Merge

4. Heap (MEMORY)(The MEMORY storage engine creates tables with contents that are stored in memory. Formerly, these were known as HEAP tables. MEMORY is the preferred term, although HEAP remains supported for backward compatibility. )

5. BDB (BerkeleyDB)(Sleepycat Software has provided MySQL with the Berkeley DB transactional storage engine. This storage engine typically is called BDB for short. BDB tables may have a greater chance of surviving crashes and are also capable of COMMIT and ROLLBACK operations on transactions)

6. EXAMPLE

7. FEDERATED (It is a storage engine that accesses data in tables of remote databases rather than in local tables. )

8. ARCHIVE (The ARCHIVE storage engine is used for storing large amounts of data without indexes in a very small footprint. )

9. CSV (The CSV storage engine stores data in text files using comma-separated values format.)

10. BLACKHOLE (The BLACKHOLE storage engine acts as a "black hole" that accepts data but throws it away and does not store it. Retrievals always return an empty result)

                 

12 )  What is use of header() function in php ?

Ans :      The header() function sends a raw HTTP header to a client.We can use herder()

function for redirection of pages. It is important to notice that header() must

be called before any actual output is seen..

                 

 13)How can I execute a PHP script using command line?

Ans :      Just run the PHP CLI (Command Line Interface) program and

provide the PHP script file name as the command line argument.

                 

14) Suppose your Zend engine supports the mode <? ?> Then how can u configure your PHP Zend engine to support <?PHP ?> mode ?

Ans :      In php.ini file:

set

short_open_tag=on

to make PHP support

                 

15) Shopping cart online validation i.e. how can we configure Paypal,etc.?

Ans :      Nothing more we have to do only redirect to the payPal url after

submit all information needed by paypal like amount,adresss etc.