Interview Questions

All indicate dataset out of space. SD37 - no secondary allocation was specified. SB37 - end of vol. and no further volumes specified. SE37 - Max. of 16 extents already allocated.

%type is used to declare a field of a table while %rowtype is used to declare a record with the same type as specified in that table, view or cursor.

Example of %type:

DECLARE

         v_EmployeeName emp.ename%TYPE

Example of %rowtype

DECLARE

          v_empployee emp%ROWTYPE;

The best way to respond to the interview question "What are your goals for the future?"

Don't discuss your goals for returning to school or having a family, they are not relevant and could knock you out of contention for the job. Rather, you want to connect your answer to the job you are applying for. Examples of good responses include:

=> My long-term goals involve growing with a company where I can continue to learn, take on additional responsibilities, and contribute as much of value as I can.

=> I see myself as a top performing employee in a well-established organization, like this one. I plan on enhancing my skills and continuing my involvement in (related) professional associations.

=> Once I gain additional experience, I would like to move on from a technical position to management.

=> In the XYZ Corporation, what is a typical career path for someone with my skills and experiences?

A segment of the financial market in which financial instruments with high liquidity and very short maturities are traded. The money market is used by participants as a means for borrowing and lending in the short term, from several days to just under a year. Money market securities consist of negotiable certificates of deposit (CDs), bankers acceptances, U.S. Treasury bills, commercial paper, municipal notes, federal funds and repurchase agreements (repos).

Web standards are rules and guidelines established by the World Wide Web Consortium ( W3C ) developed to promote consistency in the design code which makes up a web page.

W3C is an international community of member organizations created in 1994 that articulates web standards so that websites look and work the same in all web browsers.

Its mission is to lead the World Wide Web to its full potential.

Constructors use this to refer to another constructor in the same class with a different parameter list.

Constructors use super to invoke the superclass's constructor. If a constructor uses super, it must use it in the first line; otherwise, the compiler will complain.

There are broadly  2 Type of accounts

1. Personnel Accounts

2. Impersonnel Accounts.

Personnel Accounts is an account maintained to record transactions with persons. Based on the classification of the persons personnel account can be of

1. Natural Personnel Account (Mr. Ram, Mr. Robert, Mr.Rahim)

2. Artificial Person (all entities like companies, banks, municipal corporations, all statutory or non statutory bodies)

3. Representative Person: Representing group transactions for group of persons like Salary Payable Account. Taxes payable account.

Where as Impersonnel Account shall be of Two types.

A. Real Account      B.Nominal Account.

Real Accounts are accounts to record transactions relating to Assets. Like Cash, Plant & Machinery etc., These type of accounts are permanent accounts.

Nominal Accounts are the accounts used to record the transactions relating to Income and Expenses. Like Salary, Power, Sales etc., At the end of the year all the nominal accounts are closed by transferring to Profit and loss account or Income and Expenditure account. The net differnce shall be carried forwarded to Balance Sheet.

-Daily loading is known as incremental load.

-When data is selected from source, selected records are loaded between timestamp of last load and the current time 

-The parameter that are passed to perform are last loaded date and current date

-The first parameter is the stored last run date is read through job parameters

-The second parameter is the current date