Questions for SQL Server interviews !!

1. There are 14 200 GB disks on the Cabinet. The database size is GB, including log files. How do I set the disk?
2. There are two Server Clusters, node1 and node2. Now we need to install win200 system patches. After the patches are completed, we need to restart. How to install patches does not affect the user's use.
3. There is a database a that is replicated to database B and database c B respectively. Each data update is required to be updated at the same time. Database C can be updated once a day. How can we develop a replication policy!
4. There is an order table with 90 fields, 20 indexes, and 15 composite indexes. Three of them have more than 10 index fields. How can we optimize it?
5. There is a database of GB, which is increased by 50 MB every day to allow users to access the database at any time and create a backup policy.
6. the daily task of managing 50 databases is to check whether database jobs are completed. How do you complete this check?
7. What is the difference between a user-defined function and a stored procedure? Under what circumstances can only a user-defined function be used, and under what circumstances can only a stored procedure be used
8. What are the new features of SQL 2005? What is the difference with Oracle?
9. What are the qualities of DBAs, what are you and what are your shortcomings?

 

 

 

 

 

 

 

1. There are 14 200 GB disks on the Cabinet. The database size is GB, including log files. How do I set the disk?
Raid0 + 1
2. There are two Server Clusters, node1 and node2. Now we need to install win200 system patches. After the patches are completed, we need to restart. How to install patches does not affect the user's use.
Start one instance and then start another instance.
3. There is a database a that is replicated to database B and database c B respectively. Each data update is required to be updated at the same time. Database C can be updated once a day. How can we develop a replication policy!
Transaction replication and snapshot replication
4. There is an order table with 90 fields, 20 indexes, and 15 composite indexes. Three of them have more than 10 index fields. How can we optimize it?
Too many indexes, need to be integrated, 90 fields, as far as possible paradigm
5. There is a database of GB, which is increased by 50 MB every day to allow users to access the database at any time and create a backup policy.
Perform a full backup and then log backup.
6. the daily task of managing 50 databases is to check whether database jobs are completed. How do you complete this check?
A. Mail is sent after the job is run.
B. Write a program to access related tables in MSDB
7. What is the difference between a user-defined function and a stored procedure? Under what circumstances can only a user-defined function be used, and under what circumstances can only a stored procedure be used
Difference: I want the stored procedure to stay in the memory after it is called, And the next call will be faster; the function must have a return value while the stored procedure may not.
8. What are the new features of SQL 2005? What is the difference with Oracle?
Added the new data types varchar (max) and XML; enhanced the sorting function (row_number, rank, ntile, etc.); added the CET function, Table Partitioning, Online indexing, and DDL triggers, security Enhancement.
Of course, there are differences with Oracle, and many aspects are different. You can answer specific questions.
9. What are the qualities of DBAs, what are you and what are your shortcomings?
At least have good psychological quality and strong stress resistance! Strong sense of responsibility, careful, too much...