CTPL Interview Questions and Answers

Q1. Tell me about yourself
Add your answer
Q2. Why you want to join this job
Add your answer

Questions on basic of SQL queries and it is easy to solve all the queries

Q1. What is the difference of delete and truncate
Ans. 
Delete removes specific rows while truncate removes all rows from a table
• Delete is a DML command while truncate is a DDL command

• Delete can be rolled back while truncate cannot be rolled back

• Delete is slower than truncate as it logs each row deletion

• Delete can have a WHERE clause to specify which rows to delete while truncate cannot

• Example: DELETE FROM table_name WHERE column_name = value;

• Example: TRUNCATE TABLE table_n
Answered by AI
Add your answer
Q2. What is the DBMS and rdbms
Ans. 
DBMS stands for Database Management System and RDBMS stands for Relational Database Management System.
• DBMS is a software system that allows users to define, create, maintain and control access to databases.

• RDBMS is a type of DBMS that stores data in the form of tables with rows and columns.

• RDBMS uses SQL (Structured Query Language) to manipulate data.

• Examples of popular RDBMS include MySQL, Oracle, and Microsoft SQL Se
Answered by AI
Add your answer

Q1. Badi introduction
Add your answer

Q1. Basic details personal and professional were discussed
Add your answer

GD was conducted with MD and CEO

It was Related to F&A office work

Q1. Salary negotiation and submission of relevant documents
Add your answer