Interview Questions

- Virtual domain is the domain of the client on which they can run their applications without having to install the server or hardware. 

- The software need not to be installed physically on the server as it can be done using the local repositories and maintaining the domain locally. 

- Using the virtual domain the server storage space is utilized efficiently and the data can be made more secure before publishing it online. 

- Virtual domains are used to represent the personal Internet web address domain name and can be made with your personal one. 

- Virtual domain provides more security in terms of using your own personalized domain and allows the access to the resources that are on web.

Demand is said to be inelastic, when the demand for the good doesn't change much or it is negotiable when the price of the good changed.

The number of rows returned by a select query can be restricted by the LIMIT clause.
Example:
SELECT * from employee
LIMIT 20

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.

- 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.

Setting up the break points:

1.  Go to the line where you need to mark the breakpoint.


2.  Click with mouse on left corner margin of that line.


3.  Another way is to press F9

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 )

- 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