What is the purpose $_PHP_SELF variable?

Correct Answer: We can send 1024 bytes utilizing GET() yet POST() can exchange extensive measure of information and POST is the protected strategy than GET technique

Correct Answer: These two methods are bulid-in methods in php with construct() we can overwride the parent class method The inverse of the __construct() PHP capacity while making another class, is the __destruct() technique The __destruct() technique will consequently keep running, after you've completed with the PHP class

Correct Answer: The function unlink() is to remove a file, where as unset() is used for destroying a variable that was declared earlier

Correct Answer: Following are the steps to create a simple AD rotator script without using database in PHP: - All the ad?s can be collected in one place and be displayed randomlyrand() function can be used for this purpose - In order to NOT use any database, a flat file can be used to store the ad?s - In order to store the Ad?s information (HTML code), a flat file say ?adtxt? can be created - The random number can be stored in a variable $result_random=rand(1, 100); - Conditions can be checked to display the ad?s if($result_random<=70) { echo "Display ad1"; }

Correct Answer: HTTP headers can be used in PHP by redirection which is written as: The headers can be added to HTTP response in PHP using the header() The response headers are sent before any actual response being sent The HTTP headers have to be sent before taking the output of any data The statement above gets included at the top of the script

Correct Answer: The principle distinction amongst sessions and cookies is that sessions are put away on the server, and cookies are put away on the client's PCs in the content record position Cookies can not hold various variables,But Session can hold numerous variablesWe can set expiry for a cookie,The session just stays dynamic the length of the program is openUsers don't have admittance to the information you put away in Session,Since it is put away in the server Session is mostly utilized for login/logout reason while cookies utilizing for client movement following

Correct Answer: $filename = "/home/user/guest/newfiletxt"; $file = fopen( $filename, "w" ); if( $file == false ) { echo ( "Error in opening new file" ); exit(); } fwrite( $file, "This is a simple test\n" ); fclose( $file );

Correct Answer: ANALYZE command is used to perform various functions on index, table, or cluster, as listed below: - It helps in dentifying migrated and chained rows of the table or cluster - It helps in validating the structure of the object - It helps in collecting the statistics about object used by the optimizer They are then stored in the data dictionary - It helps in deleting statistics used by object from the data dictionary

Correct Answer: - Mask the real name and owner of an object - Provide public access to an object - Provide location transparency for tables, views or program units of a remote database - Simplify the SQL statements for database users

Correct Answer: Cursors help you manipulate the information retrieved by select statements This can be done by assigning a name to the cursor Example: CURSOR emp_cur IS SELECT emp_number from employee_tbl where employee_name = name_in; Types of Cursors: Implicit cursors- These cursors are not declared by the programmer They are issued when the SQL statement is executed The open, close and fetching is done by itself Example: UPDATE employee SET salary = salary * 21; Here, an implicit cursor is issued to identify the set of rows in the table which would be affected by the update Explicit cursors- These cursors are defined by programmer They are used in queries that return multiple rows Example: CURSOR emp_cur IS SELECT emp_number from employee_tbl where employee_name = name_in;