SQL Server architecture

SQL Server architecture - Interview questions

<<Previous  Next>>

What is RAID and what are different types of RAID configurations?

RAID stands for Redundant Array of Independent Disks. RAID defines data storage schemes to divide and replicate data................
Read answer

What are Page Splits?

When there is not enough room on a page for a new row, a Server splits the page..............
Read answer

Describe in brief database architecture

Database architecture describes the design of the database. It explains how the data is stored. The data of the server is stored in databases....................
Read answer

Explain logical database components

The logical components are usually used to connect to the database. Any object that a user can use to access or connect................
Read answer

What are the database objects? Explain them in brief

Database objects such as tables, primary key, and foreign key describe the structure of the content of a database. These objects also represent the properties of a server...............
Read answer

Illustrate physical database architecture in brief

The physical database architecture describes how the database and files are organized in a SQL server..............
Read answer

What are pages and Extents?

A page is a unit of data storage in SQL. The size of a page is 8Kb. A page has a header and a body. Different types of pages are: ..............
Read answer

<<Previous  Next>> Also read List out the difference between CUBE operator and ROLLUP operator Answer - CUBE generates a result set that represents aggregates for all combinations of values in the selected columns....... What are the capabilities of Cursors? Answer - Cursors can support various functionalities that are listed here..... What are the advantages of using Stored Procedures? Answer - Stored procedures provide performance benefits through local storage, precompiling the code, and caching...... What are the differences among batches, stored procedures, and triggers? Answer - A batch is a group of one or more SQL statements. SQL Server compiles the statements...... What are the restrictions applicable while creating views? Answer - Views can be created referencing tables and views only in the current database....... Describe when checkpoints are created in a transaction log. Answer - It is created when CHECKPOINT statement is executed.......   Define Truncate and Delete commands. Answer - Truncate command is used to remove all rows of the column.The removed records are not recorded in the transaction log...... What are the lock types? Answer - Shared Lock allows simultaneous access of record by multiple Select statements. Shared Lock blocks record from updating and will remain in queue waiting while record is accessed for reading...... Describe in brief system database. Answer - Master database is system database. It contains information about server’s configuration. It is a very important database and important to backup Master..... Also read Transferring a View from Oracle 10G XE to an SQL Server 2005 Database Here you will learn how to copy a table on an Oracle 10G XE database to a database on the SQL Server 2005. You will also learn how to install an Oracle 10G XE server and work with its database objects. The answers to following questions will be made available soon. Keep visiting. What are database files and filegroups? What are page splits? Where does SQL server store data? Define Collation.