⟩ What is SQL COLLATION?
Collation is a type of sort order. There are mainly three types of sort orders, namely:
i.) Dictionary case sensitive
ii.)Dictionary - case insensitive
iii.)Binary.
Collation is a type of sort order. There are mainly three types of sort orders, namely:
i.) Dictionary case sensitive
ii.)Dictionary - case insensitive
iii.)Binary.
Do you know what are pages and Extents?
Please illustrate physical database architecture?
What is the difference between CUBE operator and ROLLUP operator?
Do you know what are the restrictions applicable while creating views?
Explain what are the restrictions that views have to follow?
Do you know what is RAID and what are different types of RAID configurations?
Can you explain what are the restrictions applicable while creating views?
Explain the truncate command?
Explain the Microsoft SQL Server delete command?
What is Master Database?