Technology Questions

Q:

How would you automatically transfer your visitors to a new web page?

Answer

- You can do it with the help of meta tag mentioned below: 


<META HTTP-EQUIV="Refresh" CONTENT="2"; URL="https://www.yoursite.com"> 


- Place this tag between <HEAD></HEAD> . 


- It will load yousite.com in 2 seconds.

Report Error

View answer Workspace Report Error Discuss

0 1821
Q:

What is the difference between a Windows server operating system and a workstation version?

Answer

The server version of a Windows operating system is designed to provide more optimized networking services over a network. It can manage domains better and it includes more security feature and data backup support. Workstation versions act merely as clients and therefore do not need to have as much resources when compared to the server versions.

Report Error

View answer Workspace Report Error Discuss

0 1821
Q:

How can we read and write operating system files from PL/SQL program?

Answer

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);

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 1821
Q:

What are Cursors? Explain Types of cursors in PL/SQL

Answer

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;

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

1 1819
Q:

How does traffic measured in hosting platform?

Answer

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

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 1818
Q:

What is a package?

Answer

Package is a collection of related classes and interfaces. package declaration should be first statement in a java class.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

1 1818
Q:

What is the difference between method overriding and overloading?

Answer

Overriding is a method with the same name and arguments as in a parent, whereas overloading is the same method name but different arguments

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 1818
Q:

How to assign address to the reference?

Answer

ClassName refName = new ClassName();


or


ClassName refName;


refName = new ClassName();

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 1818