What are the properties of a transaction? The properties of a transaction are referred to as ACID properties. They are – Atomicity Consistency Isolation Durability
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
SQL Interview Questions – Part-7
What is the difference between HAVING and GROUP BY? The HAVING clause is only used with the SELECT statement and is often used with the
SQL Interview Questions – Part-6
What is SQL Server Agent? What are the components does it have? Jobs can be scheduled and carried out using SQL Server Agent. Here, each
SQL Interview Questions – Part-5
What is an alias in SQL? In SQL Server, aliases can be used to create a temporary name for columns or tables. Column aliases are
SQL Interview Questions – Part-4
What is a JOIN in SQL? A JOIN clause is used to combine rows from two or more tables, based on a related column between
SQL Interview Questions – Part-3
What is a primary key? A primary key is a unique column (or set of columns) in a relational database table that is used to
Big Data & SQL 