Interview Questions

%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;

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.

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.

Security is one of the major aspects which come with any application and service used by the user. Companies or organizations remain much more concerned with the security provided with the cloud. There are many levels of security which has to be provided within cloud environment such as:

• Identity management: it authorizes the application service or hardware component to be used by authorized users.

• Access control: permissions has to be provided to the users so that they can control the access of other users who are entering the in the cloud environment.

• Authorization and authentication: provision should be made to allow the authorized and authenticated people only to access and change the applications and data.

The mail() function allows you to send emails directly from a script.