Find jobs | Company-wise jobs
Jobseekers | Employer login
About us Sitemap of www.CareerRide.com Sitemap FAQ related with www.CareerRide.com FAQ Click here to Contact us Contact
       
Submit Resume Free ! | Access Resume Free !
Home Interview Q&A Tutorials .NET Java Soft skills CV GD Work from home IT practice test MBA practice test FAQs in PDF Books Jobs FAQs
Interview questions                                 
SQL Server part 1
SQL Server part 2
SQL Server part 3
SQL Server part 4
SQL Server part 5
SQL Server part 6
SQL Server part 7
SQL Server part 8
SQL Server part 9
SQL Server 2008
Test your SQL Server skills!
Sql Server database maintenance
SQL Server backup
SQL Server cursor
SQL Server replication
Structured query language
SQL Server architecture
SQL Server constraints
SQL Server cursors
Data Mining
Data warehousing
SQL Server DTS
SQL Server functions
SQL Server indexes
SQL Server joins
SQL Server locks
SQL Server Net integration
SQL Server optimization
SQL Server replication
SQL reporting services
SQL service broker
SQL Server stored procedures
SQL Server table
SQL Server transactions
SQL Server transactions Architecture
SQL Server triggers
SQL Server views
SQL Server XML integration
SQL Server DDL
SQL Server DML
SQL Server DCL
SQL Server identifier
SQL Server data integrity
SQL Server accessing data
SQL Server subqueries
SQL Server cube operator
SQL Server insert data
SQL Server distributed queries
SQL Server index tuning
 

SQL Server interview questions    

SQL Server interview questions - Part 4

<<Previous  Next>> Part 1 | Part 2 | Part 3 | Part 4 | part 5 | part 6 | part 7 | part 8 | part 9

By Nishant Kumar

Describe in brief Databases and SQL Server Databases Architecture.

Latest answer: A database is a structured collection of data. Database can be thought as simple data file.............
Read answer

Define Normalization and De- Normalization.

Latest answer: It is the process of organizing data into related table. To normalize database, we divide database into tables............
Read answer

What is transact-SQL? Describe its types?

Latest answer: SQL Server Provides three types of Transact-SQL statements namely DDL, DCL, and DML...........
Read answer

Define database objects.

Latest answer: SQL Server database stores information in a two dimensional objects of rows and columns called table.............
Read answer

Define data, entity, domain and referential integrity.

Latest answer: Data Integrity validates the data before getting stored in the columns of the table. SQL Server supports four type of data integrity............
Read answer

Describe in brief exporting and importing utility?

Latest answer: The Bulk Copy is a command utility that transfer SQL data to or from a data file.
This utility mostly used to transfer huge data to SQL server from other database...........
Read answer

Define Distributed Query and Linked Server?

Latest answer: Distributed Query is a query which can retrieve data from multiple data sources including distributed data...............
Read answer

Define temporary and extended stored procedure.

Latest answer: Temporary Stored Procedure is stored in TempDB database. It is volatile and is deleted once connection gets terminated or server is restarted.............
Read answer

Define Primary and Unique key.

Latest answer: The column or columns of the table whose value uniquely identifies each row in the table is called primary key. You can define column as primary key using primary key constraint while you create table............
Read answer

What is index? Define its types.

Latest answer: Index can be thought as index of the book that is used for fast retrieval of information. Index uses one or more column index keys and pointers to the record to locate record................
Read answer

<<Previous  Next>>  Part 1 | Part 2 | Part 3 | Part 4 | part 5 | part 6 | part 7 | part 8 | part 9

 

Want to be hunted by potential employers? Just submit your key skills!

Popular FAQs

.NET .Net Architecture ADO.NET Java Oracle C#.NET
VB.NET DOT.NET AJAX ASP.NET NET Framework OOPS in .NET
C++ Sql Server Data warehousing EJB MySQL Linux
PHP UML Networking Testing XML  
 
Copyright © 2008 - 2010 CareerRide.com. All rights reserved.