Technology Questions

The UTL_FILE database package can be used to read and write operating system files. You need to have read /write access rights in that directory before the package can be used.

Example to write file:

Fhandler is a variable of type UTL_FILE.FILE_TYPE

UTL_FILE.PUTF(fHandler, 'Im writing to a file\n');

Example to read file:

UTL_FILE.GET_LINE(fHandler, buf);

Research in Motion, a Canadian company provided a proprietary operating system for BlackBerry.

The operating system provides support for Java MIDP 1.0 and WAP 1.2.

The current version supports Novell Group Wise and Lotus Notes.

Third-party software can be developed using BlackBerry APIs as well, with certain restriction functionality must be signed by RIM digitally, so that it can be associated to a developer account. 

Cursors help you manipulate the information retrieved by select statements. This can be done by assigning a name to the cursor.

Example:

CURSOR emp_cur 

IS 

SELECT emp_number from employee_tbl where employee_name = name_in;

Types of Cursors:

Implicit cursors- These cursors are not declared by the programmer. They are issued when the SQL statement is executed. The open, close and fetching is done by itself.

Example:

UPDATE employee SET salary = salary * 2.1;

Here, an implicit cursor is issued to identify the set of rows in the table which would be affected by the update.

Explicit cursors- These cursors are defined by programmer. They are used in queries that return multiple rows.

Example:

CURSOR emp_cur 

IS 

SELECT emp_number from employee_tbl where employee_name = name_in;

Pseudo elements allow the use of the part of element and not the element itself. They are applied to block level element, which is used for the complete block for which the CSS is being written. This allow the subpart of an element to be styled like paragraphs and headings. For example:

selector:pseudo-element {property:value;}

p: first-line {text-transform: lowercase;}

It adds the style to the first line of the code in the paragraph.

Arrays can store data in a fix allotted space. The use of linked list allows more flexibility because space is dynamically allocated as needed.

String class objects are immutable objects and they represents strings( sequence of characters)

StringBuffer class objects are mutable objects representing strings and they are Thread safe

StringBuild class objects are also mutable objects representing strings and they are not Thread safe

var obj = new Object(); or var obj = {};

- FTP is used to upload the files on the server from the client side where it is installed on the computer of clients. 

- FTP client is checked for the installation of the software and according to that the appropriate directory is uploaded on the hosting server. 

- The hosting server uploads the files that is being created by the user and set the permissions for it so that public can access it. 

- Web hosting uses different directories like HTML that is used as var/www/html that is determined using the FTP client. 

- Initial local directory is being set up using FTP client and it is where the website gets stored. 

- The transfer mode is being determined for the files that need to be transferred either in ASCII or BINARY mode.