Data Warehouse Vs Data Lake vs Data Lakehouse What is a Data warehouse? A data warehouse is a type of data management system that[…]
Read moreCategory: Interview Questions
Python : Playing with Linked list
Create linked list and add node at the beginning class node: def __init__(self, p_data): self.data=p_data self.next=None class[…]
Read morePython: Find Whether A String Could be Palindrome or Not
str=”amalaylam” flag=0 for i, c in enumerate(str): print (i,c,ascii(c),str.count(c)) if (str.count(c))%2 != 0: flag=flag+1; if flag>1:[…]
Read moreData Structure and Algorithm Interview Questions With Python
Find whether a string could be palindrome or not? Linked list creation with add node at the beginning Linked list[…]
Read moreSQL Server Tuning – Top 10 high memory consuming Queries
Problem Statement: Script to find top 10 high memory consuming Queries. Solution: SELECT TOP 10 Object_name(qt.objectid) AS ‘SP Name’, Substring(qt.text, ( qs.statement_start_offset / 2 ) + 1, ( ( CASE qs.statement_end_offset WHEN -1 THEN Datalength(qt.text) ELSE qs.statement_end_offset END[…]
Read moreSQL Server -Find Nth Highest Salary
Problem: Find Nth highest salary in Minimal time. Solution: Interviewer often asks to find Nth Highest Salary in an interview. Many solutions are available on[…]
Read moreSQL Server-Interview Questions
RDBMS: What is normalization and what are its pros and cons? What is demoralization and what are its pros and[…]
Read more
