121. How does the DENSE_RANK() function work?
122. What is the NTILE() function?
123. How do you use the LEAD() and LAG() functions?
124. What is the purpose of the PIVOT operator in SQL?
125. How do you use the UNPIVOT operator?
126. What is the purpose of the ROLLUP and CUBE operators?
127. What are the differences between ROLLUP and CUBE?
128. How do you write a SQL query to find the top N records?
129. What is the purpose of the FETCH FIRST clause?
130. How do you use the ROWCOUNT function?
131. What are transactions, and how are they managed in SQL?
132. How do you ensure data consistency in a transaction?
133. What is a deadlock in SQL?
134. How can you avoid deadlocks in SQL?
135. What is the purpose of isolation levels in SQL?
136. What are the different isolation levels in SQL?
137. How does the SERIALIZABLE isolation level work?
138. What is the READ UNCOMMITTED isolation level?
139. What is the purpose of the READ COMMITTED isolation level?
140. How does the REPEATABLE READ isolation level work?
141. What is the purpose of the TRANSACTION statement?
142. How do you manage transactions in a SQL script?
143. What is the role of a database schema?
144. How do you create a schema in SQL?
145. What is the purpose of the SCHEMA keyword?
146. How do you use the USE statement in SQL?
147. What is the purpose of the USE statement?
148. How do you back up a database in SQL?
149. What are the best practices for database backup?
150. How do you restore a database from a backup in SQL?
151. What is the purpose of the BACKUP command?
152. How do you create a user-defined function in SQL?
153. What is the difference between a function and a stored procedure?
154. How do you call a user-defined function in a query?
155. What are system functions in SQL?
156. How do you use built-in functions in SQL?
157. What is the CHARINDEX function used for?
158. How does the LEN() function work?
159. What is the purpose of the SUBSTRING() function?
160. How do you use the REPLACE() function?