1.what is oops?
2.what are new in php5?
3.what are new in mysql5?
4.what is the difference between include and require?
5.what is the difference between unique and primary key?
6.what are primary and foreign key?
7.what is the difference between group by and order by?
8.what is the difference between mysql_connect() and mysql_pconncect()?
9.what is the default php script execution time(30 sec) and upload file size(2 Mb bytes), post form (8 M)size?
10.what is array?
11.Some array functions and string functions?
12.what is magic constants?
13.what is normalization?
15.what are think u will consider, when u design the table?
16.what are the difference between GET and POST methods?
17.To upload a file what parameter we have to add in the form tag?
18.How do u connect the script with the database?
19.What is maximum table size and maximum row size in mysql?
20.what are session and cookies and what is the difference between session and cookies?
21.what is indexing?
22.what is the difference between delete table and truncate table?
23.Maximum length for mysql table, column name – 64 characters.
24. MySQL: Maximum number of columns in one table – 3398; size of a table row – 65534 (BLOB and TEXT not included).
25. MySQL: Number of tables – not limited, up to 32 indexes per table with 256 bytes maximum key length.
26.What is the difference between single quote(‘’) and double quote (“”)?
27. what is the difference between $var and $$var?
Primary key:
A primary key is a unique identifier that has to abide by certain rules. They must
Always have a value (it cannot be NULL)
Have a value that remains the same (never changes)
Have a unique value for each record in the table
27. Forign key:
Foreign keys are the representation of the primary key from Table A in Table B.
