Software Interview Questions
Questions Answers Views Company eMail

What are cursors? Explain different types of cursors?

6 26230

What are the disadvantages of cursors? How can you avoid cursors?

2 9682

Explain the general syntax for a SELECT statements covering all the options.

3 6612

What is a join and explain different types of joins?

2 4616

Can you have a nested transaction?

1 2478

What is an extended stored procedure?

1 4621

Can you instantiate a COM object by using T-SQL?

1 3412

What is the system function to get the current user's user id?

4 6012

What are triggers? How many triggers you can have on a table?

Ramco,

2 7231

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1980

What is a self join? Explain it with an example?

TCS,

16 56552

Given an employee table, how would you find out the second highest salary?

9 11599

What is normalization? Explain different levels of normalization?

CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

8 59769

What is denormalization and when would you go for it?

NBP,

9 36384

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

Flextronics, Hexaware, SQL Star,

1 9154


Un-Answered Questions { Software }

What are advantages of css?

278


Do you know design patterns. List few?

529


List different type of expressions with the example.

544


Why do we need route guards?

405


Is this valid in java ? Can we instantiate interface in java?

538






Which keywords are used to handle exceptions?

515


What is google search console or webmasters tools?

427


What is package name in struts xml?

546


What are the different types of drivers available on Webdriver ?

498


What is the basic difference between bash and dos?

563


How to we can change tomcat default port?

434


What type of records can be kept in a blockchain? Is there any restriction on same?

5


Why to use Drupal?

94


What are the different types of servers available?

510


What are valid operations on pointers?

656