Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Orbit Techsol Team. If you also belong to the team, you can get access from here

Orbit Techsol Verified Tick

Compare button icon Compare button icon Compare
3.9

based on 121 Reviews

Filter interviews by

Orbit Techsol SQL Database Administrator Interview Questions and Answers

Updated 29 Apr 2022

Orbit Techsol SQL Database Administrator Interview Experiences

1 interview found

I applied via Referral and was interviewed in Oct 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basics networking, DBMS, everything

Interview Preparation Tips

Interview preparation tips for other job seekers - Clear ur basics in IT sector

Interview questions from similar companies

Round 1 - Technical 

(1 Question)

  • Q1. Difference between index and statistics
  • Ans. 

    Index is used to speed up data retrieval while statistics are used by the query optimizer to create an efficient query plan.

    • Indexes are created on columns to speed up data retrieval

    • Statistics are used by the query optimizer to create an efficient query plan

    • Indexes are used to enforce uniqueness and primary key constraints

    • Statistics are used to estimate the number of rows returned by a query

    • Indexes can be clustered or n...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Get ready more about sql server Basics and performnace tuning

Interview Questionnaire 

1 Question

  • Q1. HADR,PERFORMANCE TUNING
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Aug 2024. There were 8 interview rounds.

Round 1 - Assignment 

Database Management system SQL and PlSQL

Round 2 - Assignment 

Database Base Management system SQL and PlSQL

Round 3 - Aptitude Test 

Database Management system

Round 4 - Aptitude Test 

Database Management system

Round 5 - Group Discussion 

Database Management system

Round 6 - Assignment 

Database Management system

Round 7 - Case Study 

Database Base Management system

Round 8 - HR 

(5 Questions)

  • Q1. Database Management system
  • Q2. SQL and PlSQL Mango Data And Manu Database Management system
  • Q3. C Language and C++Language and Java
  • Q4. Data Analysis and Data entry
  • Q5. DBMS C,C++ Java Data Entry Ms Excel Ms Word Ms PP

Interview Preparation Tips

Interview preparation tips for other job seekers - Database Management system SQL and PlSQL and C Language and C++Language and Java And Web design and Web Developer
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. How you will find that some user SQL running slow without discussing with user?
  • Q2. How you will patch specific db components to reduce downtime?
  • Ans. 

    To patch specific db components to reduce downtime, follow these steps:

    • Identify the specific components that need to be patched

    • Plan the patching process during a scheduled maintenance window

    • Backup the database before applying patches

    • Apply patches to the specific components one by one

    • Test the patched components to ensure they are functioning correctly

    • Monitor the database for any issues post-patching

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. Why you have so many hopping in your resume?
  • Q2. How you will rate yourself as an dba?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared technically.
Be loyal in interview , if you don't know just tell
Try to be solution oriented person
Give genuine real time faced issues
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. About oracle database functionality
Round 2 - HR 

(1 Question)

  • Q1. Salary discussion

I applied via Recruitment Consultant and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

4 Questions

  • Q1. Are you aware of DevOp? How to use in producing output for client?
  • Ans. 

    Yes, DevOps is a set of practices that combines software development and IT operations to deliver high-quality software faster.

    • DevOps is a culture and set of practices that emphasizes collaboration, automation, and monitoring throughout the software development lifecycle.

    • It involves integrating development, testing, deployment, and operations teams to streamline the software delivery process.

    • By using DevOps, database a...

  • Answered by AI
  • Q2. What is the application that is better than Spark in AWS?
  • Ans. 

    AWS Glue is an application that is better than Spark in AWS.

    • AWS Glue is a fully managed extract, transform, and load (ETL) service that makes it easy to prepare and load data for analytics.

    • It provides a serverless environment for running ETL jobs and supports various data sources and destinations.

    • AWS Glue also offers automatic schema discovery, data cataloging, and data transformation capabilities.

    • It integrates well wi...

  • Answered by AI
  • Q3. How do you connect to to AWS as a developer?
  • Ans. 

    To connect to AWS as a developer, you can use the AWS Management Console, AWS CLI, or AWS SDKs.

    • Use the AWS Management Console to access AWS services through a web-based user interface.

    • Utilize the AWS Command Line Interface (CLI) to interact with AWS services using commands in the terminal.

    • Leverage AWS Software Development Kits (SDKs) to integrate AWS services into your applications.

    • For example, you can use the AWS SDK ...

  • Answered by AI
  • Q4. What is the security system of AWS access?
  • Ans. 

    AWS provides a comprehensive security system for access control.

    • AWS Identity and Access Management (IAM) allows you to manage access to AWS services and resources.

    • IAM enables you to create and manage users, groups, and roles, and assign permissions to them.

    • AWS provides various authentication methods like username/password, multi-factor authentication, and integration with external identity providers.

    • Access can be contr...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Sometimes the interviewer can be a glober - who really doesn't know what they are talking about. They will even ask you what they do not know. They can even ask you things that are NOT applicable and they will stand with it to show that they know better. Above all as a candidate for the role that you really want to go with, ensure that you are aware of what you say, be prepared for the interview as if you know nothing. Ensure that you are well informed on the line of task. Also be prepated to provide the interviewer one good project that you had already carried out based on the application required for the profile. Be calm always if the company recruit you, it is their luck as you always have ample opportunity with other company as well.

Skills evaluated in this interview

I applied via Referral and was interviewed in Jan 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Expert level SQL knowledge,questions on SQL queries

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and if you don't know the answer asked in interview do not panic
Just assure the interviewer that ur ready to learn anything given an opportunity
Do not fake or do not show the desperation for the job
Never tell yes to everything
Provide a stipulated time for you to learn the process
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. How to sync primary and standby?
  • Ans. 

    Primary and standby databases can be synced using Data Guard in Oracle.

    • Configure Data Guard on primary and standby databases

    • Enable redo transport services

    • Monitor and resolve any synchronization issues

    • Perform switchover or failover when necessary

  • Answered by AI
  • Q2. Performance tuning?
Round 2 - HR 

(2 Questions)

  • Q1. Why you want to change the job?
  • Ans. 

    Seeking new challenges and growth opportunities in a dynamic environment.

    • Looking for new challenges to enhance my skills and knowledge

    • Seeking growth opportunities for career advancement

    • Interested in working in a more dynamic and innovative environment

  • Answered by AI
  • Q2. Expected salary.

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. HADR,PERFORMANCE TUNING

Orbit Techsol Interview FAQs

How to prepare for Orbit Techsol SQL Database Administrator interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Orbit Techsol. The most common topics and skills that interviewers at Orbit Techsol expect are Cloud, Migration, Postgres, IBM DB2 and Postgresql.

Tell us how to improve this page.

Interview Questions from Similar Companies

Cognizant Interview Questions
3.8
 • 5.5k Interviews
Nagarro Interview Questions
4.0
 • 773 Interviews
Publicis Sapient Interview Questions
3.5
 • 606 Interviews
GlobalLogic Interview Questions
3.7
 • 575 Interviews
Samsung Interview Questions
4.0
 • 551 Interviews
UST Interview Questions
3.8
 • 505 Interviews
View all
Network Engineer
76 salaries
unlock blur

₹1.4 L/yr - ₹8.5 L/yr

System Engineer
51 salaries
unlock blur

₹1.5 L/yr - ₹3.6 L/yr

Desktop Support Engineer
40 salaries
unlock blur

₹1.5 L/yr - ₹3.6 L/yr

Network Security Engineer
22 salaries
unlock blur

₹2.1 L/yr - ₹5.1 L/yr

System Administrator
22 salaries
unlock blur

₹2.3 L/yr - ₹7.2 L/yr

Explore more salaries
Compare Orbit Techsol with

Dell

4.0
Compare

HP India

4.1
Compare

Lenovo

4.3
Compare

Acer India

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