What is Stored Procedure?
What is Views in sql server?
Difference between a User Defined Function and a Stored Procedure
Difference between a primary key and a unique key?
What is a join and explain different types of joins.
Difference between temp table and table variable
Difference between Triggers and Stored Procedures
Difference between UNION ALL Statement and UNION
What is COALESCE / Why do we use COALESCE?
Why we use SET ROWCOUNT in Sql
How many clustered index can have a table
How many types of local tables in SQL SERVER
Difference between DELETE and TRUNCATE
What is Aggregate Functions?
What is Row_Number()?
What are Ranking Functions?
What is NOLOCK?
What is CTE?
What are the Advantages of using CTE?
What is the STUFF function and how does it differ from the
REPLACE function?
What are the difference between clustered and a non-clustered index?
What are the different index configurations a table can have?
Difference between a HAVING CLAUSE and a WHERE CLAUSE?
Difference between SET and SELECT
Provide all the built in string function of SQL SERVER
Difference between char and varchar data types
Define candidate key, alternate key, composite key.
What are constraints? Explain different types of constraints.
What is a self join? Explain it with an example.
How will you convert table row to a column comma separated value
- 4 Answers
- 10385 Views
- ACS, I also Faced
- E-Mail Answers
Answer Posted / aejaz ahmad
Q-Difference between a User Defined Function and a Stored
Procedure
Ans
1:
the store procedure can not be execute with the select
command while function execute
with the select command you can execute the store procedure
with the execute statment
2:
you can not apply the crud operation on the function while
this my be apply on sql
3:
UDFs that return tables can be treated as another rowset.
This can be used in JOINs with other tables.
Q-Difference between a primary key and a unique key?
Ans- Primary Key: A column in a table whose values
uniquely identify the rows in the table.
A primary key value cannot be NULL.
Unique Key: Unique Keys are used to uniquely
identify each row in an Oracle table.
There can be one and only one row for each unique
key value
Q- What is a join and explain different types of joins.
Ans A join combines records from two or more tables in
a relational database.
In the SQL there are two types of joins: "inner"
and "outer". Outer joins are subdivided further into left
outer joins,
right outer joins, and full outer joins.
Inner join
This is the default join method if nothing else is
specified. An inner join essentially finds the intersection
between the two tables.This find and matching all
records from table A and table B.
Left outer join
A left outer join is very different from an inner
join. Instead of limiting results to those in both tables,
it limits results to those in the "left" table (A).
Right outer join
A right outer join is much like a left outer join,
except that the tables are reversed.
Every record from the right side, B, will be
returned.
Full outer join
Full outer joins are the combination of left and
right outer joins.
These joins will show records from both tables, and
fill in NULLs for missing matches on either side.
Q-Difference between temp table and table variable
Ans 1: A temp tablecan have indexws,where as a table
variable can onlyhave a primary index .
2: table variable can be faster than temp table .
3: Need to search the record so, temp table is
batter.
4: Table variables are Transaction neutral. They
are variables and thus aren't bound to a transaction.
Temp tables behave same as normal tables and
are bound by transactions.
Q-Difference between Triggers and Stored Procedures
Ans 1: Triggers are automatically fired ,but Procedure
has to be explicitly fired.
2: Triggers can only be implemented on tables or
views
SP in independent code that can be specific to
database
3: Triggers will get execute automatically when an
update ,insert or delete statement is issued aganist a
table or view
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
You want to implement the many-to-many relationship while designing tables. How would you do it?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
How can you start sql server in different modes?
What is normalization and what are the advantages of it?
Can you please explain the difference between primary keys and foreign keys?
Why can there be only one clustered index and not more than one?
What is default port number for sql server 2000?
Which are ddl commands?
What does it mean if @@cursor_row returns a negative number?
What do you understand by sql server agent?
What are different types of join?
How to set the current database in ms sql server?
How to resolve the orphan use problem? : sql server security
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
What are the steps you will take to improve the performance of a poor performing query?
