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
- 11749 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
What methods do you follow to protect from sql injection attack?
What are translations and its use? : sql server analysis services, ssas
write an SQL query to list the employees who joined in the month of January?
How to get @@error and @@rowcount at the same time?
What is the difference between update lock and exclusive lock?
explain the storage models of olap? : Sql server database administration
We need to perform what steps in the following order to work with a cursor?
How do you create an execution plan?
How to call a function from a stored procedure in SQL Server ?
Explain the difference between delete,drop and truncate in SQL Server?
What is multilevel indexing?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is Command line parameters in PLSQL.?
How network traffic be reduced by using the stored procedure?
how to trace the traffic hitting a sql server? : Sql server database administration
