Accenture Senior Database Administrator Interview Questions and Answers for Experienced

Clustered index determines the physical order of data in a table, while non-clustered index is a separate structure.

• Clustered index sorts and stores the data rows in the table based on their key values.

• Non-clustered index creates a separate structure that contains the key values and a pointer to the data row.

• A table can have only one clustered index, but multiple non-clustered indexes.

• Clustered index is faster for retr...read more

Default fill factor is the percentage of space reserved for future data growth in an index.

• It is set to 0 by default, which means the index will be filled to 100% capacity.

• A fill factor of 80% means that 20% of the index space will be left empty for future growth.

• It can be set at the server, database, or index level.

• It can affect performance and disk space usage.

System databases are the default databases created during SQL Server installation.

• System databases include master, model, msdb, and tempdb.

• Master database stores system-level information.

• Model database is used as a template for new databases.

• Msdb database is used for SQL Server Agent and maintenance plans.

• Tempdb database is used for temporary storage of data.

• System databases cannot be deleted or detached.

• Additional sys...read more

SQL editions are different versions of SQL Server with varying features and capabilities.

• SQL Server Express - free, limited to 10GB database size

• SQL Server Standard - basic features for small to medium businesses

• SQL Server Enterprise - advanced features for large businesses

• SQL Server Developer - full-featured version for development and testing

• SQL Server Web - designed for web applications

• SQL Server Business Intelligen