Technology Questions

- The infinite file error can be solved when the data will be read continuously from the file. 

- The error can be solved by using the keys that provide only the resources that are required. 

- The following program is as follows:

osw.write ("HTTP/1.0 200 OK\n\n"); 

while (c != -1) { 

sb.append((char)c); 

c = fr.read(); 

} 

osw.write (sb.toString()); 

- This converts the requested file in such a way that if the file exists it shows the messages as ok otherwise it shows an error.

- Limited file access is to be given to the file to remove the error from the infinite file type.

- The traffic can be measured using the size of the files that are transferred from one place to another (server-client). 

- It can also be measured by the size of the file that is being requested by the client from the server. 

- The number of visitors arriving on the website also involve in the measurement of the traffic using the web hosting platform. 

- The advertisements of the sites take more bandwidth to allow more number of users to be on the website. 

- More number of users provides higher traffic on the website thus it requires more bandwidth on the web hosting sites.

A record data type represents a data type for that row in a database table. It lets u define your own records and not your own fields.

JavaScript:

- JavaScript is a scripting language developed by Netscape Communications.

- The Netscape Navigator interprets JavaScript embedded into Web pages.

- JavaScript is used for developing web applications.

- It is not dependent on Sun Microsystem's Java language.

JScript:

- Microsoft JScript is an open implementation of Netscape's JavaScript.

- JScript is a scripting language designed to create active online content. ActiveX controls, Java programs, etc can be linked and automated in the web pages using JScript.

Comments are Non Executable statements in program & Explain program logic.

Requirements gathering, functional design and business process, change management etc are very critical tasks for a business analyst.

- A web worker is a JavaScript which runs in the background. It exists in external files. 

 - It is independent of other scripts and does not affect the performance of the page. 

 - Web workers are usually used for CPU intensive tasks.

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;