Technology Questions

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

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

Windows object is top level object in Java script. It contains several other objects such as, document, history, location, name, menu bar etc., in itself. Window object is the global object for Java script that is written at client-side.

Information pertaining to the client browser and system is returned by the navigator object of JavaScript. Navigator object is the top level object for all users.

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

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. 

A NSArray’s contents can not be modified once it’s been created whereas a NSMutableArray can be modified as needed, i.e items can be added/removed from it.

Joins are used to combine data of one or more tables. Joins should be used when there is abundant data. Joins can be LEFT, RIGHT, OUTER, INNER or even SELF JOIN. The purpose is to bind data from multiple tables without any receptivity

A unique constraint on a column uniquely identifies the record by a combination of one or more fields. Few unique constraint fields can have a NULL value as long as the combination of values is unique.

Example:
create table employee ( id number NOT NULL, dob DATE, professor_id NOT NULL, Name varchar(200) Constraint id_unique UNIQUE(id,dob) );