AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
SQL Star International SQL Server Developer Interview Questions and Answers
SQL Star International SQL Server Developer Interview Experiences
1 interview found
Anonymous
Selected
I applied via Naukri.com and was interviewed in Jan 2023. There were 3 interview rounds.
Additional aptitude testing resources you can gain access to !
(2 Questions)
- Q1. Tell me the details of the project you the have done ?
- Q2. Have you faced any challenging situation ? How you handle it ?
Interview Preparation Tips
- SQL Server
- SQL Server Development
be preopared bring resumes & business cards.
Attend the free workshop and resources at event.
Top trending discussions
Interview questions from similar companies
Selected
I applied via Walk-in and was interviewed in Aug 2023. There were 2 interview rounds.
(4 Questions)
- Q1. What is a sql commands
- Ans.
SQL commands are instructions used to interact with a database management system to perform tasks such as querying, updating, and managing data.
SQL commands are used to perform various operations on a database, such as selecting data with SELECT, inserting data with INSERT, updating data with UPDATE, and deleting data with DELETE.
Other common SQL commands include CREATE TABLE for creating tables, ALTER TABLE for modify...
- Q2. What is a intigrity constaraints
- Ans.
Integrity constraints are rules that ensure data integrity and consistency in a database.
Integrity constraints are used to enforce business rules and maintain data accuracy.
Common types of integrity constraints include primary key, foreign key, unique key, and check constraints.
For example, a primary key constraint ensures that each row in a table is uniquely identified by a specific column or combination of columns.
- Q3. What is a stor procedure
- Ans.
A stored procedure is a precompiled collection of SQL statements that can be executed by calling the procedure name.
Stored procedures can accept input parameters and return output parameters.
They can be used to encapsulate complex logic and improve performance by reducing network traffic.
Stored procedures are stored in the database and can be reused by multiple applications or users.
Example: CREATE PROCEDURE GetEmploye...
- Q4. Differents type of joins
- Ans.
Different types of joins in SQL include inner join, left join, right join, and full outer join.
Inner join: Returns rows when there is a match in both tables.
Left join: Returns all rows from the left table and the matched rows from the right table.
Right join: Returns all rows from the right table and the matched rows from the left table.
Full outer join: Returns rows when there is a match in either table.
Interview Preparation Tips
Skills evaluated in this interview
(1 Question)
- Q1. Asked about SSIS, Queries to retrieve highest salary and asked about projects
Interview Preparation Tips
ETL Developer Interview Questions & Answers
Tech Mahindra
RAMAVATHULA CHANDRA NAIK
posted on 4 Feb 2025
(2 Questions)
- Q1. They were asking very logical and technical questions on interview time
- Q2. They were test our skills and time punctuation
(1 Question)
- Q1. They were discussed with some technical questions and based on knowledge
Interview Preparation Tips
Boobalan S
(2 Questions)
- Q1. Multithreading, Collection list
- Q2. Java Program on Strings, Threads
(2 Questions)
- Q1. Project Explanation
- Q2. Git Commands, Linux Commands
Selected
I applied via Naukri.com and was interviewed in Jun 2024. There were 3 interview rounds.
(3 Questions)
- Q1. Questions related to the current and past projects.
- Q2. Aws related questions.
- Q3. Data warehousing basics
(2 Questions)
- Q1. Explain about the roles and responsibilities.
- Q2. Discussion about the role in Genpact.
(2 Questions)
- Q1. Asked about expectated salary
- Q2. Why are you switching
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.
(1 Question)
- Q1. What is pull request
- Ans.
A pull request is a method of submitting contributions to a project on GitHub for review and merging.
Pull requests are commonly used in version control systems like Git to propose changes to a codebase.
They allow developers to collaborate and discuss changes before merging them into the main branch.
Pull requests typically include a description of the changes, related issues, and any necessary tests or documentation.
Rev...
(1 Question)
- Q1. What is sateful set
- Ans.
Stateful set is a Kubernetes controller that manages the deployment and scaling of a set of pods with persistent storage.
Stateful set ensures that each pod in the set has a unique identity and stable network identity.
Stateful set pods are created in order and are not replaced until they are deleted.
Stateful set is commonly used for stateful applications like databases where each pod requires persistent storage.
Example:...
Skills evaluated in this interview
(2 Questions)
- Q1. Asked about data tools other than AWS services
- Q2. When did you use HUDI and Iceberg
- Ans.
I have used HUDI and Iceberg in my previous project for managing large-scale data lakes efficiently.
Implemented HUDI for incremental data ingestion and managing large datasets in real-time
Utilized Iceberg for efficient table management and data versioning
Integrated HUDI and Iceberg with Apache Spark for processing and querying data
Skills evaluated in this interview
Database Developer Interview Questions & Answers
Persistent Systems
Adarsh Chauhan
posted on 17 Oct 2024
(2 Questions)
- Q1. Static and dynamic polymorphism
- Q2. Code snipts related to prefix and postfix
Interview Preparation Tips
Selected
I applied via Company Website and was interviewed in Aug 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Dba backups in sql
- Ans.
DBA backups in SQL are essential for data protection and disaster recovery.
Regularly schedule full, differential, and transaction log backups to ensure data is protected.
Store backups in secure locations to prevent data loss in case of hardware failure or corruption.
Test backups regularly to ensure they can be restored successfully in case of emergency.
- Q2. Dba replication
(2 Questions)
- Q1. Tell me about urself
- Ans.
I am a dedicated and experienced MS SQL DBA with a strong background in database administration and performance tuning.
Over 5 years of experience working as a MS SQL DBA
Proficient in database administration tasks such as backup and recovery, performance tuning, and security
Skilled in troubleshooting and resolving database-related issues
Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Serv...
- Q2. Strengths and weakness
Skills evaluated in this interview
SQL Star International Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Database Developer Interview Questions
- SQL Server Database Administrator Interview Questions
- SQL Database Administrator Interview Questions
- MS SQL DBA Interview Questions
- Senior SQL Developer Interview Questions
- Data Architect Interview Questions
- Database Architect Interview Questions
- ETL Developer Interview Questions
- Show more
SQL Star International SQL Server Developer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
|
Software Engineer
4
salaries
|  ₹3 L/yr - ₹4.2 L/yr |
TCS
Accenture
Wipro
Capgemini
- Home >
- Interviews >
- SQL Star International Interview Questions >
- SQL Star International SQL Server Developer Interview Questions
