Uncategorized

Define candidate key, alternate key, composite key

A default is a value that will be used by a column, if no value is supplied to that column while inserting data. IDENTITY columns and timestamp columns can’t have defaults bound to them. See CREATE DEFUALT in books online.

One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign key relationships. One-to-Many relationships are implemented by splitting the data into two tables with primary key and foreign key relationships. Many-to-Many relationships are implemented using a junction table with the keys from both the tables forming the

What is a stored procedure and its advantage?

What are wild cards used in database for Pattern Matching ?

Advantages:1. Views doesn’t store data in a physical location.2. View can be use to hide some of the columns from the table3. Views can provide Access Restriction, since data insertion, update and deletion is not possible on the view.Disadvantages:1. When a table is dropped, associated view become irrelevant.2. Since view are created when a query

Materialized views is also a view but are disk based. Materialized views get updated on specific duration, base upon the interval specified in the query definition. We can index materialized view.

Define Join and explain different type of joins?

What are the different type of normalization?

What is a Unique Key ?