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
- 11781 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
Who is the owner of a schema in ms sql server?
What are security principals used in sql server 2005?
Differentiate between mongodb vs. Sql server?
Can I delete event logs?
How you would rewrite the sql query to return the customerid sorted numerically?
How can I check that whether automatic statistic update is enabled or not?
How to insert and update data into a table with "insert" and "update" statements?
What is auditing in sql server?
What are window functions in sql server?
What does man by sql wildcard characters in sql server?
What is analysis service repository?
How to use copy and concatenate commands in SQL?
How to identify current user in ssrs report?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Explain the properties of subqueries in sql server?
