Вот встретил на просторах инета ответник на вопросник.
Помогает при устройстве на работу за руб. ежом.

What is normalization ?

Its a process in which database architect destroy a completely working paper based system of the company into some thing complicated for average computer user. As an example a single MS Excel file which was working fine to keep customer information and orders, will be converted it into tables, after the process we can not search with out writing complicated join statements. No more search using Ctrl + F

What is denormalization ?

When the database design becomes too complicated for the guys who designed it, many times it is because fingers are hurting by writing multiple joins and DBA / Developer can't even tell what his own query is suppose to do, then simply one long table is created. The fancy name for "Admitting the mistake (too much normalization)" is called de-normalization.

What is the difference between primary key and unique key ?

They are exactly the same however because of a bug in sqlserver.exe a primary key column generates an error when trying to insert NULL value, hopefully Microsoft will admit it and this bug will be fixed in some future release.

What are user defined data types ?

They are just to make dba feel smart about them self, that he/she can create own data types. There are no real practical use of them other than complicating the database structure.

What are defaults in SQL Server ?

As we all know users are lazy and many times unwilling to do simple job of data entry. To deal with such lazy staff, a default value is defined so data can make some sense.

What is a transactaction ?

It is only used in databases owned by banks, every time a customer deposits or withdraws money it is recorded in tables. These insert statements are called transactions.

What is database isolation in SQL Server?

To keep objects isolated from each other, also do not let the developers know about already existing database objects. This is to prevent deletion of objects by crazy developers fortunatly drop statement require exact name.

What is a table index ?

In SQL Server each table have columns and columns have names, if the column name reflects the type of data inside then it is called index. They help to find information as an example if we are trying to view last name of users it will help to name the column "Last_Name". If it is simply column1 then it will be diffecult to find it.

How indexes makes query run faster in SQL Server ?

Read the previous answer, if you name each column in table, column1, column2, column3 it will be hard to find information. Naming the columns properly helps to find information faster.

How do you decide which columns need indexes ?

Index each column seperately, also create indexes in all possible combination, this way you do not have to worry about missing indexes.

What is query optimization ?

Buying good quality hardware, attending the meetings, presentations by hardware vendors etc.

How do you calculate the performance of a SQL Server ?

By counting the number of phone calls and emails. Only complaining about the slow system are counted.

Define different ways to optimize SELECT statement in SQL Server.

The best way to speed the SELECT statement is not to put too much data in a single table, 100 rows are enough. Have a server with more than one processor and also make sure you have lot of RAM installed.

How do you troubleshoot SQL Server if its running slow?

If buying better hardware does not solve the problem, then try upgrading network. If performance is still poor then get an oracle or stop complaining. If a company was concerned about performance they would have bought oracle in the first place.

What are the new features introduced in latest SQL Server ?

This is a tricky question, lot of companies want free information with out dealing with Microsoft sales team. Just tell them there is nothing worth to mention ! If they have already bought it then appreciate good judgment, very important for office politics.

How do you secure SQL Server ?

Keep it in a locked room, must have more then one lock on the door. Server should NOT be on the network, disable the SQL Server service in windows so no one can access it. Also make sure you have "No trespassing" sign on the door, also stick it on the monitor, the color should be red.

What authentication modes are available in SQL Server ? Which one is better ?

SQL Server authentication modes are USERNAME and PASSWORD. Better ? I guess every one should have atleast username before they should be allowed to access the server.

Explain Create Database Syntax of SQL Server

Lets be honest here as a DBA it is really not an efficent use of your time to write a query when you can use management studio.

How do you restart SQL Server in single user mode ?

Single user means only one person is using the system. Simply kick out every one from the room and restart the windows machine. If system is on network disable all network access.

What is the difference between Delete and Truncate ?

Both removes the data from table, depending on how much time you want to spend, also if you are deleting the data totally based on your guess then i will recommend using delete.

What are temperory tables ?

The tables you delete by the end of the day.

What are global temperory tables ?

The tables you delete on weekends, these tables are created at start of each week and removed on weekend.

What are Stored Procedures in SQL Server ?

They are hidden SQL statements, you can call them by name.

What is this or that _____ ?

At this point you should know that they are not interested in giving you the job, just wasting your time and learning from your knowledge, i will recommend asking them straight.

CAN I GET THE JOB NOW ?

:)

Хорошо жить хорошо!