Interview Questions.

Question 1. What Is The Definition For Sql Server 2000?

Answer :

Microsoft SQL Server is a relational model database server produced via Microsoft. Its primary question languages are T-SQL and ANSI SQL.

Question 2. What Is The Maximum Row Of A Size?

Answer :

8060 bytes.

PL/SQL Interview Questions
Question three. How Many Databases Instances Are There In Sql Server 2000?

Answer :

32,767.

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

Answer :

sixteen.

T-SQL Tutorial
Question five. What Are The Default System Databases In Sql Server 2000?

Answer :

The default machine databases in square server 2000 are:

Master
Model
Tempdb
Msdb.
T-SQL Interview Questions
Question 6. How Many Database Files Are There In Sql Server 2000?What Are They?

Answer :

There are 3 database files in square server 2000.
They are: 

Primary report
Secondary report
Log file.
Question 7. What Are The Recovery Models In Sql Server 2000?

Answer :

The recuperation fashions in sq. Server 2000 are:

Simple recovery version
Full healing version
Bulk-Logged healing version.
SQL Server 2008 Tutorial SQL Server 2008 Interview Questions
Question 8. What Is The Command To Change The Recovery Model?

Answer :

Alter database [Database name] set recuperation full
Go.

Question nine. What Is The Sql Server 2000 Version Number?

Answer :

eight.Zero.

SQL Server 2005 Interview Questions
Question 10. Does Sql Server 2000 Clustering Support Load Balancing?

Answer :

SQL Server 2000 clustering does no longer provide load balancing; it presents failover assist. To achieve load balancing, you need software that balances the load between clusters, not among servers inside a cluster.

SQL Database Tutorial
Question 11. Does Sql Server 2000 Full-textual content Search Support Clustering?

Answer :

Yes.

SQL Database Interview Questions
Question 12. Can I Run Multiple Instances Of Sql Server 2000 At The Same Time On One Computer?

Answer :

Yes.

PL/SQL Interview Questions
Question thirteen. What Is A Collation?

Answer :

A collation specifies the bit styles that constitute each individual and the policies by way of which characters are stored and in comparison.

MySQL Tutorial
Question 14. What Are The Different Types Of Replication Are There In Sql Server 2000?

Answer :

Snapshot replication distributes information precisely as it appears at a specific second in time and does now not monitor for updates to the information. Snapshot replication is nice used as a technique for replicating records that modifications on occasion or in which the most up-to-date values (low latency) aren't a demand. When synchronization takes place, the whole picture is generated and despatched to Subscribers.
Transactional replication, an preliminary photo of records is applied at Subscribers, and then when records adjustments are made at the Publisher, the person transactions are captured and propagated to Subscribers.
Merge replication is the procedure of dispensing statistics from Publisher to Subscribers, allowing the Publisher and Subscribers to make updates while connected or disconnected, and then merging the updates between sites whilst they are connected.

Question 15. What Command Do We Use To Rename A Database?

Answer :

sp_renamedb ‘oldname’, ‘newname’.

MySQL Interview Questions
Question sixteen. What Is Logshipping And Its Purpose?

Answer :

In logshipping the transactional log record from one server is routinely updated in backup database on the alternative server and within the case whilst one server fails the opposite server could have the equal DB and we can use this as the DDR (disaster recovery) plan.

DB2 Using SQL Tutorial
Question 17. What Is 'write-beforehand Log' In Sql Server 2000 ?

Answer :

Once information is stores in reminiscence consumer can make modifications to that a log file is generated. This log document is generated in each five mins of transaction is carried out. After this square server writes changes to database with the assist of transaction log files. This is known as Write-beforehand log.

DB2 Using SQL Interview Questions
Question 18. What Is Extent? Types Of Extents?

Answer :

Extent is a collection of eight sequential pages.
There are 2 varieties of extents.

Uniform extent :- Uniform means when quantity is own by way of a single item approach all series of 8 pages preserve with the aid of a unmarried extend is called uniform.
Mixed quantity :- Mixed approach while more than one item is is available in extents is called combined extents.
T-SQL Interview Questions
Question 19. What Is Default Port Number For Sql Server 2000?

Answer :

1433.

Question 20. What Is Sql Server 2000 Work Load Governor?

Answer :

Workload governor limits the overall performance of SQL SERVER Desktop engine (MSDE). Workload governor sits between the customer and the database engine and counts the variety of connections in keeping with database example. If Workload governor unearths that the wide variety of connections exceeds eight connections, it starts stalling the connections and slowing down the database engine.

PHP+MySQL Interview Questions
Question 21. What Is A Transactions?

Answer :

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

Question 22. What Is Lock Escalation?

Answer :

Lock escalation is the procedure of changing a whole lot of low degree locks (like row locks, page locks) into better degree locks (like desk locks).Every lock is a memory structure too many locks might imply, greater memory being occupied by way of locks.

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

Answer :

RAID stands for redundant array of cheaper disks, used to provide fault tolerance to database servers. There are six RAID tiers 0 through five imparting one-of-a-kind levels of overall performance, fault tolerance.

PostgreSQL Interview Questions
Question 24. How To Determine The Service Pack Currently Installed On Sql Server?

Answer :

To decide the service percent that established in your square server ,connect to your server ,execute the command:

Select @@version
Go.
SQL Server 2008 Interview Questions
Question 25. What Is Acid Properties?

Answer :

ACID (an acronym for Atomicity Consistency Isolation Durability) is a concept that Database Professionals normally look for whilst evaluating databases and alertness architectures. For a reliable database all this 4 attributes should be done.

Atomicity is an all-or-none proposition.
Consistency guarantees that a transaction by no means leaves your database in a half-completed state.
Isolation continues transactions separated from each other until they’re finished.
Durability guarantees that the database will keep tune of pending adjustments in any such way that the server can recover from an abnormal termination.
Question 26. Is The Log File Is A Part Of File Group?

Answer :

No, Log report is a by no means a part of file institution.

SQL DBA Interview Questions
Question 27. What Is A File Group?

Answer :

File group is a collection of documents logically grouped collectively.

There are  styles of filegroups:

Primary :- The number one document organization includes the primary data file and any other documents no longer particularly assigned to any other report institution. All pages for the gadget tables are allocated in the number one report organization.
User-defined :- User-described record groups are any record businesses targeted the use of the FILEGROUP key-word in a CREATE DATABASE or ALTER DATABASE declaration.
SQL Server 2005 Interview Questions
Question 28. What Is Check-factor?

Answer :

Check factor writes all grimy pages for the cutting-edge database to disk.

Question 29. What Is Dirty Page?

Answer :

Dirty pages are records pages that have been entered into the buffer cache and modified, but not but written to the disk.

SQL Interview Questions
Question 30. What Is Awe?

Answer :

Address Windowing Extensions API is commonly known as AWE. AWE is used by SQL Server whilst it has to help very huge quantities of physical reminiscence. AWE function is most effective available in SQL Server Enterprise, Standard, and Developer versions with of SQL Server 32 bit version.

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

Answer :

Yes, For a successful installation, comply with these steps:

Log on to the pc using a home windows consumer account that is a part of the local administrator’s user institution.
Close all packages and prevent the services that use ODBC.
Close event viewer and registry editor.
Question 32. What Are The Different Editions Available In Sql Server 2000?

Answer :

SQL Server 2000 is available in seven unique versions. They are:

Enterprise Edition
Standard Edition
Personal Edition
Developer Edition
Microsoft Windows CE version
Enterprise Evaluation Edition
Desktop Engine.
Question 33. How Do I Find Information About The Install Locations For The Various Instances Running On A Computer?

Answer :

You can find out the set up paths from the registry key similar to each example. The following registry key contains the required statistics:

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

SQL Database Interview Questions
Question 34. How Do I Determine How Many Instances Of Sql Server Are Installed On A Computer?

Answer :

The names of all SQL Server times on a pc can be observed from the Installed Instances value which is positioned under the following registry key:

HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server.

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

Answer :

There are  ways to install the Client gear:

Use the Installation Definition display to choose the components to include in this installation of SQL Server 2000. If you pick out Client Tools Only or Connectivity Only, setup proceeds and no extra alternatives are required, except you choose components while installing client tools.
Use the Custom Setup option, and within the Select Components display screen, you may pick out to install individual subcomponents of Client Management Tools.
Question 36. How Do I Perform An Unattended Install Of Sql Server 2000?

Answer :

If you are planning to install equal installations of SQL Server 2000 on numerous computer systems, or if you need to install SQL Server 2000 on computer systems that you cannot administer remotely, you can use the unattended install choice. The most essential thing of an unattended installation is the setup initialization file. The setup initialization document may be acquired in any of the following methods:

The SQL Server 2000 CD incorporates several pattern .Iss documents (Sqlins.Iss, Sqlcli.Iss, Sqlcst.Iss) for the exceptional sorts of installations.
Each time which you carry out an interactive SQL Server 2000 setup, it records all the selections you make and saves them inside the Setup.Iss document discovered within the machine root folder.
You can use the Record Unattended .ISS file option inside the Advanced Options screen to create a totally custom designed Setup.Iss document.
After you have got the .Iss document, you can carry out the unattended deploy with the aid of starting the Setupsql.Exe application with an appropriate parameters.

MySQL Interview Questions
Question 37. When I Run The Sql Server 2000 Setup, It Just Hangs. What Do I Do?

Answer :

In this situation, decrease the Setup window (and other home windows if vital) to peer whether there are any message bins referring to File Copy or File Sharing. You ought to reply to this kind of messages before Setup can proceed.