Technology Questions

1. Based on the lock-size given while creating the table space

2. Programer can direct the DB2 what lock-size to use

3. If lock - size ANY is specified, DB2 usually chooses a lock-size of PAGE

SELECT DISTINCT(salary) FROM emp as e1 

WHERE (3) = (SELECT COUNT(DISTINCT(salary)) FROM emp as e2  WHERE e1.salary <= e2.salary)

A HTML form should be build before uploading the file. The following HTML code is used for selecting the file that is to be uploaded. The type attribute of input must be “file”.

<form enctype="multipart/form-data" action="uploader.php" method="POST">

<input type="hidden" name="MAX_FILE_SIZE" value="100000" />

Choose a file to upload: <input name="uploadedfile" type="file" /><br />

<input type="submit" value="Upload File" />

</form>

At the time of executing uploader.php, the uploaded file will be stored in a temporary storage are on the webserver. An associative array $_FILES['uploadedfile']['name'] is used for uploading. The ‘name’ is the original file that is to be uploaded. Another associative array $_FILES['uploadedfile']['tmp_name'] is used for placing the uploaded file in a temporary location on the server and the file should be empty and should exist with the tmp_name.

The following code snippet is used for uploading the file.

$target_path = "uploads/"; // the target location of the file

$target_path = $target_path . basename( $_FILES['uploadedfile']['name']);

if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) 

{

       echo "The file ". basename( $_FILES['uploadedfile']['name']). 

        " has been uploaded";

}

else

{

      echo “There was an error while uploading the file”;

}

The function move_uploaded_file()is used to place the source file into the destination folder, which resides on the server.

If the uploading is successful, the message “The file filename has been uploaded. Otherwise the error message “There was an error while uploading the file” would be displayed.

The app delegate object is created by UIApplicationMain function at app launch time. The app delegate object's main job is to handle state transitions within the app.

To make this method available to every implementation class

An alert box displays only one button which is the OK button whereas the Confirm box displays two buttons namely OK and cancel.

View:

- Tail raid data representation is provided by a view to access data from its table.

- It has logical structure can not occupy space.

- Changes get affected in corresponding tables.

Materialized view

- Pre calculated data persists in materialized view.

- It has physical data space occupation.

- Changes will not get affected in corresponding tables.

- NOHANDLE is an option that can be specified along with abnormal condition during program execution.

- When the exception occurs, no action is performed during execution of NOHANDLE command.

- The abnormal condition is ignored, even the EXEC CICS HANDLE condition exist.

- The abnormal condition is also ignored when EXEC CICS IGNORE condition is tested.

- The previous HANDLE CONDITION for other commands will not be effected with NOHANDLE option.