SQL Interview Questions with Answers

1. How to change a table name in SQL?
This is the command to change a table name in SQL:
ALTER TABLE table_name
RENAME TO new_table_name;
We will start off by giving the keywords ALTER TABLE, then we will follow it up by giving the original name of the table, after that, we will give in the keywords RENAME TO and finally, we will give the new table name.

2. How to use LIKE in SQL?
The LIKE operator checks if an attribute value matches a given string pattern. Here is an example of LIKE operator
SELECT * FROM employees WHERE first_name like ‘Steven’;
With this command, we will be able to extract all the records where the first name is like “Steven”.

3. If we drop a table, does it also drop related objects like constraints, indexes, columns, default, views and sorted procedures?
Yes, SQL server drops all related objects, which exists inside a table like constraints, indexes, columns, defaults etc. But dropping a table will not drop views and sorted procedures as they exist outside the table.

4. Explain SQL Constraints.
SQL Constraints are used to specify the rules of data type in a table. They can be specified while creating and altering the table. The following are the constraints in SQL: NOT NULL CHECK DEFAULT UNIQUE PRIMARY KEY FOREIGN KEY

React ❤️ for more

HSBC is hiring!
Position: Business Analyst
Qualifications: Bachelor’s/ Master’s Degree
Salary: 7 - 12 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore (Hybrid)

📌Apply Now: https://mycareer.hsbc.com/en_GB/external/PipelineDetail/Business-Analyst/272368

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

PhonePe is hiring Business Operations Analyst 🚀

Min. Experience : 1 Year
Location : Bangalore

Apply link : https://app.greenhouse.io/embed/job_app?token=6616277003&gh_src=961e65dc3us

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

KPMG is hiring Business Analyst Executive 🚀

Qualification : Any Degree
Location : Bangalore

Apply link : https://ejgk.fa.em2.oraclecloud.com/hcmUI/CandidateExperience/en/job/INTG10033141/?utm_medium=jobshare

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Ciena is hiring Associate Business Analyst 🚀

Experience : 0-2 Years
Location : Gurugram

Apply link : https://ciena.wd5.myworkdayjobs.com/en-US/Careers/job/Remote--India--Gurugram/Associate--Business-Intelligence---Data-Informatics_R028421?source=LinkedIn

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

𝐓𝐄𝐋𝐔𝐒 𝐃𝐢𝐠𝐢𝐭𝐚𝐥 - 𝐖𝐨𝐫𝐤 𝐅𝐫𝐨𝐦 𝐇𝐨𝐦𝐞!
Position: Online Data Analyst
Qualifications: Any Graduate/ Post Graduate
Salary: Upto 6.5 LPA (Expected)
Experience: Freshers (0 - 2 Years)
Location: Remote (Work From Home)

📌Apply Now: https://jobs.telusdigital.com/en_US/careers/PipelineDetail/Online-Data-Analyst-India/26613?source=TI+website

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

NTT Data hiring for multiple roles

Apply link: https://nttdata.eightfold.ai/careers?pid=563327923701384&domain=nttdata.com

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

JLL hiring BI Analyst

Apply link: https://jll.wd1.myworkdayjobs.com/jllcareers/job/Bengaluru-KA/Business-Intelligence-Development-Analyst_REQ435833

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Ericsson hiring Data Analyst

Apply link: https://jobs.ericsson.com/careers/job/563121765901065

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

🎓 Graduated in 2024 or graduating in 2025?
💼 Or looking for your next career move?

🚀 Join Coding Ninjas as an Admission Counsellor and grow with one of India’s leading ed-tech companies!

👨‍💻 Why Coding Ninjas?
We’re part of Info Edge (Naukri.com) and have helped over 2.5L learners upskill , with 1400+ alumni in FAANG & top tech firms.
Here, you’ll:
✅ Work in a performance-driven & growth-oriented culture
✅ Build real communication, sales & strategy skills
✅ Be part of a team that moves fast and supports your long-term growth

📍 Location: Gurugram (On-site)
🔗 Apply Now: https://docs.google.com/forms/d/e/1FAIpQLSdAT-hBXoL-BktEFj26aF29id5Rx4t54Q807op6Bo3NyFF4GQ/viewform?usp=pp_url&entry.1071787807=jobssql
Whether it’s your first role or your next big leap - this is where careers accelerate. 💥

𝐄𝐘 𝐎𝐟𝐟 𝐂𝐚𝐦𝐩𝐮𝐬 𝐑𝐞𝐜𝐫𝐮𝐢𝐭𝐦𝐞𝐧𝐭 𝐃𝐫𝐢𝐯𝐞!
Position: Associate Analyst
Qualification: Bachelor’s/ Master's Degree
Salary: 4.6 - 8 LPA (Expected)
Experience: Freshers/ Experienced
Location: Mumbai; Pune; New Delhi, India

📌Apply Link: https://careers.ey.com/ey/job/Pune-Associate-Analyst-TAX-National-TAX-Indirect-Tax-Indirect-Tax-Global-Trade-Pune-MH-411001/1220791501/

https://careers.ey.com/ey/job/Mumbai-Associate-Analyst-TAX-National-TAX-GCR-Global-Compliance-&-Reporting-Mumbai-MH-400028/1222226201/

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Moneyview is hiring Product Analyst 🚀

Experience : 2 Years
Location : Bangalore

Apply link : https://www.linkedin.com/jobs/view/4266252432

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Beco is hiring Data Analyst Intern 🚀

Freshers are eligible ✅
Location : Mumbai

Apply link : https://kwickliving.keka.com/careers/jobdetails/94274?source=linkedin

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Livspace is hiring Business Analyst 🚀

Min. Experience : 1 Year
Location : Bangalore

Apply link : https://www.linkedin.com/jobs/view/4266872283

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Analyst- Data Analytics role for Gurgaon location.

Exp range- 3+ years
Must Have Skills- Python and SQL
Good to Have- Tableau, Power BI Dashboard, Advanced excel

Apply link: https://aexp.eightfold.ai/careers/job/29781714?hl=en

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Razorpay hiring Associate Business Analyst

Apply link: https://job-boards.greenhouse.io/razorpaysoftwareprivatelimited/jobs/4585849005

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Optum is hiring!
Position: Data Analyst, Business & Data Analytics
Qualification: Bachelor’s/ Master's Degree
Salary: 6 - 14 LPA (Expected)
Experience: Freshers/ Experienced
Location: Noida; Hyderabad; Gurgaon, India.

📌Apply Link: https://careers.unitedhealthgroup.com/job/21677151/data-analyst-or-lead-noida-in/

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

S&P Global is hiring!
Position: Data Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 5 - 9 LPA (Expected)
Experience: Freshers/ Experienced
Location: Gurgaon; Ahmedabad; Bangalore; Hyderabad; Mumbai, India

📌Apply Now: https://careers.spglobal.com/jobs/312784

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Deloitte is hiring Data Analyst 🚀

Experience : 1+ Year
Location : Bangalore

Apply link : https://www.linkedin.com/jobs/view/4265447161

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Wipro is hiring!
Position: Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 5 - 9 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bengaluru/ Gurugram

📌Apply Now: https://careers.wipro.com/job/Gurugram-Analyst-122016/1149120855/

https://careers.wipro.com/job/Bengaluru-Analyst-560035/1152181155/

👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍