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 …
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.
Define Join and explain different type of joins?
What are the different type of normalization?
What is a Unique Key ?
What is a Composite Key ?
A Composite primary key is a set of columns whose values uniquely identify every row in a table. What it means is that, table which contains composite primary key will be indexed based on columns specified in the primary key. This key will be referred in Foreign Key tables. For example – if combined effect …