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.
What are defaults? Is there a column to which a default can’t be bound? Read More »
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 is a stored procedure and its advantage? Read More »
What are wild cards used in database for Pattern Matching ?
What are wild cards used in database for Pattern Matching ? Read More »
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
What are the advantages and disadvantages of views in a database? Read More »
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.
What is a materialized view? Read More »
Define Join and explain different type of joins?
Define Join and explain different type of joins? Read More »
What are the different type of normalization?
What are the different type of normalization? Read More »