Upload Button Icon Add office photos

CTPL

Compare button icon Compare button icon Compare

Filter interviews by

CTPL SQL Database Developer Interview Questions and Answers

Updated 25 Dec 2022

CTPL SQL Database Developer Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Nov 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Assignment 

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

Round 3 - Technical 

(2 Questions)

  • 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
  • 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

Interview Preparation Tips

Interview preparation tips for other job seekers - Do well work hard and things more than more because of the IT sector is very large

Skills evaluated in this interview

Interview questions from similar companies

I appeared for an interview in Nov 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 2 hours
Round difficulty - Medium

In the 1st round 
Aptitude
Reasoning
English
Automata fix( code debug) 
Timing in morning
Environment is good
Interviewer was very cool and interactive

  • Q1. 

    Encode the Message Problem Statement

    Given a text message, your task is to return the Run-length Encoding of the given message.

    Run-length encoding is a fast and simple method of encoding strings, repres...

  • Ans. 

    Implement a function to encode a text message using run-length encoding.

    • Iterate through the message and count consecutive characters

    • Append the character and its count to the encoded message

    • Handle edge cases like single characters or empty message

  • Answered by AI
Round 2 - Video Call 

(1 Question)

Round duration - 30 minutes
Round difficulty - Medium

This is interview round 
Ques from basic electronics
C language

  • Q1. 

    Print Name and Age Problem Statement

    Create a class named Person with a string variable 'name' and an integer variable 'age', such that these variables are not accessible outside the class. Implement a me...

  • Ans. 

    Create a class Person with private variables name and age, and methods to set and get their values.

    • Create a class Person with private variables 'name' and 'age'.

    • Implement a method setValue to set the variables' values.

    • Implement a method getValue to print the variables' values.

    • Ensure the name is a non-empty string and the age is a non-negative integer.

    • Encapsulate the data and provide a clear interface for setting and ge

  • Answered by AI

Interview Preparation Tips

Eligibility criteriaAbove 6 cgpaCognizant interview preparation:Topics to prepare for the interview - Electronics basics, C language , Data structure, OOPS, ProjectsTime required to prepare for the interview - 2 monthsInterview preparation tips for other job seekers

Tip 1 : Do aptitude from indiabix. Go through your basics. At least one language u know. Learn about your branch basics. Know concept of data structure and oops. 
Tip 2 : prepare your final project well. 

Application resume tips for other job seekers

Tip 1 : the skills you know very well mention in resume
Tip 2 : mention project in resume

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview Questionnaire 

2 Questions

  • Q1. Difference between++I and I++
  • Ans. 

    ++I is a pre-increment operator that increments the value of I before using it, while I++ is a post-increment operator that increments the value of I after using it.

    • ++I increments the value of I and then uses the updated value in the expression.

    • I++ uses the current value of I in the expression and then increments it.

    • Both operators can be used with variables, arrays, or pointers.

  • Answered by AI
  • Q2. Local static variable

Skills evaluated in this interview

I applied via Campus Placement and was interviewed in Jan 2021. There was 1 interview round.

Interview Questionnaire 

4 Questions

  • Q1. 1) Introduce yourself
  • Q2. 2) OOPS concepts
  • Q3. 3) About Project
  • Q4. 4) Why cognizant

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview is completely based on basic concepts of c++

I applied via Naukri.com and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Interview Preparation Tips

Interview preparation tips for other job seekers - The types of interviews modes of interviews(vedii phone,zoom,in persons etc.)

I applied via Naukri.com and was interviewed in Jun 2021. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. 1) about oops concepts
  • Q2. Data structures
  • Q3. Design pattern

Interview Preparation Tips

Interview preparation tips for other job seekers - Overall very good experience

I applied via Approached by Company and was interviewed before Jun 2021. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Nornam Java , spring boot questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Read java , spring boot, microservices, cloud pcf , aws

I applied via Campus Placement and was interviewed in Nov 2020. There were 4 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. TELL ABOUT YOURSELF?
  • Q2. WHY COGNIZANT?
  • Q3. PASS IN PYTHON
  • Q4. %APTITUTE QUESTION
  • Q5. WANT TO RELOCATE
  • Ans. 

    Yes, I am open to relocating for the right opportunity.

    • I am willing to consider relocation if the job aligns with my career goals.

    • I am open to exploring new cities and cultures.

    • I am willing to relocate for a better work-life balance or career advancement opportunities.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident, In the aptitude exam try to solve as many drive code to select in genc next, They are more focused on technology and your verbal skills.

I applied via Naukri.com and was interviewed before May 2021. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Java Collection, OOPS, Seralization
Round 2 - Technical 

(1 Question)

  • Q1. Java OOPS, Collection, threading, SQL
Round 3 - HR 

(1 Question)

  • Q1. Nothing specific, Salary Negotiations.

Interview Preparation Tips

Interview preparation tips for other job seekers - overall good experience and process was quick

Interview Questionnaire 

2 Questions

  • Q1. What are the functions using in software?
  • Ans. 

    Functions are blocks of code that perform specific tasks in software.

    • Functions can be used to perform calculations, manipulate data, and control program flow.

    • Examples of functions include print(), sort(), and strlen().

    • Functions can be built-in to programming languages or created by the programmer.

    • Functions can also be organized into libraries or modules for reuse in multiple programs.

  • Answered by AI
  • Q2. How do you create applications in software?
  • Ans. 

    Applications are created by designing, coding, testing, and deploying software using programming languages and development tools.

    • Design the application by identifying user requirements and creating a plan

    • Write code using programming languages such as Java, Python, or C++

    • Test the application to ensure it functions correctly and meets user requirements

    • Deploy the application to a server or cloud platform for users to acce...

  • Answered by AI

Skills evaluated in this interview

CTPL Interview FAQs

How many rounds are there in CTPL SQL Database Developer interview?
CTPL interview process usually has 3 rounds. The most common rounds in the CTPL interview process are Technical, Resume Shortlist and Assignment.
What are the top questions asked in CTPL SQL Database Developer interview?

Some of the top questions asked at the CTPL SQL Database Developer interview -

  1. What is the difference of delete and trunc...read more
  2. What is the DBMS and rd...read more

Tell us how to improve this page.

CTPL SQL Database Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Cognizant Interview Questions
3.7
 • 5.7k Interviews
Deloitte Interview Questions
3.8
 • 2.9k Interviews
BYJU'S Interview Questions
3.1
 • 2.1k Interviews
Teleperformance Interview Questions
3.9
 • 1.8k Interviews
Reliance Retail Interview Questions
3.9
 • 1.6k Interviews
Ernst & Young Interview Questions
3.4
 • 1.2k Interviews
WNS Interview Questions
3.4
 • 1.1k Interviews
Google Interview Questions
4.4
 • 843 Interviews
Nagarro Interview Questions
4.0
 • 765 Interviews
View all
Software Engineer
7 salaries
unlock blur

₹1.4 L/yr - ₹2.1 L/yr

Admission Counsellor
6 salaries
unlock blur

₹1.3 L/yr - ₹3.5 L/yr

Plsql Developer
5 salaries
unlock blur

₹1.5 L/yr - ₹2.5 L/yr

Technical Support Executive
5 salaries
unlock blur

₹2.4 L/yr - ₹3.6 L/yr

SQL and PL SQL Developer
4 salaries
unlock blur

₹1.5 L/yr - ₹3.5 L/yr

Explore more salaries
Compare CTPL with

Cognizant

3.7
Compare

Teleperformance

3.9
Compare

iEnergizer

4.6
Compare

Reliance Retail

3.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview