Interview Questions

Dashboards are real-time business intelligence interfaces. They allow a huge amount of data to be read in a single interface in order to analyse the success or failure of the business or project in question

mysql_fetch_array:
Fetch a result row as an associative array and a numeric array.

mysql_fetch_object:
Returns an object with properties that correspond to the fetched row and moves the internal data pointer ahead. Returns an object with properties that correspond to the fetched row, or FALSE if there are no more rows.

mysql_fetch_row():
Fetches one row of data from the result associated with the specified result identifier. The row is returned as an array. Each result column is stored in an array offset, starting at offset 0.

Oracle constraints are used to maintain consistent of data and ensure the data is properly maintained. A constraint is more or less a restriction we try to apply on a table.
Types of constraints:
- Check constraints
- NOT NULL constraint
- PRIMARY KEY constraint
- REFERENCES constraint
- UNIQUE constraint

echo() and print() are language constructs in PHP, both are used to output strings. The speed of both statements is almost the same.

echo() can take multiple expressions whereas print cannot take multiple expressions.

Print return true or false based on success or failure whereas echo doesn't return true or false.

The business analyst must understand IT and also has to understand the stakeholder’s needs. 

A systems analyst has the ability to look at a program or utility and see the code. They can go in and pinpoint where changes need to be made. 

The Best way to answer this question:

Be honest but stay positive.  Of course, your answer should be based on the real reason you left, but put a positive spin on it. That means, you should try to frame your honest answer in the most positive way possible.Do not lie, be truthful and honest but do not be harsh on a previous employer. So answer truthfully while at the same time NOT talking about the company or staff in a negative light. More info on why you left a job would help to give applicable suggestions. You TELL them why you left! .  Make it sound as positive as possible though. Put the reason you are no longer at your last job in your question. Unless you were laid off or the company had relocated you too far, just say "it's a career move." It's better not to go into the specifics. Always keep in mind that your  interviewer is looking for a positive, motivated, hard-working candidate. No potential employer wants to hear your gripe about a prior boss or talk poorly about a previous employer. She or he wants to hear about your potential as a superstar at the position you are seeking.

PL/SQL exceptions are raised using the RAISE command. This command is used when exceptions are defined by programmer and not implicit exceptions.

Example:

Declare and raising an exception:

DECLARE

short_of_attendance EXCEPTION;

min_attendance NUMBER(4);

BEGIN

...

IF min_attendance < 10 THEN

RAISE short_of_attendance;

END IF;

EXCEPTION

WHEN short_of_attendance THEN

-- handle the error

END;

Authorization: The process of granting access privileges to resources or tasks within an

application.

Authentication: The process of validating the identity of a user.