What is the difference between mysql_connect and mysql_pconnect?

Correct Answer: Copy() makes a copy of the file It returns TRUE on success It can copy from any source to destination Move simply Moves the file to destination if the file is valid While move can move the uploaded file from temp server location to any destination on the server If filename is a valid upload file, but cannot be moved for some reason, no action will occur

Correct Answer: Opendir():- It opens the directory This function returns a directory stream on success and FALSE and an error on failure Syntax: Opendir(directory, context) Context is a set of options that can modify the behavior of a stream Example: opens sample directory $dir = opendir("directory"); Readdir(): It returns an entry from a directory handle opened by opendir() Syntax: Readdir(dir_stream) Example: $file = readdir($dir); closedir(): It closes a directory handle opened by opendir() Syntax: closedir(dir_stream) Example: $file = close($dir);

Correct Answer: Chmod() is used for changing permissions on a file Syntax: Chmod(file, mode) Mode here specifies the permissions as follows: The first number is always zero The second number specifies permissions for the owner The third number specifies permissions for the owner's user group The fourth number specifies permissions for everybody else Possible values (to set multiple permissions, add up the following numbers) 1 = execute permissions 2 = write permissions 4 = read permissions Example: // everything for owner, read for owner's group chmod("testtxt",0740);

Correct Answer: User names and passwords in PHP can be encrypted using md5 function MD5 function calculates the md5 hash of a string It is basically used for encryption It is also used for digital signature applications, where a large file must be "compressed" in a secure manner Example: Md5($str); Crypt() function can also be used to encrypt a string, It used MD5, DES or blow fish algorithms for encryption Syntax: Crypt(str, salt) Salt is an optional parameter used to increase the number of characters encoded, to make the encoding more secure

Correct Answer: A PHP Session persist the user information to be used later For example, user name, password, shopping item details The session is temporary and will be removed soon after the user has left the web site The session can be persisted for long term usage on databases like MySQL Each session is identified by a unique Id number for every visitor The first step to use PHP session is to start the session The starting session must precede the operations like HTML or the other The statement session_start() starts the PHP session and registers the user?s information on the server

Correct Answer: - When two processes are waiting to update the rows of a table which are locked by another process, the situation is called a deadlock - The reasons for it to happen are: * lack of proper row lock commands * Poor design of front-end application - It reduces the performance of the server severely - These locks get automatically released automatically when a commit/rollback operation is performed or any process is killed externally

Correct Answer: Control File is used for: - Database recovery - Whenever an instance of an ORACLE database begins, its control file is used to identify the database and redo log files that must be opened for database operation to go ahead

Correct Answer: - TABLES - VIEWS - INDEXES - SYNONYMS - SEQUENCES - TABLESPACES

Correct Answer: - Rename : It is a permanent name provided to a table or column - Alias : It is a temporary name provided to a table or column which gets over after the execution of SQL statement

Correct Answer: It is virtual table which is defined as a stored procedure based on one or more tables