Interview Questions

<?php
$file = fopen("file.txt","r");
?>

The backup strategies that are provided by Oracle are as follows:

- Logical backup using Exports and import.

- Physical file system backup

- RMAN Recovery Manger which is also known as incremental files system backup.

Android Application Architecture has the following components:
* Services – like Network Operation
* Intent - To perform inter-communication between activities or services
* Resource Externalization - such as strings and graphics
* Notification signaling users - light, sound, icon, notification, dialog etc.
* Content Providers - They share data between applications

There are lots of ways to solve the issue of callback hells:

1. Modularization: break callbacks into independent functions
2. Use a control flow library, like async
3. Use generators with Promises
4. Use async/await (note that it is only available in the latest v7 release and not in the LTS version)

Why Are You Looking For A New Job?

Purpose - This question is asked to get some insights into your personality and your relationship with your last job, colleagues and employer. So you should be careful while answering this question.

1. Never bad-mouth your former employers.
Why? It is very simple as the interviewer will envision that you will bad-mouth them when you decide to leave, and nobody wants bad rumors about themselves or their company.

2. Never bad-mouth your previous co-workers.
Why? This world is too small, your co-workers could be a friend, relative of the interviewer.

3. Never bad-mouth about the responsibilities and tasks you performed at your previous job.
Why? Thinking that the new employer would give you great responsibilities and tasks and if you give a hate speech on the previous job responsibilities and activities and to your surprise if your interviewer is thinking about similar tasks for this position, you have already given a reason to quit the new job which you have not yet got. So guess, the chances of you getting the job is Nil.

Keep the answer short and try not to disclose too much. A straight answer is best and as stated above avoid negative statements about yourself, your work, or your ability to get along with others.

E.g.
My organization was forced to downsize.

Our department was eliminated due to corporate restructuring.

I am looking for a bigger challenge and to grow my career.

I am relocating to this area due to family ( Marriage, Kids Education etc...)

I received degree and want to utilize my new skills in this new position.

I am interested in a job with more responsibility and challenges.

I am seeking a position with a stable company with room for growth and opportunity for advancement.

To insert a NULL, move -1 to the null indicator

To insert a valid value, move 0 to the null indicator

You should have recorded in your cash books all amounts you have actually received and payments you have actually made. However the cash books may be incomplete as your bank may have put extra transactions through your account such as:

► bank fees or interest charges
► direct debits (payments) and direct credits (receipts).

Doing a regular bank reconciliation will allow you to:

► take into account any extra transactions your bank puts through your account and
► check and record any errors or omissions.

By regularly doing a bank reconciliation (say monthly) you can be more confident that your records contain all the information you need to prepare your income tax return and activity statements.

- %FOUND

 This is a Boolean variable which evaluates to TRUE if the last row is successfully fetched.

- %NOTFOUND

 This is a Boolean variable which evaluates to TRUE if the last row is not successfully fetched. This means there are no more rows to fetch.

- %ROWCOUNT

 Returns the number of rows fetched by the cursor.

- %ISOPEN

If the cursor is open, it evaluates to TRUE else FALSE.