Chargeback Gurus DB2 Database Administrator Interview Questions and Answers

Aptitude test consists of 3 sections Quant , VA and logical
total time was 45 mins

Q1. What are the different types of commands in sql
Ans. 
Different types of commands in SQL include Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), and Transaction Control Language (TCL).
• DDL commands are used to define the structure of database objects such as CREATE, ALTER, DROP.

• DML commands are used to manipulate data in the database such as SELECT, INSERT, UPDATE, DELETE.

• DCL commands are used to control access to data in the ...read more
Answered by AI
Add your answer
Q2. Difference between union and union all
Ans. 
Union combines and removes duplicates, Union All combines without removing duplicates.
• Union combines result sets and removes duplicates

• Union All combines result sets without removing duplicates

• Union is slower than Union All as it involves removing duplicates

• Union All is faster than Union as it does not remove duplicates
Answered by AI
Add your answer