What are the benefit or uses of view?
What are the benefit or uses of view?
What are the benefit or uses of view? Read More »
Uncategorized
What is a view in SQL Server ? How to create one.
What is a view in SQL Server ? How to create one.
What is a view in SQL Server ? How to create one. Read More »
What are the differences between DDL, DML and DCL in SQL?
What are the differences between DDL, DML and DCL in SQL?
What are the differences between DDL, DML and DCL in SQL? Read More »
What is database normalization?
What is database normalization?
What is database normalization? Read More »
What is the difference between primary key and unique constraints?
What is the difference between primary key and unique constraints?
What is the difference between primary key and unique constraints? Read More »
What are super, primary, candidate and foreign keys?
A super key is a set of attributes of a relation schema upon which all attributes of the schema are functionally dependent. No two rows can have the same value of super key attributes. A Candidate key is minimal super key, i.e., no proper subset of Candidate key attributes can be a super key. A
What are super, primary, candidate and foreign keys? Read More »
What is the difference between a “Local Temporary Table” and “Global Temporary Table”?
What is the difference between a “Local Temporary Table” and “Global Temporary Table”?
What is the difference between a “Local Temporary Table” and “Global Temporary Table”? Read More »
What is the difference between “Primary Key” and “Unique Key”?
1. We can have only one Primary Key in a table whereas we can have more than one Unique Key in a table.2. The Primary Key cannot have a NULL value whereas a Unique Key may have only one null value.3. By default, a Primary Key is a Clustered Index whereas by default, a Unique
What is the difference between “Primary Key” and “Unique Key”? Read More »