Interview Questions

Q:

What are the Advantages of PL/SQL?

Answer

- Because of the block nature, multiple statements are processed at once thereby improving performance. 


- PL/SQL handles exceptions on catching which, action can be taken. 


- PL/SQL is highly portable as it works with all procedural languages and is highly secured because of privileges.


 

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2140
Q:

What is database clusters?

Answer

Group of tables physically stored together because they share common columns and are often used together is called Cluster.

Report Error

View answer Workspace Report Error Discuss

4 2137
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 2136
Q:

Which of the following statements about market segmentation is true?

A) It is a process of identifying and profiling distinct groups of buyers who differ in their needs and wants. B) It is a process of creating an image or identity of the product in the minds of the target market.
C) It is a process of evaluating each segment's attractiveness and selecting one or more to enter. D) It involves changing the identity of a product, relative to the identity of competing products, in the collective minds of the target market.
 
Answer & Explanation Answer: A) It is a process of identifying and profiling distinct groups of buyers who differ in their needs and wants.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Accounts Receivable
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

1 2135
Q:

Why an infocube has maximum of 16 dimensions?

Answer

Because any Database will supports only 16 foreign keys in a database table. 


It depends upon the Database limits provided to define the Foreign key constraint, e.g. in Sql Server 2005, the recommended max limit for foreign keys is 253, but you can define more.

Report Error

View answer Workspace Report Error Discuss

0 2135
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 2133
Q:

What are wrapped classes ?

Answer

Wrapped classes are classes that allow primitive types to be accessed as objects.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2130
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 2129