What are wild cards used in database for Pattern Matching ?
What are wild cards used in database for Pattern Matching ?
Uncategorized
What are the advantages and disadvantages of views in a database?
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 »
What is a materialized view?
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?
Define Join and explain different type of joins?
What are the different type of normalization?
What are the different type of normalization?
What is a Unique Key ?
What is a Unique Key ?
What is a Composite Key ?
What is a Composite Key ?
What is a Composite Primary 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 …
What is a Foreign Key ?
What is a Foreign Key ?
What is a primary key?
A primary key is a column whose values uniquely identify every row in a table. Primary key values can never be reused. If a row is deleted from the table, its primary key may not be assigned to any new rows in the future. To define a field as primary key, following conditions had to …