.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 >> .NET Framework >> Post New Question Subscribe to Interview Questions

Does omitting the parenthesis make the syntax cleaner?

Posted By :Faizal     Posted Date :September 09, 2008    Points :10   Category :.NET Framework 
Yes, if "cleaner" to you is fewer characters on the screen. No, if "cleaner" to you is something that appeals to the sense of logic and reason.

You can also find related Interview Question to Does omitting the parenthesis make the syntax cleaner?  below: 

How can we make a thread sleep for infinite period?

  
You can also place a thread into the sleep state for an indeterminate amount of time by calling Thread.Sleep (System.Threading.Timeout.Infinite). To interrupt this sleep you can call the Thread.Interrupt method. (More...)

Does GC make extra overhead?

  
Yes, it is. It is because the Garbage Collector is running on a separate thread at back-end.

A separate thread always makes an extra overhead. That's why the Garbage Collector thread is given the lowest priority. But, when system sees managed heap is full then the Garbage Collector thread will be give REALTIME priority [which is the highest priority in WINDOWS]. (More...)

How to make SharePoint website made available for public?

  
By default all the website created in SharePoint are private,However If you want your site to be a public Web site, enable anonymous access for the entire site. Then you can give out your URL to anybody in your business card, e-mail or any other marketing material. The URL for your Web site will be http://WebsiteName.wss.bcentral.comHence, please take special care to name your site.These Web sites are ideal for information and knowledge intensive sites and/or sites where you need to have shared Web workspace. Remember: Under each parent Web site, you can create up to 10 sub-sites each with unique permissions, settings and security rights. (More...)

How do I make my site non-restricted in Sharepoint?

  
If you want your site to have anonymous access enabled (i.e., you want to treat it like any site on the Internet that does not ask you to provide a user name and password to see the content of the site),
If you want to make your sharepoint website available on Internet and anybody can use it than you can follow below steps:

1) Log-in as an administrator
2) Click on site settings
3) Click on Go to Site Administration
4) Click on Manage anonymous access
5) Choose one of the three conditions on what Anonymous users can access:** Entire Web site** Lists and libraries** Nothing Default condition is nothing; your site has restricted access.
The default conditions allow you to create a secure site for your Web site. (More...)

Select Syntax

  
SELECT "COLUMN_NAME" FROM "TABLE_NAME" (More...)

What is DISTINCT Syntax ?

  
SELECT DISTINCT "COLUMN_NAME" FROM "TABLE_NAME" (More...)

What is a WHARE Syntax?

  
SELECT "COLUMN_NAME" FROM "TABLE_NAME" WHERE "CONDITION"

This condition can be a simple condition and no limit to the number of simple conditions. (More...)

What is COMPOUND CONDITION Syntax?

  
SELECT "COLUMN_NAME" FROM "TABLE_NAME" WHERE "SIMPLE CONDITION" {[AND|OR] "SIMPLE CONDITION"};


Example:
SELECT EMPLOYEE FROM SALARY_TABLE WHERE SALARY > 23000
OR (SALARY < 6000 AND SALARY > 4000) (More...)

What is IN Syntax?

  
SELECT "COLUMN_NAME" FROM "TABLE_NAME" WHERE "COLUMN_NAME" IN ('VALUE1','VALUE2',VALUE3,VALUE4) (More...)

What is MAX Syntax?

  
SELECT MAX("COLUMN_NAME") FROM "TABLE_NAME"; (More...)

What is MIN Syntax?

  
SELECT MIN("COLUMN_NAME") FROM "TABLE_NAME"; (More...)

What is LIKE Syntax?

  
SELECT * FROM "TABLE_NAME" WHERE "COLUMN_NAME" LIKE {PATTERN};


Example:-

SELECT * FROM EMPLOYEE_NAME WHERE EMPLOYEE_NAME LIKE '%SHASHI%'; (More...)

What is ORDER BY Syntax?

  
SELECT "COLUMN_NAME" FROM "TABLE_NAME" [WHERE "CONDITION"] ORDER BY "COLUMN_NAME" [ASC, DESC];


Example:-

SELECT EMPLOYEE_NAME, DESIGNATION, SALARY FROM EMPLOYEE_TABLE ORDER BY DESIGNATION DESC (More...)

What is BETWEEN Syntax?

  
SELECT * FROM "TABLE_NAME" WHERE "COLUMN_NAME" BETWEEN 'VALUE1' AND 'VALUE2';

Example:-

SELECT * FROM EMPLOYEE_TABLE WHERE SALARY BETWEEN '23000' AND '5000'; (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