Interview Questions

The following are the areas of concern for tuning:

- Memory Usage

- Data Storage

- Data Manipulation

- Physical Storage

- Logic Storage

- Network Traffic

Tuning Memory Usage: In Oracle 10g, we can use the Automatic Workload Repository (AWR) toolset to gather and manage statistical data but in case of Oracle 11g, we can use new initialization parameters such as MEMORY_TARGET to further control the overall memory used by Oracle. It helps us to tune the database automatically when we don’t have time to read the AWR report.

Tuning Data Manipulation: There are two ways to tune Data manipulation in Oracle one way is through Conventional Path mode and second is Direct Path mode.

Tuning Physical Storage: We need to tune the physical storage because it limits the disk in database. This can be done by: Distributing I/O, Striping and Mirroring.

Example:

“I have no problems with change. I am sure in my ability to regulate my actions of behaviors as needed, and take up myself adaptable to all situations – not just change.”

the layer that establishes ,manages and terminates the session between two communticating devices

This question focuses to check your ability to handle situations. Do not answer this question with anything that states retaliation. Talk about handling the situation with patience and relaxed mind set. You can answer it as “ If the customer on the other side of the phone line is angry i will first try calming him and ask him his/her problem. After that I will try sufficing the best solution keeping in mind his problem. In this sector customer satisfaction is very important and thus it will be my primary goal.

array_flip exchange the keys with their associated values in array ie. Keys becomes values and values becomes keys.

<?php
$arrayName    = array("course1"=>"php","course2"=>"html");
$new_array    = array_flip($arrayName);
print_r($new_array);
?>

OUTPUT :

Array
(
[php]     => course1
[html]    => course2
)

A destructor is automatically called when the object is destroyed. A virtual destructor in C++ is used primarily to prevent resource leaks by performing a clean-up of the object.

The QA testing process that was followed in my last company where I worked was like this: First of all the Business Requirement Document was prepared as per the client’s requirement (with the muck-up screen shots). Then on the basis of the requirement document, Test Strategy, Test Plans and Test Cases were written in sequential order. Once the Build is made and deployed to the different testing environments where different types of testing were performed to check whether there are any defects.

A JAR file (short for Java Archive) is a ZIP file used to distribute a set of Java classes. It is used to store compiled Java classes and associated metadata that can constitute a program