What's the difference between Session and Cookie?

Correct Answer: The PHP default variable $_PHP_SELF is utilized for the PHP script name and when you click "submit" catch then same PHP script will be called

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: $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;

Correct Answer: Named PL/SQL blocks of code which can be invoked using parameters are called PL/SQL sub programs Advantages of PL/SQL subprograms are - The application makes a single call to the database to run a block of statements which improves performance against running SQL multiple times This will reduce the number of calls between the database and the application - PL/SQL is secure since the code resides inside the database thus hiding internal database details from the application The application will only make a call to the PL/SQL sub program - PL/SQL and SQL go hand in hand so there would be no need of any translation required between PL/SQL and SQL