Interview Questions

Q:

What are Number Functions in SQL?

Answer

- ABS(number)

Returns the absolute positive value of an expression.
Syntax:
ABS(expression)
Example:
SELECT ABS(-1.0), ABS(0.0), ABS(1.0)
Output:
1.0    .0    1.0

- CEIL(number)

Returns the smallest integer greater than, or equal to, the specified numeric expression.
Syntax:
CEILING(expression)
Example:
SELECT CEILING($223.45), CEILING($-223.45), CEILING($0.0)
Output:
224.00    -223.00        0.00

- FLOOR(number)

Returns the largest integer less than, or equal to, the specified numeric expression.
Syntax:
FLOOR(expression)
Example:
SELECT FLOOR($223.45), CEILING($-223.45), CEILING($0.0)
Output:
223.00      -224.00        0.00

- MOD(number, divisor)

Returns the remainder of the division from 2 integer values.
Syntax:
MOD(dividend, divisor)
Example:
SELECT MOD(20,3)
Output:
2

- POWER(number, power)

Returns the exponential value for the numeric expression.
Syntax:
POWER(number, power)
Example:
SELECT POWER(2.0, 3.0)
Output:
8.0

- SIGN(number)

Returns the sign i.e. positive or negative value for the numeric expression. It returns -1 for negative expressions, a value of 0 for zero
Syntax:
SIGN(number)
Example:
SELECT SIGN(4)
Output:
1

- ROUND(number, precision)

Returns the numeric value rounded off to the next value specified.
Syntax:
ROUND(number, number of places)
Example:
SELECT ROUND(1.3456, 2)

- SQRT(number)

Returns the square root value of the expression.
Syntax:
SQRT(number)
Example:
SELECT SQRT(4.0)
Output:
2.0

- TRUNC(number, precision)

Returns a numeric value that truncate to the specific places
Syntax:
TRUNCATE(number,places)
Example:
SELECT TRUNCATE(1.3456, 2)
Output:
1.34

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 1944
Q:

Why interface data is static?

Answer

Interface data is static data why bcoz interface supports multiple inheritance.


if inteface data is non-static then there is chance for replication of the data (bcoz of replication of data ambiguity problem occurs )

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 1943
Q:

What does cache and no cache options mean while creating a sequence?

Answer

The CACHE option means how many sequences will be stored in memory for access by the application objects. The performance is faster. However in case of the database is down the data is memory is lost for the sequence.


The NO CACHE option means values are not stored in memory. So there might be some performance issue. 

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 1942
Q:

Explain how garbage collection deals with circular referrences?

Answer

The .Net runtime knows about all the references between the objects. It can identify all the circular references that are reachable from the root and hence finalize them to free them all at once if and when needed

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 1942
Q:

Which investment type typically carries the least risk?

A) Mutual funds B) Treasury bonds
C) Savings account D) Individual stocks
 
Answer & Explanation Answer: C) Savings account

Explanation:

Different types of risk exist in ivesting schemes depending on what you've invested in.

 

Savings accounts are generally regarded as the least risky investments as in this we just save our wealth for future expenses.

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 1940
Q:

What is IP address?

Answer

The internet address( IP address) is 32bits that uniquely and universally defines a host or router on the internet. The portion of the IP address that identifies the network is called netid. The portion of the IP address that identifies the host or router on the network is called hostid.

Report Error

View answer Workspace Report Error Discuss

0 1940
Q:

What is CSS selector?

Answer

- Basically it is a string that identifies the elements to which a particular declaration or set of declarations will apply. 


- It can also be referred to as a link between the HTML document and the style sheet. 


- It is equivalent of HTML elements.


For example : 


A {text-indent: 12pt}


Here, the selector is A, which is called as type selector.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 1940
Q:

Demand side market failures occur when

A) supply curves do not reflect the full cost of producing a good or services B) demand curves do not reflect consumer’s full willingness to pay for goods or services
C) government imposes tax on a good or a service D) a good or service is not produced because no one demands it
 
Answer & Explanation Answer: B) demand curves do not reflect consumer’s full willingness to pay for goods or services

Explanation:

Market failure arises because it is not possible for the market to correctly weight cost and benefits in a situation in which some of the cost is completely unaccounted.

Demand-side market failures happen when demand curves do not reflect consumer’s full willingness to pay for goods or services.

Supply-side market failures occur when supply curves do not reflect the full cost of producing a good or services.

Report Error

View Answer Report Error Discuss

Filed Under: Marketing and Sales
Exam Prep: Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

1 1939