Interview Questions

Web portal is a business gateway, It organizes business operations.

Ex: Online shopping portals, Job portals etc...

Describe your ideal job?

You should use this question to relate to the post you applied and give them the feel that this is close to your ideal job. So align your wonderful ideal job reasons to the responsibilities of the job posting. 

This is a question that you can use to add some humor or do a icebreaker like just joking that your ideal job is to work in a space station or would like to work in Hollywood but after a quick laugh give a realistic answer like my ideal job is where i get more responsibilities, enhance my skills and grow, and of-course you can add saying you would like to be part of a team where work is fun. If you want to go further, You might add at the end you heard good things about the work environment in the interviewing company.

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

- 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

Number, String, Boolean, Function, Object, Null, Undefined.

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.