| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to Get the last identity value used | | 4 |
| 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 |
| 1.what is the purpose of using alias name in sql server?
with certain example?
2.what is cursor?will u plz explain me in detail with
certain example? | | 3 |
| If there is failure during updation of certain rows, what
will be the state? | | 1 |
| Please give me the SP for the below scenario. I have two
tables named Table1 and Table2...I need to fetch record by
record from Table1 and insert the record in to table2 where
the value in the sno column of the table1 is even number. | Value-Labs | 4 |
| when inserting to a table how many rows will be effected
using triggers
| | 1 |
| what are default? Is there a column to which a default cant be
bound? | | 1 |
| What is WITH CHECK OPTION | Karur-Vysya-Bank-KVB | 2 |
| What is the use of placing primary key and foreign key
constrains on columns. | Value-Labs | 2 |
| In which year relase the 7.0& 2000 & 2005? | | 1 |
| What is lock escalation? | | 1 |
| What is bit datatype and what's the information that can be
stored inside a bit column? | | 1 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | | 1 |
| I have a table in which phno is one of the columns.i do have
some values in tht phno column.i need to update phno column
values with 0(zero) as prefix.give me a correct solution plz... | Value-Labs | 5 |
| 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 |
| What is the difference between 2-Tier architecture and
3-Tier architecture | Oracle | 10 |
| What is the purpose of using COLLATE in a query? | | 1 |
| What types of integrity are enforced by a foreign-key
constraint | | 1 |
| How to count the number of duplicate items in a table? | | 1 |
| how to dispaly a particular row details from a given table | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
