SQL Server Interview Questions
Questions Answers Views Company eMail

how to give input dynamically to a insert statement in sqlserver

HCL,

3 5566

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,

10 10983

What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

Microsoft,

8 44889




How can your resolve deadlocks?

IBM, Iron Mountain, IMS, NuWare,

4 10901

SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES

Microsoft,

1 3653

i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 3077

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

Microsoft,

7 7039

write query for fourth maximum salary from employee table

Mind Tree, SP Software,

14 14536




What is the difference between temp table and table variable?

Microsoft,

8 20941

what are three different authentications to connect linked servers?

CitiGroup,

1 3279

What is deadlock and how to avoid the deadlocks.

TCS, Wipro,

3 7797

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.

Satyam,

4 4004

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

Techno Solutions,

1 2926

I have a website that allows customers to browse and place orders for certain products. I have 2 tables; Customers and Orders. The Customers table holds the customer records and the Orders table holds the orders placed by the customer. Both tables are tied based on the field Cust_ID. Example of the data is shown below: Cust_ID Cust_Name Cust_ID Product Amount Order_Date 1001 John Tan 1001 P-5211 $120.00 2/13/2006 1002 Michael Wong 1001 K-1428 $88.90 1/11/2006 1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006 1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006 Write a single SQL statement that extracts all purchase records with the following criteria: 1. Customer names starting with “M” only. 2. Orders placed within the current month only. 3. Amount does not exceed $100.00 The list must be sorted by order date with the latest order showing on top.

Techno Solutions,

3 3172

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 2789


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

whats new about truncate in sql server 2008?

1310


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

595


New concepts of sql server 2005 use in your project.

1235


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

781


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1351






In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

809


How much memory that we are using in Logshipping Concept?

704


wat wil hapn if we give the both read and deny read permission to user?

931


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

904


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

676


what is difference between view and Dip.

1206


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

362


Tell about MOM Tool(Microsoft Operator Manager)?

681


what is isolation level at dead lock?

1008


What is RMS migrations?

954