Can I help you ?
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

SQL Server DBA Interview Questions I

Posted on 2010-09-16 14:52  nico.uuk  阅读(343)  评论(0编辑  收藏  举报


 

1: 假如你有一个全备,然后你在它之后做了一些日志备份,然后又做了一个差异备份,然后又做了一些日志备份,接下又做了一个差异备份,然后又做了一些日志备份,此时Sql server 崩溃,并且发现差异备份文件损坏,但全备和日志备份文件正常,这种情况下能否将数据库还原到当前时间点而不用差异备份?

 2: 假设同样是问题一的情况,但把差异备份换成是全备,即顺序为全备、日志备、全备、日志备、全备、日志备,现在第二、三个全备都损坏,当Sql server 崩溃时,能否将数据库还原到当前时间点而不用差异备份?

3: 有什么方法可以有效的移除SQL Server 2000/2005/2008索引碎片 ?

 

 

1: SQL Server 数据文件最小的存储单元是什么?大小是多少?

2: SQL Server日志文件最小的存储单元是什么?大小是多少?

 3: SQL Server 数据文件最小的存储单元有多哪些类型?


1: 索引重组和索引重建主要区别有哪些?

2: 解释全部日志记录操作和最小日志记录操作是什么?有何区别?


Question 1: Consider a scenario where you issue a full backup.  Then issue some transaction log backups, next a differential backup, followed by more transaction log backups, then another differential and finally some transaction log backups.  If the SQL Server crashes and if all the differential backups are bad, when is the latest point in time you can successfully restore the database?  Can you recover the database to the current point in time without using any of the differential backups?

假如你有一个全备,然后你在它之后做了一些日志备份,然后又做了一个差异备份,然后又做了一些日志备份,接下又做了一个差异备份,然后又做了一些日志备份,此时Sql server 崩溃,并且发现差异备份文件损坏,但全备和日志备份文件正常,这种情况下能否将数据库还原到当前时间点而不用差异备份?

 

Question 2: Assume the same scenario, however instead of issuing differential backups, all three of the differential backups were full backups.  Assume all the full backups are corrupt with the exception of the first full backup.  Can you recover the database to the current point in time in this scenario?

假设同样是问题一的情况,但把差异备份换成是全备,即顺序为全备、日志备、全备、日志备、全备、日志备,现在第二、三个全备都损坏,当Sql server 崩溃时,能否将数据库还原到当前时间点而不用差异备份?

 

Question 3: What methods are available for removing fragmentation of any kind on an index in SQL Server?

有什么方法可以有效的移除SQL Server 2000/2005/2008索引碎片 ?

 

Question 1: What is the fundamental unit of storage in SQL Server data files and what is it’s size?

SQL Server 数据文件最小的存储单元是什么?大小是多少?

Question 2: What is the fundamental unit of storage in SQL Server log files and what is it’s size?

SQL Server日志文件最小的存储单元是什么?大小是多少?

 Question 3: How many different types of pages exist in SQL Server?

SQL Server 数据文件最小的存储单元有多哪些类型?


Question 1: What are the primary differences between an index reorganization and an index rebuild?

索引重组和索引重建主要区别有哪些?

Question 2: Can you explain the differences between a fully-logged and minimally-logged operations?

解释全部日志记录操作和最小日志记录操作是什么?有何区别?