34,876
社区成员
发帖
与我相关
我的任务
分享想做DBA的来自测下......
EASY
--------------------------------------------------------------------------------------------------
Q: What can you do to guarantee any backup is valid?
Q: What is the name of the system database that contains all executable system objects (i.e. system stored procedure code, system view definitions, etc.)
Q: Can you update system tables in Sql Server, and if so, how?
Q: If a database goes down for whatever reason (assume data file is corrupt for example), and the database cannot be brought back online (i.e. you are in a recovery situation), what must be done first to ensure you can retrieve the latest data modifications (assume FULL recovery model)?
Q: What are the 3 recovery models SQL Server exposes?
Q: What 3 basic phases does database recovery go through during recovery, and in what order do they occur?
Q: Consider a scenario where you take a full backup, then some log backups, then a diff backup, some more log backups, then another diff, then some more log backups, then you crash - if all the diff backups are bad, when is the latest you can restore to? i.e. can you recover the database to the current point in time without using any of the diff backups?
FOLLOW-UP Q: Assume the same scenario, however instead of taking diff backups, everywhere that the diff backups were taken were instead FULL backups (so you have 3 full backups) - 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 here?
Q: What options/arguments can be specified in a BACKUP LOG statement to keep inactive log records from being truncated?
Q: What methods are available for removing fragmentation (any kind) on an index in Sql Server?
--------------------------------------------------------------------------------------------------
MODERATE:
--------------------------------------------------------------------------------------------------
Q: Name as many operations as possible that cannot be performed on the model database.
Q: What page verification options are available in Sql Server and how do they work?
Q: What is the fundamental unit of storage in SQL Server data files and what is it’s size?
Q: What is the fundamental unit of storage in SQL Server log files and what is it’s size?
Q: Name as many different types of Pages in SQL Server as possible
Q: Is the sequence of data rows on given data/index page guaranteed to physically match the logical order of rows (i.e. by index key, row id, etc.)?
Q: What is the fundamental unit in which space and allocation is managed within Sql Server and what is it’s size?
Q: What are the primary differences between an index reorganization and an index rebuild?
Q: If you need to REBUILD a non-clustered index that is 10gb in size and have 5gb of free data-file space available with no room to grow the data file(s), how can you accomplish the task?
Q: During an index reorganization operation, if the index spans multiple files, will pages be allowed to migrate between files?
--------------------------------------------------------------------------------------------------
DIFFICULT:
--------------------------------------------------------------------------------------------------
Q: Explain the difference between a fully-logged and minimally-logged operation
Q: What special type of page within Sql Server is responsible for tracking (via a simple bitmap) extents that have been modified by bulk-logged operations since the last "BACKUP LOG" statement?
Q: What special type of page within Sql Server is responsible for tracking (via a simple bitmap) extents that have been modified since the last "BACKUP DATABASE" statement?
Answer:http://www.mssqltips.com/tip.asp?tip1281
--------------------------------------------------------------------------------------------------
Q: What can you do to guarantee any backup is valid?
Q: What is the name of the system database that contains all executable system objects (i.e. system stored procedure code, system view definitions, etc.)
Q: Can you update system tables in Sql Server, and if so, how?
Q: If a database goes down for whatever reason (assume data file is corrupt for example), and the database cannot be brought back online (i.e. you are in a recovery situation), what must be done first to ensure you can retrieve the latest data modifications (assume FULL recovery model)?
Q: What are the 3 recovery models SQL Server exposes?
Q: What 3 basic phases does database recovery go through during recovery, and in what order do they occur?
Q: Consider a scenario where you take a full backup, then some log backups, then a diff backup, some more log backups, then another diff, then some more log backups, then you crash - if all the diff backups are bad, when is the latest you can restore to? i.e. can you recover the database to the current point in time without using any of the diff backups?
FOLLOW-UP Q: Assume the same scenario, however instead of taking diff backups, everywhere that the diff backups were taken were instead FULL backups (so you have 3 full backups) - 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 here?
Q: What options/arguments can be specified in a BACKUP LOG statement to keep inactive log records from being truncated?
Q: What methods are available for removing fragmentation (any kind) on an index in Sql Server?
--------------------------------------------------------------------------------------------------
MODERATE:
--------------------------------------------------------------------------------------------------
Q: Name as many operations as possible that cannot be performed on the model database.
Q: What page verification options are available in Sql Server and how do they work?
Q: What is the fundamental unit of storage in SQL Server data files and what is it’s size?
Q: What is the fundamental unit of storage in SQL Server log files and what is it’s size?
Q: Name as many different types of Pages in SQL Server as possible
Q: Is the sequence of data rows on given data/index page guaranteed to physically match the logical order of rows (i.e. by index key, row id, etc.)?
Q: What is the fundamental unit in which space and allocation is managed within Sql Server and what is it’s size?
Q: What are the primary differences between an index reorganization and an index rebuild?
Q: If you need to REBUILD a non-clustered index that is 10gb in size and have 5gb of free data-file space available with no room to grow the data file(s), how can you accomplish the task?
Q: During an index reorganization operation, if the index spans multiple files, will pages be allowed to migrate between files?
--------------------------------------------------------------------------------------------------
DIFFICULT:
--------------------------------------------------------------------------------------------------
Q: Explain the difference between a fully-logged and minimally-logged operation
Q: What special type of page within Sql Server is responsible for tracking (via a simple bitmap) extents that have been modified by bulk-logged operations since the last "BACKUP LOG" statement?
Q: What special type of page within Sql Server is responsible for tracking (via a simple bitmap) extents that have been modified since the last "BACKUP DATABASE" statement?
Answer:http://www.mssqltips.com/tip.asp?tip1281
...全文
请发表友善的回复…
发表回复
claro 2010-11-20
- 打赏
- 举报
thx
nalnait 2010-11-20
- 打赏
- 举报
whrspsoft3723 2010-11-20
- 打赏
- 举报
作不了dba了
billpu 2010-11-20
- 打赏
- 举报
试着回答看看 不一定对
1 restore hearonly from...
2 model
3 exec sp_configure 'allow updates',1
4 尾日志备份
5 full bulk simple
6 norecovery,standby,recovery
7 太长了...
8 ...不高兴看了
1 restore hearonly from...
2 model
3 exec sp_configure 'allow updates',1
4 尾日志备份
5 full bulk simple
6 norecovery,standby,recovery
7 太长了...
8 ...不高兴看了
soulJava 2010-11-20
- 打赏
- 举报
看不懂！~~
whb147 2010-11-20
- 打赏
- 举报
第一个单词我认识 EASY
专注研发ERP低代码开发平台 2010-11-20
- 打赏
- 举报
不懂...
水族杰纶 2010-11-19
- 打赏
- 举报
[Quote=引用 2 楼 annatrov 的回复:]
不好意思,一句没看懂.我是一名不合格的DBA.
[/Quote]
me2
不好意思,一句没看懂.我是一名不合格的DBA.
[/Quote]
me2
王向飞 2010-11-19
- 打赏
- 举报
我属于菜菜级。
七不语v 2010-11-19
- 打赏
- 举报
不好意思,一句没看懂.我是一名不合格的DBA.
华夏小卒 2010-11-19
- 打赏
- 举报
看不懂
