Interview Questions

Q:

Which utility allows you to reference an assembly in an application?

Answer

An assembly can be referenced by using the gacutil.exe utility with the /r option. The /r option requires a reference type, a reference ID, and a description.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

1 4087
Q:

Write SQL Query to find second highest salary of Employee.

Answer

There are many ways to find second highest salary of Employee in SQL, you can either use SQL Join or Subquery to solve this problem. Here is SQL query using Subquery :


SELECT MAX(Salary) from Employee WHERE Salary NOT IN (select MAX(Salary) FROM Employee );

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

2 4083
Q:

Explain What is Customer Master record?

Answer

A Customer Master Record is a permanent record that contains key information about a business partner or a material. This information must be entered into the system before any transactions can take place involving the business partner [customer] or a material. Entering all the information about a customer or a material into the system before making transactions insures that subsequent transactions or inquiries will have consistent data and reports and analyses can be done in an orderly way. Master Records can be edited or changed when necessary. Changing master records is frequently called "Maintaining" in SAP

Report Error

View answer Workspace Report Error Discuss

1 4081
Q:

What is ‘Amortization’?

Answer

The repayment of the loan by instalment to cover principal amount with interest is known as ‘Amortization’.


 

Report Error

View answer Workspace Report Error Discuss

Subject: Bank Interview

0 4080
Q:

What is WATER MARK in oracle? Explain the significance of High water mark.

Answer

WATER MARK is a divided segment of used and free blocks. Blocks which are below high WATER MARK i.e. used blocks, have at least once contained some data. This data might have been deleted later. Oracle knows that blocks beyond high WATER MARK don’t have data; it only reads blocks up to the high WATER MARK during a full table scan. 

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

4 4080
Q:

What are different file OPEN modes available in COBOL?

Answer

Open for INPUT, OUTPUT, I-O, EXTEND.


1.INPUT : for read only purpose


2.OUTPUT : for write only purpose


3.EXTEND : for appending records


4.I-O : for read and write(using EXTEND) purpose

Report Error

View answer Workspace Report Error Discuss

0 4073
Q:

When will you define a method as static?

Answer When a method needs to be accessed even before the creation of the object of the class then we should declare the method as static.
Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 4062
Q:

How to rebuild Master Database?

Answer

Master database is system database and it contains information about running server's configuration. When SQL Server 2005 is installed it usually creates master, model, msdb, tempdb resource and distribution system database by default. Only Master database is th one which is absolutely must have database. Without Master database SQL Server cannot be started. This is the reason it is extremely important to backup Master database.


To rebuild the Master database, Run Setup.exe, verify, and repair a SQL Server instance, and rebuild the system databases. This procedure is most often used to rebuild the master database for a corrupted installation of SQL Server.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 4055