SQL Server DB Administrator Questions And Answers

81⟩ What is the maximum size of a row?

8060 bytes. Don't be surprised with questions like 'what is the maximum number of columns per table'. 1024 columns per table. Check out SQL Server books online for the page titled: "Maximum Capacity Specifications". Explain Active/Active and Active/Passive cluster configurations Hopefully you have experience setting up cluster servers. But if you don't, at least be familiar with the way clustering works and the two clusterning configurations Active/Active and Active/Passive. SQL Server books online has enough information on this topic and there is a good white paper available on Microsoft site. Explain the architecture of SQL Server This is a very important question and you better be able to answer it if consider yourself a DBA. SQL Server books online is the best place to read about SQL Server architecture. Read up the chapter dedicated to SQL Server Architecture.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

212 views

82⟩ What are isolation levels?

An isolation level determines the degree of isolation of data between concurrent transactions. The default SQL Server isolation level is Read Committed. Here are the other isolation levels (in the ascending order of isolation): Read Uncommitted, Read Committed, Repeatable Read, Serializable. See SQL Server books online for an explanation of the isolation levels. Be sure to read about SET TRANSACTION ISOLATION LEVEL, which lets you customize the isolation level at the connection level.

CREATE INDEX myIndex ON myTable(myColumn)

Is this answer helpful? 0 Yes | 0 No

Answer This Question

182 views

83⟩ What's the maximum size of a row?

8060 bytes.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

211 views

84⟩ Is SQL Server implemented as a service or an application?

It is implemented as a service on Windows NT server and workstation and as an application on Windows 95/98.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

184 views

SQL Server DB Administrator

Home MS SQL Server SQL Server DB Administrator

84 SQL Server DB Administrator Questions And Answers

81⟩ What is the maximum size of a row?

82⟩ What are isolation levels?

83⟩ What's the maximum size of a row?

84⟩ Is SQL Server implemented as a service or an application?

Quick Links:

SQL Server DB Administrator

Home MS SQL Server SQL Server DB Administrator

84 SQL Server DB Administrator Questions And Answers

81⟩ What is the maximum size of a row?

82⟩ What are isolation levels?

83⟩ What's the maximum size of a row?

84⟩ Is SQL Server implemented as a service or an application?

BE THE FIRST TO KNOW

Quick Links: