Sunday, November 29, 2009

SQL Server Database Administrator Interview Questions and Answers Series 6

The DML component of SQL comprises four basic statements
* SELECT to get rows from tables
* UPDATE to update the rows of tables
* DELETE to remove rows from tables
* INSERT to add new rows to tables

What are Checkpoint in SQL Server ?
When we done operation on SQL SERVER that is not committed directly to the database. All operation must be logged in to Transaction Log files after that they should be done on to the main database. Checkpoint are the point which alert Sql Server to save all the data to main database if no check point is there then log files get full we can use Checkpoint command to commit all data in the SQL SERVER. When we stop the SQL Server it will take long time because Checkpoint is also fired


What is Database Partitioning in SQL Server 2005?
SQL Server 2005 provides a new capability for the partitioning of tables across file groups in a database. Partitioning a database improves performance and simplifies maintenance. By splitting a large table into smaller, individual tables, queries accessing only a fraction of the data can run faster because there is less data to scan

Define SQL Server.
SQL server is an RDBMS that uses Transact-SQL to interact with the client application. It includes database, database engine and the application that are used to manage data. Data is organizes into a table with rows and columns.

Define Database.
A database stores data and it is just like a data file. Database systems are more powerful than data files because the data is more highly organized. In a well-designed database, there is no scope for duplicate pieces of data. Related pieces of data are grouped together in a single structure or record.

What is denormalization?
Denormalization is the reverse process of normalization. It is controlled introduction of redundancy to the database design. Database design is denormalised to improve the query performance. It is done to reduce number of complex joins in the query.

How do you implement one-to-one in SQL Server?
One to one is implemented using single table by establishing relationshIP between same type of columns in a table.

How do you implement one-to-many in SQL Server?
Implemented using two tables with primary key and foreign key relationships.

How do you implement many-to-many SQL Server?
Implemented using a junction table.
The keys from both the tables form composite primary key of the junction table.

What are User Defined Datatypes?
It extends base type datatypes functionality. It is create when particular datatype format has to be used across many tables in the database. If a column called EmpId appears in many tables of int type, create EmpId of int and use it across all your tables.

Please check these interview questions as well. 
[SQL Server Database Administrator Interview Questions and Answers - Part #12] 
Tags: sql server interview questions. sql server 2008 interview questions. sql server 2008 interview questions and answers . sql server interview questions and answers for experienced. sql server interview questions and answers for freshers. sql server interview questions and answers. sql server dba interview questions and answers. sql server dba interview questions. sql server database administration interview questions . sql server 2008 database administration interview questions. sql server 2012 interview question and answers. sql server 2012 FAQ. sql server 2012 dba interview. sql dba 2012 interview question and answers. sql server 2008 r2 interview question and answers. sql 2012. sql 2008 r2. sql 200 r2 interview question and answers. sql server question and answers. sql server developer interview question and answers. sql developer interview question and answers.  sql server interview questions. sql server 2008 interview questions. sql server 2008 interview questions and answers. sql server interview questions and answers for experienced. sql server interview questions and answers for freshers. sql server interview questions and answers. sql server dba interview questions and answers. sql server dba interview questions. sql server database administration interview questions. sql server 2012 database administration interview questions. sql server interview questions for entry level. sql server interview questions for experienced.

1 comments:

Post a Comment