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...
SQL Server Interview Questions and Answers Part 8
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 ? ...
Sql Server Interview Questions and Answers Part 7
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...
SQL Server Interview Questions and Answers Part 6
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.)...
Sql Server Interview Questions and Answers Part 5
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...
Sql Server Interview Questions and Answers Part 2
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...
Sql Server Interview Questions and Answers Part 4
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 ? ...
Sql Server Interview Questions and Answers Part 1
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...
Powered by Blogger.