Differences between a primary key and a unique key
What are the differences between a primary key and a unique key?
Expert
Both primary and unique keys are defined to make sure unique row.
• Primary key makes a clustered index upon the column by default.
• Unique makes a non-clustered index by default.
• Primary key does not permit NULLs, but unique key permits one NULL only.
What are the new capabilities of SQL server 2008 for persisting BLOB data?
Explain about encryption of whole databases without the requirement for application changes in SQL server 2008.
Define the Notification services.
Explain about the Sequences in SQL?
Explain about Character Functions.
What are Union, Intersect and Minus?
Define the SQL*Plus briefly.
Describe the term sparse filtered index.
What is the difference between BLOB and TEXT?
What is Null value function?
18,76,764
1925722 Asked
3,689
Active Tutors
1414946
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!