Interview Questions

Q:

What are the types of constraints avaialable in oracle?

Answer

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

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2307
Q:

Client code having direct access to internal data is called

A) Encapsulation B) DataHiding
C) Polymorphism D) DataAbstraction
 
Answer & Explanation Answer: B) DataHiding

Explanation:

Client code must use setters and getters to access internal data in DataHiding

Report Error

View Answer Report Error Discuss

Filed Under: Java

0 2307
Q:

Explain the difference between fixed and flexible budgets ?

Answer

1. A fixed budget is established for a specific level of activity whereas flexible budget is prepared for various levels of activity.


2. Fixed budget cannot be changed after the period commences, whereas a flexible budget can be changed after the period commence.


3. Fixed budget is more suitable for fixed expenses whereas flexible budget takes both fixed as well as variable expenses in account.


4. Fixed budget includes only fixed costs, whereas a flexible budget includes fixed costs, variable costs and semi variable costs.


5. Fixed budget is mainly used in planning stage whereas flexible budget is used in controlling stage.

Report Error

View answer Workspace Report Error Discuss

Subject: Finance Exam Prep: Bank Exams , CAT
Job Role: Bank Clerk , Bank PO

1 2306
Q:

Automatic stabilizers refer to

A) government spending and taxes that automatically increase or decrease along with the business cycle. B) changes in the money supply and interest rates that are intended to achieve macroeconomic policy objectives.
C) changes in federal taxes and purchases that are intended to achieve macroeconomic policy objectives. D) the money supply and interest rates that automatically increase or decrease along with the business cycle.
 
Answer & Explanation Answer: A) government spending and taxes that automatically increase or decrease along with the business cycle.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Bank Interview
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

0 2305
Q:

Explain how PL/SQL exceptions are raised.

Answer

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;

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2305
Q:

What are the steps you go through while creating a COBOL program executable?

Answer

DB2 precompiler (if embedded sql used), CICS translator (if CICS program), COBOL compiler, Link editor. If DB2 program, create plan by binding the DBRMs.

Report Error

View answer Workspace Report Error Discuss

0 2304
Q:

What is Aggregate Functions?

Answer

Aggregate functions perform a calculation on a set of values and return a single value. Aggregate functions ignore NULL values except COUNT function. HAVING clause is used, along with GROUP BY, for filtering query using aggregate values.


Following functions are aggregate functions. 


AVG, MIN CHECKSUM_AGG, SUM, COUNT, STDEV, COUNT_BIG, STDEVP, GROUPING, VAR, MAX. VARP

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2303
Q:

What is the difference between a constructor and a method?

Answer

A constructor is a member function of a class that is used to create objects of that class. It has the same name as the class itself, has no return type, and is invoked using the new operator. We cannot invoke a constructor directly.


 


A method is an ordinary member function of a class. It has its own name, a return type (which may be void), and is invoked using the dot operator.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2303