Home
1.
Is SQL a procedural or nonprocedural language?

SQL is nonprocedural, meaning that the database decides how to execute the SQL statement. The extensions discussed in this hour were procedural.

2.
What is normalization?

Normalization is the process used to ensure that a database is properly designed according to relational database principles.

3.
What is the use of Stored Procedure? when we use it ?

Stored procedures are used to centralize the logic or business rules to abstract the security management and to improve performance.

When we want to process logical operations at the server side instead of the client side, we can use stored procedures.

4.
What is Trigger?

Trigger is like a dynamic stored procedure. A trigger is a group of T-Sql statements that is executed automatically when specified events occur.

5.
Tell me about view and its uses.

Simply to say a view is a stored sql select statement.

The most common use of views is the simplification of data access.