AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
CTPL SQL Database Developer Interview Questions and Answers
CTPL SQL Database Developer Interview Experiences
1 interview found
Anonymous
Selected
I applied via Recruitment Consulltant and was interviewed in Nov 2022. There were 3 interview rounds.
Questions on basic of SQL queries and it is easy to solve all the queries
(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
- 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
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
I appeared for an interview in Sep 2016.
Interview Questionnaire
4 Questions
- Q1. Tell me about the Summer Project
- Ans.
Developed a web application for tracking student attendance and performance
Used React.js for front-end development
Implemented RESTful APIs using Node.js and Express for back-end
Utilized MongoDB for database storage
Integrated authentication and authorization features for secure access
- Q2. Questions on Sql Dbms Java C
- Q3. Basic Programming Question
- Q4. Questions on hobbies and CV related
Interview Preparation Tips
Experience: Use diagrams to describe your project and the interviewer should fully understand your project
Tips: Be Clear and say things which you know
Round: HR Interview
Experience: She asked me about everything related to my hobbies.
Tips: Don't lie about your Interests and Hobbies in CV. Know everything there is to know about the hobbies which you have specified.
Skills: C Programming, Java Programming, SQL, Basic Knowledge Of DBMS, Problem Solving Abilties
College Name: BP Poddar Institute OF Management & Technology
Jinal Shah
Interview Questionnaire
16 Questions
- Q1. Tell me something about yourself
- Ans.
I am a passionate software engineer with experience in developing web applications using various technologies.
Experienced in developing web applications using HTML, CSS, JavaScript, and frameworks like React and Angular
Proficient in backend development with Node.js and databases like MongoDB and MySQL
Familiar with version control systems like Git and deployment tools like Docker
Strong problem-solving skills and ability
- Q2. What are your hobbies?
- Ans.
My hobbies include hiking, playing guitar, and reading science fiction novels.
Hiking in local trails and national parks
Playing acoustic and electric guitar in a band
Reading books by authors like Isaac Asimov and Philip K. Dick
- Q3. Why cognizant over other companies?
- Ans.
Cognizant offers diverse projects, global exposure, and a strong focus on employee growth and development.
Cognizant provides opportunities to work on diverse projects, allowing for a broad range of experience.
The company has a global presence, offering exposure to different cultures and markets.
Cognizant emphasizes employee growth and development through training programs and career advancement opportunities.
- Q4. Why engineering?
- Ans.
Engineering allows me to solve complex problems, innovate, and create solutions that have a real impact on society.
Engineering provides a platform to apply scientific knowledge to practical problems.
It involves critical thinking, problem-solving, and creativity.
Engineers have the opportunity to work on cutting-edge technologies and make a tangible difference in the world.
For example, designing software systems to impro...
- Q5. Draw pin diagram of 8085 microprocessor
- Ans.
Pin diagram of 8085 microprocessor
8085 has 40 pins in total
Pins are grouped into 5 categories: power supply, address bus, data bus, control and status signals
Pin 1 is the reset pin, Pin 40 is the Vcc pin
Examples of control signals: RD, WR, ALE, INT, HOLD
Examples of status signals: S0, S1, IO/M, HLDA
- Q6. Difference between 8085 and 8086 microprocessor
- Ans.
8086 is an advanced version of 8085 with more features and capabilities.
8086 has a 16-bit data bus while 8085 has an 8-bit data bus.
8086 has more registers than 8085.
8086 has a higher clock speed than 8085.
8086 supports virtual memory while 8085 does not.
8086 has a more advanced instruction set than 8085.
Example: 8086 can perform multiplication and division operations while 8085 cannot.
- Q7. What is opamp?
- Ans.
Opamp stands for operational amplifier. It is an electronic device used to amplify and process signals.
Opamps have high gain and can amplify signals to a very high degree.
They are commonly used in audio amplifiers, filters, and signal processing circuits.
Opamps have two input terminals and one output terminal.
They can be configured in different ways to perform various functions such as amplification, filtering, and osc...
- Q8. What are different phases of waterfall model?
- Ans.
Waterfall model has five phases: requirements, design, implementation, testing, and maintenance.
Requirements phase: gathering and documenting requirements
Design phase: creating a detailed design based on requirements
Implementation phase: coding and integrating components
Testing phase: verifying that the system meets requirements
Maintenance phase: making changes and updates to the system
Example: building a website using...
- Q9. Types of testing
- Ans.
Types of testing include unit, integration, system, acceptance, regression, performance, and security testing.
Unit testing: testing individual units or components of the software
Integration testing: testing how different units or components work together
System testing: testing the entire system as a whole
Acceptance testing: testing to ensure the software meets the requirements and is ready for release
Regression testing...
- Q10. Practical question related to normalization and its theory
- Q11. What extra curricular activities you are interested in?
- Ans.
I enjoy participating in coding competitions, volunteering at tech events, and attending hackathons.
Participating in coding competitions such as Codeforces or Topcoder
Volunteering at tech events like hackathons or coding workshops
Attending hackathons to collaborate with other developers and work on innovative projects
- Q12. What is your goal in life?
- Ans.
My goal in life is to continuously learn and grow, while making a positive impact on the world around me.
Continuous learning and personal growth
Making a positive impact on the world
Achieving work-life balance
Building meaningful relationships
Contributing to the community
- Q13. Do you have any problem in relocation?
- Ans.
I am open to relocation for the right opportunity.
I am willing to relocate for the job.
I have no issues moving to a new location for work.
I am excited about the possibility of experiencing a new city or country.
I have relocated for previous jobs and have found it to be a positive experience.
- Q14. Reasons why you want to and why you don't want to relocate?
- Ans.
I want to relocate for career growth and new experiences, but I am hesitant due to leaving behind family and friends.
Career growth opportunities in new location
Desire for new experiences and challenges
Concerns about leaving behind family and friends
- Q15. What do you watch ion tv?
- Ans.
I enjoy watching a variety of shows on TV, including dramas, comedies, and documentaries.
I watch dramas like Grey's Anatomy and This Is Us
I enjoy comedies such as The Office and Brooklyn Nine-Nine
I also like watching documentaries on topics like nature and history
- Q16. Which movie did you last see
- Ans.
I last saw the movie Inception.
Directed by Christopher Nolan
Released in 2010
Genre: Sci-Fi/Thriller
Starring Leonardo DiCaprio
Interview Preparation Tips
Experience: On 1st September 2016, Cognizant held this round at our college. We were initially told that it would be an adaptive paper but it was not so. We could not navigate between questions (both intra and inter section). There was a minimum number of questions which had to be attempted from each section else we would disqualify. The questions were easy and I found many questions common from AMCAT papers.
Tips: Practice as much as you can. Try to learn shortcut tricks to solve the questions quickly and easily. Try to solve questions within certain time limit. Give online tests so that you are familiar with giving tests on machine. Do not waste time in a particular question. If you can't solve it then leave it( if there is negative marking) or answer randomly( if there is no negative marking).
Duration: 55 mins minutes
Total Questions: 55
Round: Technical Interview
Experience: The interviewer asked me to introduce myself. I was nervous and so i fumbled in 2 or 3 sentences but then i took the pace. he chit chatted with me to release my pressure . he went through my resume and my marksheets. he asked a few HR questions and then started the technical interview. He asked me questions regarding microprocessors and electronics but I had prepared software subjects I being a CS student could not remember most of it. But I sill answered them with best of my knowledge. i told him that I would rather be comfortable with CS core subjects. then he shifted his focus to DBMS and Software Engineering I did not lose my calm although I was very nervous. I thought I would be rejected but finally I got selected.
Tips: Don't be nervous as most of the interviewers are really friendly and they give ample chances to prove yourself. Try to practice the your introduction. They may ask your questions that are not from your domain but try to answer them with your presence of mind and previous knowledge. you may be nervous but don't show that on your face. Try to have basic concepts of your core subjects.
Round: HR Interview
Experience: It is the best round. You can voice your own views. The interviewers are mostly friendly and you seem to have a discussion with your friends.
If you manage to appear for this round most probably you will be selected.
Tips: Just be simple and be frank. Answer to the point and do not sound arrogant.
Skill Tips: Try to clear the aptitude and half of your job is done. For technical interview try to learn the basics of c,OOPS,DBMS. Try to know about the company .
Be calm .
All the best..!!
Skills: software engineering, Basic Electronics, Basic Knowledge Of DBMS
College Name: St. Thomas' College Of Engineering & Technology
Skills evaluated in this interview
Interview Preparation Tips
Duration: 15 minutes
Round: Test
Duration: 50 minutes
Skills: Communication, Clear Communication
College Name: Tkr college of engineering and technology
Abhishek Shaw
I appeared for an interview in Sep 2016.
Interview Questionnaire
10 Questions
- Q1. Tell me about yourself ?
- Ans.
I am a passionate software engineer with experience in developing web applications and a strong background in computer science.
Experienced in developing web applications using technologies like HTML, CSS, JavaScript, and React
Strong background in computer science with knowledge in algorithms and data structures
Passionate about learning new technologies and solving complex problems
- Q2. What is your fav subject ?
- Ans.
My favorite subject is computer science because I enjoy problem-solving and creating innovative solutions.
Computer science allows me to work on challenging problems and develop new technologies.
I enjoy coding and building software applications.
I find the intersection of technology and creativity fascinating.
Computer science offers endless opportunities for learning and growth.
- Q3. Write a query to find the employee name who earns maximum salary
- Ans.
The query finds the employee name who earns the maximum salary.
Use the SELECT statement to retrieve the employee name and salary from the database table.
Use the ORDER BY clause to sort the results in descending order based on salary.
Use the LIMIT clause to limit the result to only one row.
Return the employee name from the query result.
- Q4. Another simple query
- Q5. Introduce yourself
- Ans.
I am a passionate software engineer with experience in developing web applications using various technologies.
Experienced in front-end development using HTML, CSS, and JavaScript
Proficient in back-end development with Node.js and Express
Familiar with database management systems like MySQL and MongoDB
- Q6. Favorite Game and Player ?
- Ans.
Favorite Game: The Legend of Zelda: Breath of the Wild, Favorite Player: Lionel Messi
Favorite Game: The Legend of Zelda: Breath of the Wild
Favorite Player: Lionel Messi
- Q7. Why him ?
- Q8. Do you have problem in night shift ?
- Ans.
I am comfortable working night shifts and have no problem with it.
I have experience working night shifts in previous roles.
I am able to adjust my sleep schedule accordingly to accommodate night shifts.
I am aware of the potential challenges of working night shifts and have strategies to overcome them.
- Q9. Comfortable working outside kolkata ?
- Ans.
Yes, I am comfortable working outside Kolkata.
I am open to new opportunities and experiences in different locations.
I am adaptable and can easily adjust to new environments.
I have previous experience working in different cities, such as Delhi and Bangalore.
- Q10. Then asked to read terms and condition and signed
Interview Preparation Tips
Experience: Reading Comprehennsion in Verbal needs time, rest was easy. Finished the test in 40 minutes and each section has a time limit with no negative marking and the test was adaptive you cannot vist a question twice and you cannot leave a question you must attempt and move to
Tips: Test vendor is amcat for many years. Practice as many questions you can get of Amcat .
Total Questions: 55
Round: Technical Interview
Experience: The interview was too short around 3-4 minutes as i was interviewed towards the end then next was HR.I had a certificates .
Design and Analysis of Algorithm-NPTEL. The ignored it
Tips: Things depend on luck I was asked favorite subject I said C he asked from DBMS :) . Some people were asked from Microprocessor :( also. Some were asked programs like reverse a number then prime number vowel count etc
Round: HR Interview
Experience: I was getting nervous HR said you have cleared the interview this is just a discussion why being tensed ? General conception is every one clears Technical clears HR . Around 5-6 didn't clear HR
Tips: Just talk always with a smile in face in HR nothing more
Skill Tips: Be calm that's it in mass recruitment luck often plays a vital role.
Skills: Communication, SQL
College Name: st.thomas college of engineering and technology
Skills evaluated in this interview
Neha kumari
Interview Questionnaire
11 Questions
- Q1. Tell me about yourself
- Ans.
I am a software engineer with experience in developing web applications and a passion for learning new technologies.
Experienced in developing web applications using technologies such as React, Node.js, and MongoDB
Passionate about learning new technologies and keeping up with industry trends
Strong problem-solving skills and ability to work well in a team environment
- Q2. Questions on SQL(as mentioned in my resume)
- Q3. Questions on all the projects done including their practical utility, my role in particular
- Q4. What all extra curriculars were you involved in
- Ans.
I was involved in various extracurricular activities such as volunteering, sports, and coding clubs.
Volunteered at local animal shelter
Played on intramural basketball team
Participated in coding competitions
Organized and led coding club at school
- Q5. Two puzzles: 1. how can you cut a cake in 8 pieces in minimum number of cuts(answered) ,2.make 4 equilateral triangles using 6 matchsticks(answered)
- Q6. What do you do in your lab courses in college(explained in detail a particular experiment i had performed recently)
- Q7. Do you have any questions
- Q8. How was the technical interview
- Q9. Asked me about my AIEEE rank and branch performance
- Q10. What do you want to do in future that you have not attempted yet( I mentioned social service and music)
- Q11. What are your location preferences
- Ans.
I am open to working in any location, but I prefer cities with a vibrant tech community.
Open to any location
Prefer cities with a vibrant tech community
Interview Preparation Tips
Experience: clearly cgpa based (>6.5). Around 900 students were shortlisted.
Round: Test
Experience: aptitude questions were quite easy and a person with average qaunt skills can easily make through. there was a question to be answered in a paragraph form to judge your english proficiency. around 450 students made it to the next round.
Tips: follow R.S. Agarwal for aptitude part and rest is an application of little bit of common sense.
Round: Technical Interview
Experience: technical round is not tough to crack if you are clear with your basics. this round also comprises HR questions. The questions depend on your branch and CV.
Tips: stay calm and confident. be thorough with your resume. do not leave any loopholes. focus on your strengths during the interview. they mainly look for a confident person with good communication skills. you may clearly say a no if you are not well versed with a topic but do not beat around the bush.
Round: HR Interview
Experience: there were also some absurd questions like do you know cooking & driving etc. but that made me all the more comfortable. the interview was very light and seemed like a casual conversation. the interviewer also shared her experiences and was very jovial. made me read and sign a document which concluded my interview.
Tips: if you have cleared the tech round..more than half the job is done unless you dun make some major blunder here. just maintain a smile and answer all questions honestly. you will surely make it. I was informed regarding my selection a week later. good luck to the future aspirants.
Skills: Verbal Ability, Logical Reasoning, Aptitude, 1)communication
College Name: BIT Mesra
Interview Preparation Tips
Experience: Very easy test.It is conducted by amcat.You can go through the amcat material before appearing for the exam.
Tips: Practice from indiabix.com
Round: Technical Interview
Experience: Ask questions related to your projects in resume.Some simple C programs(to print the prime numbers between 1 to 100).Some basic questions on sdlc.
Tips: Don't be panic.Listen to the questions carefully
Round: HR Interview
Experience: General questions.They will ask you to sign on one agreement type i.e regarding relocation problems.
Tips: Stay cool and focussed.
General Tips: S
Skill Tips: Whatever branch you are be perfect in the basics
Skills:
College Name: VIT Vellore
Interview Questionnaire
2 Questions
- Q1. Pre-increment and post-increment
- Q2. Why IT company being a non CSE and IT student?
Interview Preparation Tips
Experience: This is one of the most easiest round as it does not involve any complicated maths and only involves logical thinking
Tips: Prepare easy questions such as direction and syllorgism
Duration: 30 minutes
Total Questions: 25
Round: Technical Interview
Experience: Though it is an IT company questions will be mainly asked from your own stream. Still they would ask a basic C or C++ question.
Tips: No need to panic. It is always best to know your subject along with some basic ideas about programming language.
Round: HR Interview
Experience: This is one of the very frequent question they would ask in an interview. Well you can convince the interviewer that you are mouldable and readily working for any sort of company.
Tips: Here the main thing or aspect that is checked is your communication skill.
General Tips: Your resume speaks more than anything else. Please do make sure that your resume is proper and put all your plus points in it. Please do maintain a good English as they give a huge value for this and always try to keep a smile on your face.
Skill Tips: Mainly apart from your technical skill, your communication skill is checked and at times when you go attend a stress interview please make sure that you answer in an intelligent way and also always have a smile on your face.
Skills: communication skill, ability to handle your frustrations
College Name: SATHYABAMA UNIVERSITY
Motivation: Definitely one of the best IT company. Always cool with their staff and less rules
Funny Moments: This happened during Wipro interview. The interviewer was never really interested to listen to my answers as he picked up the phone and started talking to his wife about that day's lunch :P.
Interview Preparation Tips
Duration: 55 min minutes
Total Questions: 60
College Name: KIIT UNIVERSITY
Motivation: my parents n friends and my internal desire to get placed in a gud cmpny
Interview Preparation Tips
Experience: to.me totally there were three sections.verbal,apti and reasoning.each section carries 15,15 and 10 questions respectively.to me verabal and apti was little bit easy and it consumes more time to solve the apti questions.so i have been solved 8 apti questions and at last 1minute i.just qlicked the answers for remaining questions randomly becasue we didnt have negative mark and finally reasobing was much easier and solved every answers.
Tips: to get selected in the first round you should practice more online tests.then you can easily manage your time.and be cool. so dont worry every thing will become easier and do well.
all the best!!!
Round: HR Interview
Experience: when i faced my HR he asked me to tell three things about me, i.have told generosity,confidence and friendship.and he asked me to elobrate it and i have done well and he goes with the projects that i have done .afterwards he asked about my stream and why it.and i have answered that iam from electrical and electronics background but now a days IT has been entered into every sector and without IT there would be nothing in this world.thats why i choose IT.and asked about my extra curricular activities and iam a sports person too and finally few questions from C and C++.
Tips: Be confident in your speech and try to answer even if not knows the answer well,because they will see how we are trying to answer so dont hesitate to answer.and keep your mind free and every thing will be alright.be cool and all the best
General Tips: start to prpare atleast before one week from the interview.and be cool at any situations and to get speak english fluently practice with your friends and try to converse every thing in english even with customer care, it will be funny to and thats make you to survive your interviews easily...
Skills:
College Name: sri krishna college of engineering and technology
Motivation: in this company there will be friendly environment and there will be less working pressure and have some cultural clubs to have fun with it
Funny Moments: before one week to our placements our friends get started to chat in english and every where we conversed in english it was funny and later we realised how it helped us. so dont bother about others and what they think. just go on with your friends confidently in english...
CTPL Interview FAQs
Tell us how to improve this page.
CTPL Interviews By Designations
Interview Questions for Popular Designations
- SQL Database Administrator Interview Questions
- SQL Developer Interview Questions
- Database Admin Interview Questions
- SQL Server Database Administrator Interview Questions
- Oracle Database Administrator Interview Questions
- Database Analyst Interview Questions
- Database Developer Interview Questions
- Database Administrator DBA Interview Questions
- Show more
CTPL SQL Database Developer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
|
Software Engineer
7
salaries
|  ₹1.4 L/yr - ₹2.1 L/yr |
|
Admission Counsellor
6
salaries
| ₹1.3 L/yr - ₹3.5 L/yr |
|
Plsql Developer
5
salaries
| ₹1.5 L/yr - ₹2.5 L/yr |
|
Technical Support Executive
5
salaries
| ₹2.4 L/yr - ₹3.6 L/yr |
|
SQL and PL SQL Developer
4
salaries
| ₹1.5 L/yr - ₹3.5 L/yr |
Cognizant
Teleperformance
iEnergizer
Reliance Retail
- Home >
- Interviews >
- CTPL Interview Questions >
- CTPL SQL Database Developer Interview Questions
