Interview Questions

The 2 editors are se38 and se80 both have the abap editor in place. In se38 you can go create programs and view online reports and basically do all thedevelopmet of objects in this editor. In se80 ( object navigator) there are additional features such as creating packages,module pool , function group ,classes, programs ( where you can create ur programs) and BSP applications .

Basic Replication : Basic replication is implemented using standard CREATE SNAPSHOT or CREATE MATERIALIZED VIEW statements. It can only replicate data and not procedures, indexes replication is always one-way, and snapshot copies are read only.

Advanced Replication : Advanced replication supports various configurations of updatable snapshot, multi-master and update anywhere replication. It is more difficult to configure but allows data and other database objects like indexes and procedures to be replicated.

Differences between Basic and Advanced replications:

- With basic replication, data replicas provide read-only access to the table data whereas advanced replication features extend the capabilities of basic read-only replication by allowing applications to update table replicas throughout a replicated database system.

- With Basic Replication applications can query data from local data replicas. On the other hand with advanced replication, data replicas anywhere in the system can provide both read and update access to a table's data.

Classless Inter-Domain Routing 

- Multi-threading fetching in Amazon S3 is used to fetch the objects concurrently using the multiple threads and map the task so that fetching can be made simpler. 

- It is not a good practice to increase the threading for a particular object as every node on the server has some bandwidth constraints. 

- It provides user the ease with which they can upload the files and upload the threads in parallel. 

- It provides high speed of data transfer and easy maintenance of the sever as well.

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

Payroll reports gives information about the total 'cost to Company' for the Employee Salary, Benefits (Cash and Non-Cash), Taxes, Total Hours worked. 

All these information is helpful for the Management decisions.

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.