Upload Button Icon Add office photos

Cirrius

Compare button icon Compare button icon Compare

Filter interviews by

Cirrius Database Administrator DBA Interview Questions, Process, and Tips for Experienced

Updated 5 Mar 2021

Cirrius Database Administrator DBA Interview Experiences for Experienced

1 interview found

I applied via Walk-in and was interviewed in Feb 2021. There was 1 interview round.

Interview Questionnaire 

7 Questions

  • Q1. What is data
  • Ans. 

    Data is information that is stored and organized in a structured or unstructured format.

    • Data refers to facts, statistics, or information that can be processed or analyzed.

    • It can be in the form of numbers, text, images, audio, video, etc.

    • Data can be stored in databases, spreadsheets, files, or any other storage medium.

    • Examples of data include customer names, product prices, sales figures, medical records, etc.

  • Answered by AI
  • Q2. What is database
  • Ans. 

    A database is a structured collection of data that is organized and stored for easy access, management, and retrieval.

    • A database is a software system that manages and stores data.

    • It provides a way to organize and structure data in a logical manner.

    • Data in a database is typically stored in tables, which consist of rows and columns.

    • Databases allow for efficient storage, retrieval, and manipulation of data.

    • Examples of dat

  • Answered by AI
  • Q3. What is dbms and rdbms , differentiate
  • Ans. 

    DBMS is a software system that manages databases, while RDBMS is a type of DBMS that uses a relational model.

    • DBMS stands for Database Management System, which is a software system that manages databases.

    • RDBMS stands for Relational Database Management System, which is a type of DBMS that uses a relational model.

    • DBMS can manage any type of database, while RDBMS manages only relational databases.

    • DBMS does not enforce any ...

  • Answered by AI
  • Q4. What is sql and plsql, differentiate
  • Ans. 

    SQL is a language used to manage relational databases, while PL/SQL is a procedural language used to enhance SQL functionality.

    • SQL is used to create, modify, and query databases

    • PL/SQL is used to create stored procedures, functions, and triggers

    • SQL is a declarative language, while PL/SQL is a procedural language

    • SQL is used to manipulate data, while PL/SQL is used to manipulate the behavior of SQL

    • SQL is used in various d...

  • Answered by AI
  • Q5. Normalization and Types of Normalization
  • Ans. 

    Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

    • Normalization involves breaking down a table into smaller tables and defining relationships between them.

    • There are different levels of normalization, including first normal form (1NF), second normal form (2NF), and third normal form (3NF).

    • 1NF involves ensuring that each column in a table contains atomic values,...

  • Answered by AI
  • Q6. What is metadata
  • Ans. 

    Metadata is data that describes other data.

    • Metadata provides information about the structure, content, and context of data.

    • It can include information such as data type, format, source, and ownership.

    • Examples of metadata include file properties, database schema, and website tags.

    • Metadata is used by applications to manage and organize data.

    • It is also used for data analysis, search engine optimization, and digital preserv

  • Answered by AI
  • Q7. Types of backup
  • Ans. 

    Types of backup include full, incremental, differential, and snapshot.

    • Full backup: backs up all data in a database

    • Incremental backup: backs up only the changes made since the last backup

    • Differential backup: backs up only the changes made since the last full backup

    • Snapshot backup: creates a point-in-time copy of the database

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Just answer with confidence

Skills evaluated in this interview

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Oct 2018. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Asked me to draw spring mvc architecture and about collection framework.
  • Q2. Asked me to write the logic for pattern.
  • Q3. Asked me on core java.

Interview Preparation Tips

General Tips: be thorough with the core java and good to have knowledge on spring mvc
Skills: Communication
Duration: <1 week

I applied via Company Website and was interviewed before Dec 2019. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Regarding OOPS, wordpress and laravel.

Interview Preparation Tips

Interview preparation tips for other job seekers - It was good and I am still working here.

I applied via Referral and was interviewed before Jan 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Which technology are you using, is this latest?
  • Ans. 

    We are using a variety of technologies, including some of the latest ones.

    • We are using React for our front-end development.

    • We are also using Node.js for our back-end development.

    • We are using Docker for containerization.

    • We are using Kubernetes for orchestration.

    • We are using AWS for cloud hosting.

    • We are constantly evaluating new technologies to see if they can improve our development process.

  • Answered by AI
  • Q2. If not then which technology can we use instead of this?
  • Ans. 

    It depends on the specific requirements and constraints of the project.

    • Consider the project's goals and objectives

    • Evaluate the available technologies and their capabilities

    • Assess the project's budget and timeline

    • Consult with stakeholders and experts in the field

    • Examples: React vs Angular, MySQL vs MongoDB, Java vs Python

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Hi,
Listen carefully and speak fluently.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Second largest number in an array
  • Ans. 

    Find the second largest number in an array of strings.

    • Convert the strings to numbers for comparison.

    • Sort the array in descending order.

    • Return the second element in the sorted array.

  • Answered by AI
  • Q2. Pairs with given sum
  • Ans. 

    Find pairs in an array that sum up to a given target value.

    • Use a hash set to store the difference between the target value and each element in the array.

    • Iterate through the array and check if the current element's complement exists in the hash set.

    • Return the pairs that sum up to the target value.

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Aug 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. OOPS based questions
  • Q2. Basic language based questions
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What is single page application
  • Ans. 

    Single page application is a web application that loads a single HTML page and dynamically updates the content as the user interacts with the app.

    • SPA uses AJAX and HTML5 to create fluid and responsive user experience.

    • It eliminates the need for page reloading during use, making it faster and more efficient.

    • Examples include Gmail, Facebook, and Google Maps.

  • Answered by AI
  • Q2. What is state management
  • Ans. 

    State management is the process of managing the state of an application, including data flow, user interface updates, and user interactions.

    • State management involves storing and updating the state of an application to ensure data consistency.

    • It helps in managing user interface updates based on changes in the application state.

    • State management is crucial for handling user interactions and maintaining a seamless user exp...

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Oct 2022. There were 5 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 - Coding Test 

Duration is around 1 hour

Round 3 - Technical 

(1 Question)

  • Q1. 1. Basic programming concepts 2. OOP concepts and basic problem solving skills
Round 4 - Technical 

(1 Question)

  • Q1. Programming question
Round 5 - HR 

(1 Question)

  • Q1. 1. Basic questions

I applied via Referral and was interviewed before Feb 2021. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Tell me about yourself
Round 2 - Technical 

(1 Question)

  • Q1. 1 Project Explanation 2 SDLC & STLC. 3 Differentiate Smoke vs Sanity 4 What is Regression testing? 5 Bug life cycle. 6 Scenarios on real time example. 7 Questions on agile
  • Ans. 

    Interview questions for Software Engineer position

    • Project explanation should include details on the project's purpose, scope, and technologies used

    • SDLC (Software Development Life Cycle) and STLC (Software Testing Life Cycle) are methodologies used in software development and testing respectively

    • Smoke testing is a type of testing that checks if the basic functionalities of the software are working fine, while Sanity tes...

  • Answered by AI
Round 3 - One-on-one 

(1 Question)

  • Q1. All basic HR questions and salary discussion.

I applied via Recruitment Consulltant and was interviewed in Oct 2021. 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 - Technical 

(1 Question)

  • Q1. Completely on java
Round 3 - Technical 

(1 Question)

  • Q1. Asked java questiona

Cirrius Interview FAQs

What are the top questions asked in Cirrius Database Administrator DBA interview for experienced candidates?

Some of the top questions asked at the Cirrius Database Administrator DBA interview for experienced candidates -

  1. What is dbms and rdbms , differenti...read more
  2. What is sql and plsql, differenti...read more
  3. What is da...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Webdew Interview Questions
4.4
 • 106 Interviews
HyScaler Interview Questions
4.5
 • 92 Interviews
Quantsapp Interview Questions
2.8
 • 35 Interviews
Appsierra Interview Questions
4.4
 • 32 Interviews
NexTurn Interview Questions
4.1
 • 29 Interviews
View all
Software Engineer
46 salaries
unlock blur

₹2.1 L/yr - ₹6.5 L/yr

Product Executive
46 salaries
unlock blur

₹2 L/yr - ₹4.3 L/yr

Software Tester
15 salaries
unlock blur

₹2.8 L/yr - ₹4 L/yr

Customer Success Manager
15 salaries
unlock blur

₹4.2 L/yr - ₹10 L/yr

Senior Software Engineer
13 salaries
unlock blur

₹4.2 L/yr - ₹8.5 L/yr

Explore more salaries
Compare Cirrius with

Accel Frontline

4.0
Compare

Northcorp Software

4.3
Compare

Elentec Power India (EPI) Pvt. Ltd.

3.7
Compare

HyScaler

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