Sawaal

 Technology Questions

Popular Latest Rated
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 2021
Q:

What is the Dictionary class?

Answer

- The Dictionary class is an abstract class.


- Classes like Hashtable which map keys to values inherit from this class. 


- An object can be looked for if a dictionary and a key is provided.


- Any non-null object can be used as a key and as a value.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

1 2021
Q:

What are the built-ins used for finding Object ID function?

Answer

FIND_GROUP(function) FIND_COLUMN(function)

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

2 2019
Q:

Whats a struct?

Answer

A struct is a special C data type that encapsulates other pieces of data into a single cohesive unit. Like an object, but built into C.

Report Error

View answer Workspace Report Error Discuss

Subject: Application Development

0 2016
Q:

What is website?

Answer

Basically website is an information provider, It provides information globally using internet protocols.


 

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 2015
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

Subject: Application Development

0 2014
Q:

What are the the different ways for creating a thread?

Answer

A thread can be created by subclassing Thread, or by implementing the Runnable interface.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2013
Q:

What are the different objects used in JavaScripts?

Answer

JavaScripts uses a hierarchical structure that applies to the objects in a document. There are some objects that show the relationship of one object to another using the language.

Window object: This is the topmost object in the hierarchy. It represent the content area of browser window that consists of HTML documents. Each frame is also a window that has some actions inside it.

 Document object: This object gets loaded in a window and consists of objects of different kind in the model. It consists of the content that will be written in the script.

 Form object: Form objects are used for more interaction with the users. It represents the form elements inside <FORM>...</FORM> tag.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 2011