Help needed urgently..please please

[gandhi]

Hi guys good afternoon....annayyalu naku monday interview on sql server developer, mainly on ssis..mamalu job leka 1 year avuthuni , I am getting frustrated ,if any one can help me by taking the interview , i would appreciate the help..please please..... thankyou thankyou thankyou thankyou thankyou thankyou thankyou thankyou

[Company]

_-_ all the best mama...

[psycopk]

all the best...

[nenuinthe]

monna eppudo e post vesinappudu dhuroyodana ani evaro tisukunta ani petti nattu unnaru...may be PM petti try cheyyi..GUD LUCK

[Technikfreak]

!Q Good luck mama

[sweetybrucy]

[quote author=gandhi link=topic=44575.msg406066#msg406066 date=1267213436]
Hi guys good afternoon....annayyalu naku monday interview on sql server developer, mainly on ssis..mamalu job leka 1 year avuthuni , I am getting frustrated ,if any one can help me by taking the interview , i would appreciate the help..please please..... thankyou thankyou thankyou thankyou thankyou thankyou thankyou thankyou
[/quote]
Here are some SQL Server DBA/Developer interview questions
Before you go for the interview, be prepared to explain the database design of one of your latest projects. Don't be surprised if the interviewer asks you to draw ER diagrams.

Well, here are some questions for you. Hope this helps you prepare for your interview. Wish you all the best in your job hunt!

Questions are categorized under the following sections, for your convenience:

Database design (8 questions)
SQL Server architecture (12 questions)
Database administration (13 questions)
Database programming (10 questions)
Database design
What is normalization? Explain different levels of normalization?


What is denormalization and when would you go for it?


How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?

What's the difference between a primary key and a unique key?

What are user defined datatypes and when you should go for them?




What is bit datatype and what's the information that can be stored inside a bit column?

Define candidate key, alternate key, composite key.

What are defaults? Is there a column to which a default can't be bound?


SQL Server architecture
What is a transaction and what are ACID properties?

Explain different isolation levels?

What's the maximum size of a row?

Explain Active/Active and Active/Passive cluster configurations

Explain the architecture of SQL Server

What is lock escalation?


What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

Explain the storage models of OLAP


What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

What are constraints? Explain different types of constraints.

Whar is an index? What are the types of indexes? How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?


Database administration
What is RAID and what are different types of RAID configurations?


What are the steps you will take to improve performance of a poor performing query?

What are the steps you will take, if you are tasked with securing an SQL Server?

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

What is blocking and how would you troubleshoot it?

Explain CREATE DATABASE syntax


How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

What are statistics, under what circumstances they go out of date, how do you update them?

What are the different ways of moving data/databases between servers and databases in SQL Server?

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?


What is database replicaion? What are the different types of replication you can set up in SQL Server?

Database programming
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?


What is the system function to get the current user's user id?
.

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?


There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

What is a self join? Explain it with an example.

[adhinetha]

baa  veedu na frnd  251 622 1283  kishore name 1 st job face to face  intw kotti  5 months  job chesi malla uppudu  trying    you can ask him

[gandhi]

guys thanks alot for ur support..db rocks.... you rock you rock you rock you rock you rock you rock you rock you rock

[gandhi]

[quote author=adhinetha link=topic=44575.msg406154#msg406154 date=1267216179]
baa  veedu na frnd   251 622 1283   kishore name 1 st job face to face  intw kotti  5 months  job chesi malla uppudu  trying    you can ask him
[/quote]
mama vokka sari adagava me friend ni ....interview thesukuntademo nani....please

[gandhi]

[quote author=sweetybrucy link=topic=44575.msg406108#msg406108 date=1267215234]
Here are some SQL Server DBA/Developer interview questions
Before you go for the interview, be prepared to explain the database design of one of your latest projects. Don't be surprised if the interviewer asks you to draw ER diagrams.

Well, here are some questions for you. Hope this helps you prepare for your interview. Wish you all the best in your job hunt!

Questions are categorized under the following sections, for your convenience:

Database design (8 questions)
SQL Server architecture (12 questions)
Database administration (13 questions)
Database programming (10 questions)
Database design
What is normalization? Explain different levels of normalization?


What is denormalization and when would you go for it?


How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?

What's the difference between a primary key and a unique key?

What are user defined datatypes and when you should go for them?




What is bit datatype and what's the information that can be stored inside a bit column?

Define candidate key, alternate key, composite key.

What are defaults? Is there a column to which a default can't be bound?


SQL Server architecture
What is a transaction and what are ACID properties?

Explain different isolation levels?

What's the maximum size of a row?

Explain Active/Active and Active/Passive cluster configurations

Explain the architecture of SQL Server

What is lock escalation?


What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

Explain the storage models of OLAP


What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

What are constraints? Explain different types of constraints.

Whar is an index? What are the types of indexes? How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?


Database administration
What is RAID and what are different types of RAID configurations?


What are the steps you will take to improve performance of a poor performing query?

What are the steps you will take, if you are tasked with securing an SQL Server?

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

What is blocking and how would you troubleshoot it?

Explain CREATE DATABASE syntax


How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

What are statistics, under what circumstances they go out of date, how do you update them?

What are the different ways of moving data/databases between servers and databases in SQL Server?

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?


What is database replicaion? What are the different types of replication you can set up in SQL Server?

Database programming
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?


What is the system function to get the current user's user id?
.

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?


There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

What is a self join? Explain it with an example.
[/quote]
you rock you rock you rock you rock you rock you rock

[BAVA]

[quote author=sweetybrucy link=topic=44575.msg406108#msg406108 date=1267215234]
Here are some SQL Server DBA/Developer interview questions
Before you go for the interview, be prepared to explain the database design of one of your latest projects. Don't be surprised if the interviewer asks you to draw ER diagrams.

Well, here are some questions for you. Hope this helps you prepare for your interview. Wish you all the best in your job hunt!

Questions are categorized under the following sections, for your convenience:

Database design (8 questions)
SQL Server architecture (12 questions)
Database administration (13 questions)
Database programming (10 questions)
Database design
What is normalization? Explain different levels of normalization?


What is denormalization and when would you go for it?


How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?

What's the difference between a primary key and a unique key?

What are user defined datatypes and when you should go for them?




What is bit datatype and what's the information that can be stored inside a bit column?

Define candidate key, alternate key, composite key.

What are defaults? Is there a column to which a default can't be bound?


SQL Server architecture
What is a transaction and what are ACID properties?

Explain different isolation levels?

What's the maximum size of a row?

Explain Active/Active and Active/Passive cluster configurations

Explain the architecture of SQL Server

What is lock escalation?


What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

Explain the storage models of OLAP


What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

What are constraints? Explain different types of constraints.

Whar is an index? What are the types of indexes? How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?


Database administration
What is RAID and what are different types of RAID configurations?


What are the steps you will take to improve performance of a poor performing query?

What are the steps you will take, if you are tasked with securing an SQL Server?

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

What is blocking and how would you troubleshoot it?

Explain CREATE DATABASE syntax


How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

What are statistics, under what circumstances they go out of date, how do you update them?

What are the different ways of moving data/databases between servers and databases in SQL Server?

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?


What is database replicaion? What are the different types of replication you can set up in SQL Server?

Database programming
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?


What is the system function to get the current user's user id?
.

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?


There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

What is a self join? Explain it with an example.
[/quote]

questions "ok",,,,,, mari answers ela,,,,,,,[img]http://img294.imageshack.us/img294/9273/34fe8mx.gif[/img]

[gandhi]

[quote author=ChittiNaidu link=topic=44575.msg406159#msg406159 date=1267216218]
you rock you rock you rock you rock you rock

fone number PM lo pettalsindi......
[/quote]
you rock you rock you rock you rock you rock

[PowerStar007]

[quote author=gandhi link=topic=44575.msg406284#msg406284 date=1267218876]
you rock you rock you rock you rock you rock you rock

[/quote]gud question  @3$% @3$% @3$%

[BAVA]

[quote author=gandhi link=topic=44575.msg406284#msg406284 date=1267218876]
you rock you rock you rock you rock you rock you rock

[/quote] answers dorkithe naku pampu mama....flezzz[img]http://img685.imageshack.us/img685/9620/51560944.gif[/img]

[gandhi]

[quote author=BAVA link=topic=44575.msg406294#msg406294 date=1267219042]
answers dorkithe naku pampu mama....flezzz[img]http://img685.imageshack.us/img685/9620/51560944.gif[/img]
[/quote]
baa nuvvu denipina ..........sql server pinanena...eni rojula nunchi bench lo vunavu baaa