Technology Questions

- 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

Intents are created to define an action that we want to perform and the launches the appropriate activity from another application.

Code

        Intent intent = new Intent(Intent.ACTION_SEND);

        intent.putExtra(Intent.EXTRA_EMAIL, recipientArray);

        startActivity(intent);

long lastModified();

we can give this return value to a date object and we can get data to be displayed.

It Return true if the argument is not a number.

Both JavaScript and Jscript are almost similar. JavaScript was developed by Netscape. Microsoft reverse engineered Javascript and called it JScript.

We can use the following method call:

boolean createNewFile();

This method creates a new file on the HD. 

If a file is already existing with the name given in the constructor then this method does not creates file on HD.

If file is successfully created then this method returns true.

If file is already existing on the HD then this method returns false.

This method may throw IOException whenever IO error is generated while creating file on HD.

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

A throw is used to throw an exception manually, where as throws is used in the case of checked exceptions, to tell the compiler that we haven't  handled the exception, so that the exception will be handled by the calling function.