SQL Server Interview Questions and Answers Part 9

By // No comments:
1.) What is Trigger ?                                                                                                                         A trigger is an event that is executed when any condition (statement) is satisfied.  2.) How to prevent' table creation' in database using concept of trigger  ?              Create trigger ddl trigger on database  for Create table as  begin rollback Print...
3

SQL Server Interview Questions and Answers Part 8

By // No comments:
1.) What is view in SQL Server ?                                                                                                A View is a logical or virtual table,which does not exists physically in the database.View is an object which contains 'select' statement.View is consider like as Virtual table. 2.) What are the main purpose to create a view ?                                        ...
3

Sql Server Interview Questions and Answers Part 7

By // No comments:
1.) What are the Joins Concepts in SQL Server ?                                                     Joins are the concepts which are used to get the related data from more than one table in SQL Server.That is basically used to get the more than one related tables data by a single sql command. 2.) What are the types of Joins used in SQL Server ?                                               Inner Join Outer Join Self Join Cross Join 3.) What is Inner Join and why we use it in SQL Server...
3

SQL Server Interview Questions and Answers Part 6

By // No comments:
1.) What is Transaction ?                                                                                                           A Transaction insure that changes will be made or none of changes will be done. 2.) What are the four Properties of Transaction ?                                                              Atomicity Consistency Isolation Durability 3.)...
3

Sql Server Interview Questions and Answers Part 5

By // No comments:
1.) What is Stored procedure in Sql server ?                                                                          Stored Procedure is a set of SQL Statement or PL/SQL Programming which perform a specific task.There is no need to compile stored procedure again and again. 2.) How to create stored procedure in sql server ?                                                              Syntax:- Create...
3

Sql Server Interview Questions and Answers Part 2

By // 4 comments:
1.) How to delete a specific record(a Row) from a table in sql server?                   delete from table_name where column_name =value Ex. delete from student where sid=103 2.) How to add a New Column in your Existing table using sql command ?           alter table table_name add column_name datatype Ex. alter table student add saddress varchar(40) 3.) How to change the size of Existing column in a table ?                                             alter table  table_name  alter column column_name datatype Ex. alter table student alter...
3

Sql Server Interview Questions and Answers Part 4

By // 2 comments:
1.) Where we generally use Identity column Constraints on a table ?                        If any user wants,one column value should  incremented automatically without any  intervention   of users then we generally use this constraints on the column.  2.) How to create a table and add an Identity column on that  table?                     Syntax:-  Identity (<seed> < Incremented >) Example:- create table student(eid int identity(0,1),sname varchar(30), sage int) 3.) How to add Identity  column in Existing table ?        ...
3

Sql Server Interview Questions and Answers Part 1

By // 1 comment:
1.) What is the use of SQL Server Management Studio ?                                                   It is a software which is basically used for store and retrieve the data from the database. 2.) How to create a Database in sql server using command ?                                          Create Database database_name Ex. Create Database School 3.) How to change existing database using command in sql server ?                         Alter Database...
3
Powered by Blogger.