| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Accidentally i deleted my table. How can i get that table? | | 4 |
| What is Query Execution Plan? How does it help optimize or
tune a database driven application? | Accenture | 1 |
| 1. What are the grouping function in SQL ?
2. If base table of a view deleted means, what will happen
while we querying on view ? will give any error ?
3. Difference between DROP, DELETE, TRUNCATE table ?
4. What is constraints and types ?
5. What is max size of nchar & nvarchar ?
6. Define ROLLBACK, COMMIT, SAVE POINT
7. How non-clustered better ? or rank the Clustered,
Non-Clustered and Table scan in performance wise
8. Select 10 rows from a table ?
9. Define DML, DDL, DCL, DTL commands ?
10. What is mean by NULL value ? NULL means "" or 0 or
undefined ?
11. Default constraints ?
12. Can we have more then primary Key in table ?
13. Type of integrity ? Entity, Referential, Domain ?
| Perot-Systems | 8 |
| Delete duplicate rows from a table without primary key by
using a single query
Table Employee
empname salary
A 200
B 300
A 200
C 400
D 500
D 500
Output should be
A 200
B 300
C 400
D 500
| | 2 |
| What is ACID Property of Transaction? | | 4 |
| Let’s say the table in the database is named as
TBL_Register. The fields in this table include:
1. User_Name,
2. User_Telephone,
3. Register_Date
The field Register_Date stores the current date and time of
the registration.
Write the SQL statement that inserts the data into the
table. | Techno-Solutions | 2 |
| in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc. | | 7 |
| Which is best Subquery (or) joins in sql server? explain why | | 2 |
| Following are some of the question related to below
mentioned query?
select e1.salary from employee3 e1
where 2=
(
select count(distinct(e2.salary))
from employee3 e2 where e2.salary>=e1.salary
)
1) What the query returns?
2) How it works? - Detail explanation (what the sub query
does, why it is (where 2=)....etc...Please?
| | 3 |
| Hi Friends,
I have a table in which there are thousands of records and
in city field there is NULL value for all records now i want
to change that null value with distinct values in each
record say delhi, bihar, agra, jaipur etc, what will be the
query for that?????
its not possible to update thousands of records one by one.
is there any alternative ...?
Plz help ... its urgent
Thanx in advance | | 1 |
| plz tell me the new features of
sqlserver2000,sqlserver2002,sqlserver2005 | | 3 |
| What is row by row processing ? | | 1 |
| What is the use of MOVE keyword in restore command | IBM | 2 |
| How to get the count of distinct records. Please give me the
query? | Value-Labs | 5 |
| What are the OS services that the SQL Server installation adds? | | 1 |
| what is the maximum size of a row in sql server 2000 and 2005 | | 2 |
| Which system tables contain information on privileges
granted and privileges obtained | | 1 |
| what is bit data type? and what are the information that can
be stored inside a bit column? | | 2 |
| wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records | | 16 |
| how to find number of columns in a table in sql server 2000
and 2005 also | Virtusa | 7 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
