Technology Questions

There are two major platforms that providing hosting and servers to host on. The differences between them are as follows:

- Unix are more efficient in performing offsite and onsite, whereas windows doesn’t provide very good efficiency to work with. 

- Unix provide lower hosting cost for the website using the high bandwidth, whereas windows take more resources and have the cost higher for the storage. 

- Unix is better for the websites that are static and includes HTML and graphics, whereas Windows is used for heavy websites and having more requirements. 

- Unix supports the scripting languages like PHP and databases like MySQL and other related categories, whereas Windows supports IIS, coldfusion and big applications that take more space.

- 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

- Files can be transferred to the server by using the FTP protocol also known as File Transfer Protocol. 

- FTP is used as a standard network protocol that transfers the file from one computer to another computer using the TCP protocol network.

- This uploads the pages and other documents that are stored in private disk to the public web hosting server. 

- FTP is used on a client server architecture that allows different controls and data connections between the client and the server. 

- FTP uses clear-text sign in protocol that allows the client to use the user name and password for authentication purpose.

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

Benefits for organizations :

The BlackBerry Connect technology allows the organizations for standardizing BlackBerry platform and leverages their existing BlackBerry solution investments. The employees’ productivity and performance can also be boosted by providing them the mobile access for their emails and calendars.

Benefits for IT :

IT departments are provided with a solution that is easy to utilize, manage and deploy by using BlackBerry Connect technology. Strict requirements for security and manageability will be satisfied and several devices can be connected to the BlackBerry Platform. 

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

The common tools that can be used by a business analyst are MS Visio, MS word, MS Excel, Power point, Quality center/test director MS Project. There may be tools that are client specific also, but these will be supplied the client. 

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.