Interview Questions.

Q1. What Is A Raid And What Are Different Types Of Raid Configurations?

RAID stands for redundant array of cheaper disks, used to offer fault tolerance to database servers. There are six RAID levels 0 via 5 presenting special ranges of overall performance, fault tolerance.

Q2. What Is Lock Escalation?

Lock escalation is the process of converting loads of low stage locks (like row locks, web page locks) into higher degree locks (like desk locks).Every lock is a reminiscence shape too many locks could imply, extra memory being occupied with the aid of locks.

Q3. Can I Run Multiple Instances Of Sql Server 2000 At The Same Time On One Computer?

Yes.

Q4. What Is Logshipping And Its Purpose?

In logshipping the transactional log document from one server is routinely updated in backup database on the opposite server and in the case while one server fails the other server could have the same DB and we are able to use this because the DDR (catastrophe restoration) plan.

Q5. What Is Dirty Page?

Dirty pages are statistics pages that have been entered into the buffer cache and changed, but not yet written to the disk.

Q6. What Is Check-factor?

Check factor writes all dirty pages for the modern-day database to disk.

Q7. How Many Database Files Are There In Sql Server 2000?What Are They?

There are 3 database documents in square server 2000.

They are: 

Primary record

Secondary file

Log record.

Q8. Is The Log File Is A Part Of File Group?

No, Log document is a by no means a part of record group.

Q9. What Are The Recovery Models In Sql Server 2000?

The restoration models in square server 2000 are:

Simple healing version

Full restoration version

Bulk-Logged restoration version.

Q10. What Is The Definition For Sql Server 2000?

Microsoft SQL Server is a relational version database server produced with the aid of Microsoft. Its number one question languages are T-SQL and ANSI SQL.

Q11. What Is Extent? Types Of Extents?

Extent is a set of eight sequential pages.

There are 2 types of extents.

Uniform volume :- Uniform way while volume is own by way of a single object approach all collection of eight pages keep by means of a single amplify is known as uniform.

Mixed volume :- Mixed way whilst multiple object is is available in extents is referred to as mixed extents.

Q12. What Is The Sql Server 2000 Version Number?

8.Zero.

Q13. What Are The Different Types Of Replication Are There In Sql Server 2000?

Snapshot replication distributes statistics exactly as it seems at a specific second in time and does no longer reveal for updates to the facts. Snapshot replication is fine used as a method for replicating information that modifications every so often or in which the most updated values (low latency) aren't a requirement. When synchronization takes place, the entire picture is generated and despatched to Subscribers.

Transactional replication, an preliminary image of facts is applied at Subscribers, and then whilst records adjustments are made at the Publisher, the individual transactions are captured and propagated to Subscribers.

Merge replication is the technique of dispensing facts from Publisher to Subscribers, allowing the Publisher and Subscribers to make updates whilst connected or disconnected, after which merging the updates between web sites while they are related.

Q14. What Is Default Port Number For Sql Server 2000?

1433.

Q15. What Is A Transactions?

A transaction is a logical unit of work wherein, all the steps have to be accomplished or none.

Q16. What Are The Default System Databases In Sql Server 2000?

The default system databases in square server 2000 are:

Master

Model

Tempdb

Msdb.

Q17. How Do I Find Information About The Install Locations For The Various Instances Running On A Computer?

You can discover the install paths from the registry key corresponding to every example. The following registry key includes the specified facts:

HKEY_LOCAL_MACHINE /Software /Microsoft SQL Server /Instance Name /MSSQLServer /Setup /SQLpath.

Q18. How Do I Install Only The Client Tools Of Sql Server 2000?

There are  methods to install the Client gear:

Use the Installation Definition screen to choose the components to include on this set up of SQL Server 200@If you pick Client Tools Only or Connectivity Only, setup proceeds and no additional selections are required, unless you pick additives when putting in consumer gear.

Use the Custom Setup alternative, and in the Select Components display, you may select to install person subcomponents of Client Management Tools.

Q19. When I Run The Sql Server 2000 Setup, It Just Hangs. What Do I Do?

In this case, limit the Setup window (and other windows if vital) to look whether there are any message containers relating to File Copy or File Sharing. You should respond to this kind of messages earlier than Setup can proceed.

Q20. How Many Instances Per Computer Are There In Sql Server 2000?

16.

Q21. How Do I Perform An Unattended Install Of Sql Server 2000?

If you are planning to put in identical installations of SQL Server 2000 on numerous computer systems, or in case you want to put in SQL Server 2000 on computers which you cannot administer remotely, you could use the unattended installation option. The most essential aspect of an unattended set up is the setup initialization record. The setup initialization report can be received in any of the following approaches:

The SQL Server 2000 CD includes numerous pattern .Iss files (Sqlins.Iss, Sqlcli.Iss, Sqlcst.Iss) for the one-of-a-kind varieties of installations.

Each time which you carry out an interactive SQL Server 2000 setup, it records all of the alternatives you're making and saves them within the Setup.Iss report found within the gadget root folder.

You can use the Record Unattended .ISS file alternative within the Advanced Options display screen to create a very customized Setup.Iss record.

After you've got the .Iss report, you may carry out the unattended deploy via starting the Setupsql.Exe software with the proper parameters.

Q22. What Is The Maximum Row Of A Size?

8060 bytes.

Q23. What Is The Command To Change The Recovery Model?

Alter database [Database name] set recovery full

Go.

Q24. Does Sql Server 2000 Clustering Support Load Balancing?

SQL Server 2000 clustering does no longer provide load balancing; it presents failover help. To attain load balancing, you want software that balances the burden between clusters, not among servers within a cluster.

Q25. Does Sql Server 2000 Full-textual content Search Support Clustering?

Yes.

Q26. What Is A Collation?

A collation specifies the bit patterns that represent every character and the rules through which characters are stored and as compared.

Q27. How Many Databases Instances Are There In Sql Server 2000?

32,767.

Q28. What Is Awe?

Address Windowing Extensions API is commonly known as AWE. AWE is used by SQL Server when it has to assist very large amounts of physical reminiscence. AWE feature is handiest to be had in SQL Server Enterprise, Standard, and Developer versions with of SQL Server 32 bit model.

Q29. What Is Acid Properties?

ACID (an acronym for Atomicity Consistency Isolation Durability) is a idea that Database Professionals commonly look for while comparing databases and application architectures. For a dependable database all this 4 attributes have to be completed.

Atomicity is an all-or-none proposition.

Consistency ensures that a transaction in no way leaves your database in a 1/2-completed nation.

Isolation keeps transactions separated from every different until they’re completed.

Durability ensures that the database will keep song of pending modifications in this kind of manner that the server can get over an atypical termination.

Q30. What Is A File Group?

File institution is a group of files logically grouped collectively.

There are two sorts of filegroups:

Primary :- The primary document group incorporates the number one statistics record and another documents not particularly assigned to some other record group. All pages for the device tables are allocated within the number one report institution.

User-described :- User-described record groups are any file agencies special the use of the FILEGROUP keyword in a CREATE DATABASE or ALTER DATABASE announcement.

Q31. How Do I Determine How Many Instances Of Sql Server Are Installed On A Computer?

The names of all SQL Server instances on a pc may be found from the Installed Instances fee which is positioned under the following registry key:

HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server.

Q32. What Is 'write-ahead Log' In Sql Server 2000 ?

Once records is shops in memory user can make modifications to that a log report is generated. This log record is generated in each five mins of transaction is done. After this square server writes adjustments to database with the help of transaction log documents. This is called Write-in advance log.

Q33. How To Determine The Service Pack Currently Installed On Sql Server?

To determine the service p.C. That established to your square server ,connect with your server ,execute the command:

  Select @@model  Go.

Q34. What Command Do We Use To Rename A Database?

Sp_renamedb ‘oldname’, ‘newname’.

Q35. What Are The Different Editions Available In Sql Server 2000?

SQL Server 2000 is to be had in seven specific variants. They are:

Enterprise Edition

Standard Edition

Personal Edition

Developer Edition

Microsoft Windows CE edition

Enterprise Evaluation Edition

Desktop Engine.

Q36. Are There Any Preferred Steps That Need To Be Taken Care Of Before Starting The Installation Of Sql Server 2000?

Yes, For a a success set up, follow those steps:

Log on to the laptop the usage of a home windows person account which is a part of the neighborhood administrator’s consumer group.

Close all programs and forestall the services that use ODBC.

Close event viewer and registry editor.

Q37. What Is Sql Server 2000 Work Load Governor?

Workload governor limits the performance of SQL SERVER Desktop engine (MSDE). Workload governor sits among the patron and the database engine and counts the quantity of connections in line with database instance. If Workload governor reveals that the variety of connections exceeds 8 connections, it begins stalling the connections and slowing down the database engine.