SQL:
1).Find top second salary?
2).How many types joins in sql server?
3).Difference between full and cross join?
4).Explain constraints.(Check constraints)
5).Difference between where clause and having clause?
6).Difference between subquires and correlated queries,
describes it with one example.
7).How can we use "top" keyword in 2005?
T-SQL:
8).Why introducing T-SQL in sql server?
9).Difference between procedures and functions.
10).Explain triggers.
11).Explain indexes.
12).How to avoid duplicate records?
INTERVIEW(2):
1).Identity property.
2).How can we manually insert data for identity property?
3).How to store data in sql server,take one example and describe?
4).Least top two salaries?
5).How many clustered indexes on a particular table?
6).How to connect the sql server to front end application?
7).Heirarity?
INTERVIEW(3):
1).HINT keyword?
2).coalese keyword?
3).How many types of CTEs are in sql server?
INTERVIEW(3):
1).How many types of system databases?
2).What is the purpose of model and msdb?
3).Constraints?
4).What is the purpose of check constraint?
5).Difference between constraints and triggers?
6).Difference between instead and after triggers?
7).What is magic table?
8).What is error handling?
9).User error identity starts with which number?
10).Transactions?
11).try,catch syntaxes?
12).Difference between procedures and functions?
13).Global variables?
14).Types of temporary tables in sql server.Explain all,where they are stored?
15).Difference between tempdb and msdb?
16).Difference between local variables and global variables?
17).What is a job?
18).Difference between jobs and maintenance plans?
19).What is the purpose of @@spid?
20).Difference between varchar and nvarchar?
21).Explain money datatype.
22).In detail about datetime functions.
23).What is the purpose of identity?
24).Difference between save point and commit
25).Give me some system procedures.
26).Cursors in detail.
INTERVIEW(4):
1).Constraints.
2).Procedures
3).Parent child relation.
4).Indexes.
5).How to split records in sql server?
6).Why we use triggers in sql server applications?
7).What the role of clustered index in sql server?
8).Fill factor?(INDEXES)
INTERVIEW(5):
1).Quoted identifier.
2).Set ANSI nulls.
3).Disable triggers.
4).How to restore the db size?
5).Example for cursor.
6).Example for golbal variables.
7).Difference between procedures and function?
8).Sytax for triggers.
9).Add a constraint(pk) to column.
10).Three types of joins.
11).How to create users?
12).Nested procedures?
14).DB size for your project?
15).Backup script,if i give remote path what does?
16).Indexes ?Which index is faster?
INTERVIEW(6):
1.)Update salray from another table.
2.)delete duplicate records.
3.)difference between stored procedures and functions.
4.)Select 2nd maximum salary and end record.
5.)Tell me which transformations you used?
6.)In destination,what is the difference between fast load and normal load?
7.)Which reports you have developed?
8.)Have you write expressions?
9.)Which type of expressions you written?Can you explain?
10.)In drill down report,setting visible mode what happen?
INTERVIEW(7):
1.Table is associating with view,Can we deleting the table what happen?
2.How many columns can we create in a table?
3.How many indexes can we create for a table?
4.One table having one clustered index,i want to create one more clustered index,its happening or not?
5. How merge statement works?
6.New features in 2005 to 2008?
7.I have created one job,i forgot that job name,sql server agent does not work?How can you see the history of the job without sql server agent?
Some important information:
-->max tables per select statement-256
-->max columns per index-16
-->max indexes per table-250(249+1)/in 2008 (999+1)
-->max columns per table-1024
-->max size of row-8060bytes
-->max size per index-900bytes
INTERVIEW(8):
1).What is truncate?
2).Can you rollback on truncate?
3).What are instead of triggers?
4).What is CTE?
5).Can i create view on ordinary clause in select?
6).What is schema binding?
7).What is the order of dropping indexes?
8).One table having 100 records,how to drop my table?
9).What is ndf?
10).When we creating db,what files are created?
11).Types of backups?
12).Can i recover my data?What is recovery models?
13).What is fill factor?Is '0' and '100' are equal or not?
14).What is bulk insert?
15).What is execution plan?
16).What is statistical plan?
17).How to do performance tuning?
18).What is better in table scan and index scan?
19).What is temporary tables?Scope of temporary tables?
20).What is isolation levels?what is highest isolation level?
21).What is dirty read?
22).What is with nolock?when with nolock is used what is isolation level?
23).What is tuning advisor?
24).How to get last identity value?
25).Tell me some tasks in SSIS?What they do?
26).How to execute package in different ways?
27).What is cross apply?
28).What is hash join and merge join?
29).Difference between CTE and temp tables?
30).Difference between left outerjoin and outer apply?
31).How to frop indexes in sql server 2005?
32).What is fill factor ?Difference between '0' and '100'?
33).How to create @tables and #tables?
34).What is actual and estimated execution plans?
35).What is DTA(database tuning advisor)
INTERVIEW(9):
1).What is unique key?
2).Difference between primary key and unique key.
3).What is referential integrity?
4).Difference between truncate and delete?
5).What is transaction?ACID properties?LOCKS?
6).What is execlusive lock?On exclusive lock deadlock can occur/not?
7).Default isolation level?What is it does?
8).Temporary tables?Can we create temporary tables in functions?
9).What is cube and rollup?
10).Exception handling?
11).What is B-Tree structure does?
12).Sql server 2008 features?
13).WHat type of reports you have done?
14).Matrix reports?
15).Subscriptions
16).On grouping columns i can toggled and visibility mode?What happen?
17).In report parameters,can parameter take null values or not ?
18).Page breaks
