1. Mention the different versions of SQL?
SQL Server7, SQL Server 2000, 2005 and 2008 etc.. are the different versions available in SQL.
2. What are the different types of Indexes available in SQL Server?
The different Indexes available on SQL Server are Clustered Index, Non-Clustered Index, Unique Index, XML Index, Spatial Index and Filtered Index.
3. What is Clustered Index?
In Clustered Index the data pages are arranged based on the clustered index key when a table is created .The leaf level pages are the actual pages on the table. We can create only one clustered index on a single table.
4. What is Non-Clustered Index?
In Non-clustered Index the leaf level pages doesn’t contain actual pages and instead it contains pointers in to the data pages. We can create multiple non-clustered indexes on a single table.
5. What are the different High-availability solutions available in SQL Server?
The different High-availability solutions available in SQL Server are Failover clustering, Log shipping, Database Mirroring and Replication.
6. Mention the default Port Number on which SQL Server listens?
1433 is the default Port Number.
7. How many files a database contains in SQL Server?
There are a maximum of 32,767 files a database contains in SQL Server.
8. Mention the different types of data files in SQL Server?
There are two different types of data files in SQL Server. They are Primary data files and Secondary data files.
9. How many primary and secondary data files exists in a single database of SQL Server?
There can be only one primary data file and multiple secondary data files exists in SQL Server database
10. Mention the different commands used in Data Control Language (DCL)?
GRANT, DENY and REVOKE are the commands used in DCL.
11. What is Fill Factor?
Fill Factor is a setting that is applicable to indexes in SQL Server and it determines how much data is written to an index pages when it is created or rebuilt.
12. What is System Database in SQL Server?
System Databases are the default databases when SQL Server is installed.
13. What are the different system databases in SQL Server?
Master database, TempDB , MSDB and Model database are the different system databases in SQL Server.
14. Mention the different recovery models for a database in SQL Server?
Full, Bulk-Logged and Simple are the three recovery models available in SQL Server database.
15. What is Replication?
Replication helps to publish various database objects and data in to several destinations.
16. Mention the different types of Replication?
Snapshot Replication, Transactional Replication and Merge Replication are the three different types of replications available in SQL Server DBA.
17. What are the main components of Replication?
There are three main components in Replication. They are Publisher, Distributor and Subscriber.
18. Mention different topologies in which Replication can be configured?
Based on the complexity and work load of an application Replication can be configured in any topology. The several instances are
Publisher, Distributor and Subscriber are on the same SQL instance.
Publisher and Distributor are on the same SQL instance and Subscriber is on separate instance.
Publisher, Distributor and Subscriber are on Individual SQL Instances
19. Mention the different Authentication Modes in SQL Server?
SQL Server has two authentication modes namely Windows Authentication and SQL.
20. Mention the different ways of creating a Database in SQL Server?
We can create a Database in SQL Server in many ways using Management studio, Copy Database wizard, Restoring a database backup and T- SQL by creating a database command.
21. Mention the different types of database compressions used in SQL Server 2008?
Row Compression and Page Compression are the types of compressions used in SQL Server 2008.
22. Mention the different types of upgrades that can be performed in SQL Server?
The Different upgrades that can be performed in SQL Server are In place upgrade and Side-by Side Upgrade
23. Mention the operating modes in which database mirroring runs?
High-safety mode and High-performance mode are the two modes in which database mirroring runs
0 comments:
Post a Comment