.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

What operator performs pattern matching?

Posted By :Shashi Ray     Posted Date :October 22, 2008    Points :10   Category :Sql Server 
LIKE operator

You can also find related Interview Question to What operator performs pattern matching?  below: 

What operator performs in pattern matching in SQL Server

  
LIKE operator is used in pattern matching in SQL Server (More...)

What are the wildcards used for pattern matching?

  
"_" for single character substitution and "%" for multi-character substitution (More...)

What are the wildcards used for pattern matching?

  
_ is used for single character substitution
% is used for multi­character substitution (More...)

What does AddressOf operator do in background ?

  
The AddressOf operator creates a delegate object to the BackgroundProcess method. A delegate within VB.NET is a type-safe, object-oriented function pointer. After the thread has been instantiated, you begin the execution of the code by calling the Start() method of the thread. (More...)

What is the use of ?? operator in C#?

  
This operator allows you to assign a value to a nullable type if the retrieved value is in fact null. (More...)

Which design pattern should have private or protected constructor?

  
singleton design pattern should have private or protected constructor (More...)

Which function performs the opposite function of CEILING function in SQL Server?

  
FLOOR function performs the opposite function of CEILING function in SQL Server.

FLOOR rounds up a non integer value to the next least integer while CEILING rounds up the non integer values to the next highest integer. (More...)

You are designing a single person shooter game application. The player can choose between multiple guns.
1) Pistol with 5 bullets
2) Shotgun with 100 bullets
3) Grenade Launcher with 20 grenades

Each gun will have different sound effects and graphics.

Pressing Ctrl+Space should rotate between guns.
Which design pattern should you employ for this?

  
Use Strategy Pattern.

Explanation: Each gun having different performance and graphics.
So this can be accomodated in the algorithm.

Strategy pattern is best suited for shifting the guns/algorithms

There will be a IGun interface implemented by 3 classes
Pistol : IGun
Shotgun : IGun
GrenadeLauncher : IGun (More...)

What is addressof operator?

  
Addressof operator creates a delegate object to a method.

example:

Dim pthread1 as new thread(AddressOf thread1)

Here thread1 is a method. pthread1 is a delegate object. (More...)

What does TOP Operator Do?

  
The TOP operator is used to specify the number of rows to be returned by a query. The TOP operator has new addition in SQL SERVER 2008 that it accepts variables as well as literal values and can be used with INSERT, UPDATE, and DELETES statements. (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

 
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.


Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend