Interview Questions

Q:

What is correlated query? Explain its uses.

Answer

In a correlated query, the outer query is related to the inner query. This means one or more columns in the outer query are referenced. It’s used when the outer queries value is being used by inner query. For example, we need to find which employee had more perks in the current month than they did in the previous month. The correlated subquery is executed for each row of perks information in the parent query to first determine what the perks were for each employee in the previous month. This data, in turn, is compared to perks for each employee in the current month, and only those employees whose perks in the current month were greater that their previous month's perks are returned.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2529
Q:

Which input type defines a slider control?

A) type B) source
C) aside D) body
 
Answer & Explanation Answer: A) type

Explanation:

The input type attribute TYPE defines the slider control.

Report Error

View Answer Report Error Discuss

Filed Under: Application Development
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

1 2526
Q:

Define and explain COM?

Answer

COM is the component Object Model is a system whch creates application which are binary form that is language independent , object oriented ,modular and reusable .

Report Error

View answer Workspace Report Error Discuss

0 2524
Q:

Why synchronization?

Answer

When ever two or more threads are sharing same data for updating then unpredicted result will be there in the data.


For Example take a thread is depositing amount in Account Object and another thread is withdrawing amount from the same Account Object.


when ever both threads are executed simultaneously then unexpected result is stored in the balance of the  Account Object. 

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2524
Q:

Client code having direct access to internal data is called

A) Encapsulation B) DataHiding
C) Polymorphism D) DataAbstraction
 
Answer & Explanation Answer: B) DataHiding

Explanation:

Client code must use setters and getters to access internal data in DataHiding

Report Error

View Answer Report Error Discuss

Filed Under: Java

0 2524
Q:

Why is the main() method declared static?

Answer

main() method is called by the JVM even before the instantiation of the class, hence it is declared as static.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2524
Q:

We can modify an existing Company from

A) Company Info > Alter B) Gateway of Tally > Modify Company
C) Company Info > Alter Company D) All of the above
 
Answer & Explanation Answer: A) Company Info > Alter

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: SQL
Job Role: Analyst , Database Administration , IT Trainer

1 2521
Q:

What is the difference between UNION and UNION ALL?

Answer

UNION selects only distinct values whereas UNION ALL selects all values and not just distinct ones

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2521