Interview Questions

Q:

What is FDM?

Answer

FDM is an analog technique that can be applied when the bandwidth of a link is greater than the combined bandwidths of the signals to be transmitted.

Report Error

View answer Workspace Report Error Discuss

0 1945
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 1945
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 1943
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 1942
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 1942
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:

The chart of accounts is designed to

A) alphabetized the accounts to make reading easier for its financial statement users B) summarize the transactions and determine their ending balances
C) meet the information needs of a company and other financial statement users D) analyse the accounts and organize them in order of dollar amount to simplify the accounting information for users
 
Answer & Explanation Answer: C) meet the information needs of a company and other financial statement users

Explanation:

The chart of accounts is designed to to meet the information needs of a company and other financial statement users.

Report Error

View Answer Report Error Discuss

Filed Under: Accounts Payable
Exam Prep: CAT , Bank Exams
Job Role: Bank PO , Bank Clerk , Analyst

0 1941
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 1941