Interview Questions

Q:

Explain how garbage collection deals with circular references?

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 2004
Q:

Which of the following modifiers can be used with Local inner class?

A) Final or Abstract B) Final or Transcient
C) Abstract or Transcient D) Final or public
 
Answer & Explanation Answer: A) Final or Abstract

Explanation:

It can either be Final or Abstract

Report Error

View Answer Report Error Discuss

Filed Under: Java

0 2600
Q:

What are the rules to use the ROWGUIDCOL property to define a globally unique identifier column?

Answer

Only one column can exist per table that is attached with ROWGUIDCOL property. One can then use $ROWGUID instead of column name in select list.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2653
Q:

A lock can be acquired on a class.

The above statement is

A) True B) False
C) Both A and B D) None
 
Answer & Explanation Answer: A) True

Explanation:

A lock can be acquired on a class. This lock is acquired on the class's Class object.

Report Error

View Answer Report Error Discuss

Filed Under: Java

0 12285
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 2090
Q:

What is a linked server in SQL server?

Answer

It enables SQL server to address diverse data sources like OLE DB similarly. It allows Remote server access and has the ability to issue distributed queries, updates, commands and transactions.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2865
Q:

Which of the following type of data member can be shared by all instances of its class?

A) Public B) Inherited
C) Static D) None
 
Answer & Explanation Answer: C) Static

Explanation:

Static members are shared by all the instances of the class

Report Error

View Answer Report Error Discuss

Filed Under: C++

2 9763
Q:

Where is the reference stored?

A) stack B) heap
C) queue D) None
 
Answer & Explanation Answer: A) stack

Explanation:

Referencee is stored in stack

Report Error

View Answer Report Error Discuss

Filed Under: C++

1 3494