DataMetica Cloud Analyst Interview Questions and Answers

Sql related questions

Q1. What is sql and plsql
Ans. 
SQL is a standard language for managing databases, while PL/SQL is an extension of SQL used for procedural programming in Oracle databases.
• SQL stands for Structured Query Language and is used for managing and querying databases.

• PL/SQL stands for Procedural Language/SQL and is an extension of SQL used for writing procedural code like loops and conditional statements.

• SQL is a standard language supported by many database ...read more
Answered by AI
Add your answer
Q2. Joins,set operators difference between join am set operators
Ans. 
Joins are used to combine rows from two or more tables based on a related column, while set operators are used to combine the result sets of two or more SELECT statements.
• Joins are used to retrieve data from multiple tables based on a related column

• Set operators are used to combine the result sets of two or more SELECT statements

• Joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Set operators include UNION,
Answered by AI
Add your answer