• Sign In
• Register
• AdSense Revenue

• Asheej T K (24)
• Deepika Harida... (13)
• Programmer (10)

• Alwyn (735)
• nishithraj (512)
• Manindra Upadh... (438)

SQL Server

Question	Category
What is maximum number of subqueries we can write in query in SQL Server	SQL Server
Which of the above is not a part of SQL SERVER	SQL Server
Which of the following function will return last value inserted into the IDENTITY column of a table	SQL Server
How many NonClustered Indexes be able to Created on a Table?	SQL Server
How many null values will be allowed by unique key per table?	SQL Server
Which index will be created on a table by default using unique key?	SQL Server
Which index will be created on a table by default using primary key?	SQL Server
What's the maximum size of a row?	SQL Server
Can we have nested transaction?	SQL Server
Which function is used to get the current user's user id?	SQL Server
Which query we can use to retrieve all the tables in a database?	SQL Server
What happens when we use update or delete sql command without where clause on a table?	SQL Server
What is a self join in SQL Server?	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(*) from employees return?	SQL Server
Which SQL keyword is used to sort the result-set?	SQL Server
Which SQL statement is used to return only different values?	SQL Server
The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true?	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 are different type of Collation Sensitivity ?	SQL Server
What kind of User-Defined Functions can be created?	SQL Server
Which virtual table does a trigger use?	SQL Server
Can SQL Servers linked to other servers like Oracle?	SQL Server
What is the maximum date value that can be stored in a SMALLDATETIME data type?	SQL Server
Which of the following is NOT a valid description of the public role?	SQL Server
What is the best data type to store the birthdays of the Indian Cheife Ministers, starting with Chief Minister's birthday of February 22, 1732?	SQL Server
What's the maximum value can an INT data type hold?	SQL Server
View text definitions are stored in which system table?	SQL Server
What will be the output of the following statement? SET ARITHABORT OFF SET ANSI_WARNINGS OFF SELECT 100/0	SQL Server
What will be the output of the following statement? SELECT STR(6365, 3)	SQL Server
What will be the output of the following statement? SELECT ROUND(123.89, -1)	SQL Server
What will be the output of the following statement? SELECT CAST(-1 AS SMALLDATETIME)	SQL Server
What will be the output of the following statement? SELECT LEN(CAST(LEFT('026-100', 3) AS INT))	SQL Server
How will you throw exception from stored procedure?	SQL Server
There are three types of joins in SQL server: Inner Join, Outer Join, Cross Join	SQL Server
In SQL Server Join puts data from two or more tables into a single result set.	SQL Server
One of the following DLL translate XML to SQL in IIS?	SQL Server
Indexes are following two types of?	SQL Server
ACID stands for?	SQL Server
COUNT function Calculates the number of (non-null) data values in a column?	SQL Server
MAX and MIN functions Calculate the maximum and minimum data value of the column, respectively?	SQL Server
AVG function Calculates the arithmetic mean (average) of the data values contained within a column?	SQL Server
SUM function Calculates the total of all data values in a column?	SQL Server
You can view the nest level in a stored procedure by using the following command:	SQL Server
What is the maximum nested level for stored procedure, function, trigger, or view ?	SQL Server
In SQL Server 2000, the page size is ?	SQL Server
We can Get List of Triggers : select * from Sys.Objects where Type='tr'	SQL Server
Data Definition Language is the subset of SQL commands used to manipulate Oracle Database structures, including tables	SQL Server
Normalization is a technique to avoid duplication in SQL?	SQL Server
XML is newly data type of SQL Server?	SQL Server

Next Results