Sqlserver Interview questions

Total available count: 45
Subject - Databases
Subsubject - Sqlserver

What is OLTP (Online Transaction Processing)?

In OLTP - online transaction processing systems relational database design use the discipline of data modeling and generally follow the CODD rules of data normalization in order to ensure absolute data integrity.

Using these rules complex information is broken down into its most simple structures (a table) where all of the individual atomic level elements relate to each other and satisfy the normalization rules.

Next 5 interview question(s)

What are different types of Collation Sensitivity?
What are the different index configurations a table can have?
Which TCP/IP port does SQL Server run on? How can it be changed?
Explain Transact-SQL optimization tips?
What is Foreign key?