Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11977 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
Can a table be created inside a trigger?
What are the differences between char and nchar in ms sql server?
How you can change a cross join into an inner join?
What is tcl in sql server?
Describe how to use the linked server?
Will sql server 2005 allow you to reduce the size of a column?
Determine when an index is appropriate?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What are the ways available in sql server to execute sql statements?
What is the command dbcc checkdb used for?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What are relationships and mention different types of relationships in the dbms
What is the use of commit?
What is the difference between getdate and sysdatetime?
How to create dbo table in sql server?
