Interview Questions

AWB stands for Administrator WorkBench. AWB is a tool for controlling, monitoring and maintaining all the processes connected with data staging and processing in the business information whearhousing.

Primary key constraint ensures that the column(s) always has a unique value to identify the record.
Example:
Below, the primary key is created for column id with name prim_id.
create table employee ( id number NOT NULL, Name varchar(200) Constraint prim_id primary key(id) );

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. 

Cursor_Already_Open,  Invalid_Cursor.

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

application.

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

The fixed cost per unit decreases when volume increases is the correct statement regarding fixed costs.

Generally Accepted Accounting Principles (GAAP) are basic accounting principles and guidelines are concepts that govern the field of accounting.

Accounting principles and guidelines include :

* Business Entity Assumption

* Accounting Period

* Historical Cost Concept

* Full Disclosure Principle

* Cost Principle

* Matching Principle

* Materiality

* Monetary Unit Assumption.

Compounding interest means interest accrues on the interest charged and the principal amount each period the interest is charged.

Compound interest is calculated by multiplying the principal amount by one plus the annual interest rate raised to the number of compound periods minus one.The total initial amount of the loan is then subtracted from the resulting value.

The formula for calculating compound interest is:

[P (1 + i)n] – P

= P [(1 + i)n – 1]

(Where P = Principal, i = nominal annual interest rate in percentage terms, and n = number of compounding periods.)

Take a three-year loan of Rs. 10,000 at an interest rate of 5% that compounds annually. What would be the amount of interest? In this case, it would be:

Rs. 10,000 [(1 + 0.05)3] – 1

= 10,000 [1.157625 – 1]

= Rs. 1,576.25.

How it grows ::