Technology Questions

Q:

Define cursor attributes: %FOUND, %NOTFOUND, %ROWCOUNT, and %ISOPEN

Answer

- %FOUND


 This is a Boolean variable which evaluates to TRUE if the last row is successfully fetched.


 


- %NOTFOUND


 This is a Boolean variable which evaluates to TRUE if the last row is not successfully fetched. This means there are no more rows to fetch.


 


- %ROWCOUNT


 Returns the number of rows fetched by the cursor.


 


- %ISOPEN


If the cursor is open, it evaluates to TRUE else FALSE.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2773
Q:

How can you avoid callback hells ?

Answer

There are lots of ways to solve the issue of callback hells:


1. Modularization: break callbacks into independent functions
2. Use a control flow library, like async
3. Use generators with Promises
4. Use async/await (note that it is only available in the latest v7 release and not in the LTS version)

Report Error

View answer Workspace Report Error Discuss

Subject: Java
Job Role: Analyst , IT Trainer

3 2769
Q:

What are the rules which should be followed while naming a variable in VB?

Answer

Some of the rules which should be followed while naming a variable in VB are as follows: 


1) Characters should be less than 255.


2) Space between characters should be allowed.


3) A variable should begin with a number.


4) Period may not be permitted.

Report Error

View answer Workspace Report Error Discuss

0 2768
Q:

If the variable $a is equal to 5 and variable $b is equal to character a, what’s the value of $$b?

Answer 100, it’s a reference to existing variable.
Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2767
Q:

What is traffic shaping?

Answer

One of the main causes of congestion is that traffic is often busy. If hosts could be made to transmit at a uniform rate, congestion would be less common. Another open loop method to help manage congestion is forcing the packet to be transmitted at a more predictable rate. This is called traffic shaping.

Report Error

View answer Workspace Report Error Discuss

0 2766
Q:

What documents are used for use cases?

Answer

There are 2 documents: 


FRD (functional requirement document) 


SDD (system design document) which can also be called TRS (Technical requirements specifications) 

Report Error

View answer Workspace Report Error Discuss

0 2762
Q:

What is Thread?

Answer

A Thread is a block of code that can be executed in parallel with another block of code.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2762
Q:

What are the three cost factors involves in cloud data center?

Answer

Cloud data center doesn’t require experts to operate it, but it requires skilled people to see the maintenance, maintain the workloads and to keep the track of the traffic. The labor cost is 6% of the total cost to operate the cloud data center. Power distribution and cooling of the datacenter cost 20% of the total cost. Computing cost is at the end and is the highest as it is where lots of resources and installation has to be done. It costs the maximum left percentage.

Report Error

View answer Workspace Report Error Discuss

Subject: Cloud Computing

1 2761