C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Interview   Jobs   Projects   Offshore Development    
Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing | Talk to Us |



My Profile

Gifts

Active Members
TodayLast 7 Days more...







SQL Server



Total 1157 questions found in this category.

Categories:
ASP.NET C# VB.NET .NET Framework 
SQL Server Other 

Another feature coming up in dotnetspider - take an online exam and find out how much you know in .NET. This is different from the MCSD and MCP certification exams, but will definitely help you do well in your MCSD and MCP certification exam.

So, stop searching for brain dumps and C#, VB.NET interview questions. Try our free exams. And we are sure, if you can pass our exams, probably you can easily get through the next C# interview.

Help us build our interview question bank. Please submit C#, VB.NET and ASP.NET Interview questions. You may get a surprise gift from us. Submit Exam Questions ... and get surprise gifts

Don't look for braindumps!! Try our interview questions section before you search for MCSD, MCSE, MCP brain dumps. Our questions section contains thousands of real .net questions.
QuestionCategory
Which of the following aggregate functions returns a row count as an integer?SQL Server
Which types of joins let you retrieve nonmatching data?SQL Server
What is a Index?SQL Server
datetimeSQL Server
track date and time of the last write access SQL Server
What's the maximum number of parameters can a SQL Server 2000 stored procedure haveSQL Server
SELECT CAST(0 AS DATETIME)SQL Server
What's the maximum number of columns can a SQL Server 2000 table haveSQL Server
Which of the following fixed database roles can manage all permissions, object ownerships, roles and role memberships SQL Server
Which of the following is NOT a reserved keyword in SQL Server 2000 and therefore can be used as an object name or as a column name in a table without using delimiters?SQL Server
Which of the following is NOT a valid description of the db_securityadmin fixed database role?SQL Server
Which of the following fixed database roles can add or remove user IDsSQL Server
What is the out put of SELECT DATEADD(DD, 0, DATEDIFF(DD, 0, GETDATE())) statementSQL Server
What will be the result of SELECT STR(6365, 3) StatementSQL Server
which command is used to set a set of Prevelages that can be granted to users or to other roles?SQL Server
which operator is used in character string comparisons with pattern matching?SQL Server
which clause returns only one copy of each set of duplicate rows selected?SQL Server
which clause specifies the conditions that determines the groups included in the query?SQL Server
what is database replication?SQL Server
If we want to store true/false in sql, fetching values to the front end which datatype should we have to use at the best level?SQL Server
With SQL, how can you return the number of records in the "Persons" table?SQL Server
How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?SQL Server
Which SQL keyword is used to sort the result-set?SQL Server
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?SQL Server
Which SQL statement is used to insert new data in a database?SQL Server
Which SQL statement is used to extract data from a database?SQL Server
DBCC stands forSQL Server
You are designing an inventory and shipping database for Contoso,Ltd. You create the logical database design shown below: You must ensure that the referential integrity of the database is maintained. Which three types of constraints should you apply to your designSQL Server
With SQL, how do you select all the columns from a table named "Persons"SQL Server
With SQL, how do you select a column named "FirstName" from a table named "Persons"SQL Server
Which SQL statement is used to insert new data in a database?SQL Server
Which SQL statement is used to delete data from a database?SQL Server
Which SQL statement is used to update data in a database?SQL Server
Which SQL statement is used to extract data from a database?SQL Server
What does SQL stand forSQL Server
SQLSQL Server
UPDATE STATISTICSSQL Server
Odd one out - a transaction must be...SQL Server
Which is not a return value of @@FETCH_STATUS variableSQL Server
@@RowCountSQL Server
Which data type would you use to store up to 2 GB of text data and still be able to query and manipulate it by using standard functions and operators?SQL Server
Difference between view and stored procedure?SQL Server
FunctionSQL Server
Stored Procedure Query PlanSQL Server
Given an employees table as follows: empid name managerid a1 bob NULL b1 jim a1 B2 tom a1 What value will select count(*) from employees return?SQL Server
Given an employees table as follows: empid name managerid a1 bob NULL b1 jim a1 B2 tom a1 What value will select count(managerid) from employees return?SQL Server
Which of the following is not a valid aggregate function?SQL Server
Which clause you can use to restrict groups returned by a grouped query. SQL Server
Which of the following is the correct SQL statement to use to remove rows from a table?SQL Server
RAID stands for? SQL Server


    Next Results  



what is the difference b/w post and postback? Any idea...
Tags:





dotNet Slackers   BizTalk Adaptors    Web Design

web conferencing

Contact Us    Privacy Policy    Terms Of Use