Technology Questions

In an Interactive Report, user can define maximum 20 secondary lists.

- 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

- SVG is the abbreviation for Scalable Vector Graphics and is recommended by W3C. 

- It is used to define vector-based graphics for the Web

- The graphics are defined in XML format

-An important quality of SVG graphics is that their quality is maintained even when they are zoomed or resized. 

- All the element and attributes of SVG files can be animated

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

Pass By Reference means the passing the address itself rather than passing the value. Passby Value means passing a copy of the value to be passed.

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);

Oracle database comprises of three kinds of files:
- Datafiles
- Redo log files
- Control files