Interview Questions

Q:

What does cache and no cache options mean while creating a sequence?

Answer

The CACHE option means how many sequences will be stored in memory for access by the application objects. The performance is faster. However in case of the database is down the data is memory is lost for the sequence.


The NO CACHE option means values are not stored in memory. So there might be some performance issue. 

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 1944
Q:

Explain how garbage collection deals with circular referrences?

Answer

The .Net runtime knows about all the references between the objects. It can identify all the circular references that are reachable from the root and hence finalize them to free them all at once if and when needed

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 1944
Q:

How do you decide when to use HashMap and when to use TreeMap ?

Answer

For inserting, deleting, and locating elements in a Map, the HashMap offers the best alternative. If, however, you need to traverse the keys in a sorted order, then TreeMap is your better alternative. Depending upon the size of your collection, it may be faster to add elements to a HashMap, then convert the map to a TreeMap for sorted key traversal.


 

Report Error

View answer Workspace Report Error Discuss

Subject: Java

1 1943
Q:

Classify and explain the functions performed by trade unions.

Answer

The functions performed by trade unions can be classified into two groups: 


i.) Militant Functions


ii.) Fraternal Functions


 


Militant functions :


These activities include strike, lock outs, gherao etc which means putting up a fight with the management. Hence, they are called militant functions. They are carried out for following purposes: 


a.) Rise in wages


b.) Rise in the status of workers


c.) Protection against injustice


 


Fraternal functions :


These functions are carried out by the trade unions for the welfare of their employees which includes: 


a.) Measures to boost up the workers’ morale


b.) Foster self confidence


c.) Develop sincerity and discipline


d.) Protection to women workers against discrimination

Report Error

View answer Workspace Report Error Discuss

Subject: Law

3 1941
Q:

Explain how to limit the rows that are retrieved by a query.

Answer

The number of rows returned by a select query can be restricted by the LIMIT clause.
Example:
SELECT * from employee
LIMIT 20

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 1941
Q:

What is web portal?

Answer

Web portal is a business gateway, It organizes business operations.


Ex: Online shopping portals, Job portals etc...


 

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 1941
Q:

What does a Business Analyst do, what are their responsibilities?

Answer

The most important responsibilities of a business systems analysts are as a communication conduit between the stakeholders and the team 


 

Report Error

View answer Workspace Report Error Discuss

0 1940
Q:

How to get last modified date of a file?

Answer

long lastModified();


we can give this return value to a date object and we can get data to be displayed.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 1940