Upload Button Icon Add office photos

Filter interviews by

Optimistic India E-Security and Surveillance Database Developer Interview Questions and Answers

Updated 6 May 2023

Optimistic India E-Security and Surveillance Database Developer Interview Experiences

1 interview found

Database Developer Interview Questions & Answers

user image Kharat Krutuja Narayan

posted on 6 May 2023

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Apr 2023. There were 4 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 

It's quite hard test.

Round 3 - Aptitude Test 

It is Intermediate level questions

Round 4 - Technical 

(3 Questions)

  • Q1. What is SQL and why we use it
  • Ans. 

    SQL is a programming language used to manage and manipulate relational databases.

    • SQL stands for Structured Query Language

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

    • It is used in various industries such as finance, healthcare, and e-commerce

    • Examples of SQL-based databases include MySQL, Oracle, and Microsoft SQL Server

  • Answered by AI
  • Q2. Difference between drop and delete command
  • Ans. 

    Drop command removes the entire table while delete command removes specific rows.

    • Drop command is a DDL (Data Definition Language) command while delete command is a DML (Data Manipulation Language) command.

    • Drop command cannot be rolled back while delete command can be rolled back using transaction.

    • Drop command is faster than delete command as it removes the entire table at once.

    • Example: DROP TABLE table_name; DELETE FRO

  • Answered by AI
  • Q3. Give me one query to solve
  • Ans. 

    Query to find the total sales amount for each product category

    • Use GROUP BY clause to group the sales by product category

    • Use SUM function to calculate the total sales amount

    • Join the sales table with the product table to get the product category

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. DDL DML DCL TCL
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. How to run parallel queries for multiple databases ??
  • Ans. 

    To run parallel queries for multiple databases, use parallel processing techniques and tools.

    • Use parallel processing techniques such as multi-threading or distributed computing to run queries simultaneously on multiple databases.

    • Consider using tools like Apache Hadoop or Apache Spark for parallel processing of queries across multiple databases.

    • Ensure proper resource allocation and optimization to prevent performance is...

  • Answered by AI
  • Q2. What is normalisation technique used for database??
  • Ans. 

    Normalization technique is used to organize 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.

    • It helps in reducing data redundancy by storing data in a structured and organized manner.

    • Normalization ensures data integrity by minimizing data anomalies such as update, insert, and delete anomalies.

    • There...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep cool head try to answer as per your knowledge.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected
Round 1 - Technical 

(2 Questions)

  • Q1. What is database architecture?
  • Ans. 

    Database architecture refers to the design and structure of a database system.

    • Database architecture includes the organization of data, storage, retrieval, and security mechanisms.

    • It involves defining the relationships between data elements and how they are stored and accessed.

    • Examples of database architectures include hierarchical, network, relational, and object-oriented.

    • Database architecture also includes the choice ...

  • Answered by AI
  • Q2. Difference between delete and truncate
  • Ans. 

    Delete removes rows one by one, while truncate removes all rows at once.

    • Delete is a DML command, while truncate is a DDL command.

    • Delete can be rolled back, while truncate cannot be rolled back.

    • Delete fires triggers, while truncate does not fire triggers.

    • Delete is slower as it logs individual row deletions, while truncate is faster as it logs the deallocation of the data pages.

    • Example: DELETE FROM table_name WHERE condi

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare well

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Nov 2022. 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 - Group Discussion 

Problem solving skills
Decision making
Information exchange
Generating ideas
Instructions

Round 3 - HR 

(2 Questions)

  • Q1. Describe your self in 3 words Why should I hire you Why are you leaving your current job Do you have any questions for me What is your hobbies Describe your management style
  • Q2. What is your hobbies Describe your management style

Interview Preparation Tips

Topics to prepare for Amazon Database Developer interview:
  • C#.Net
Interview preparation tips for other job seekers - Good communication skills
Work experience for before working place

I applied via Recruitment Consulltant and was interviewed in Feb 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Coding Test 

In it they trying to get the information about basic knowledge about related to database and also they are give to write some queries

Round 3 - Coding Test 

Related queries which you did in your past projects and also some queries to write

Interview Preparation Tips

Interview preparation tips for other job seekers - Manager ask some database related queries and hr was trying to negotiate for salary

I applied via Naukri.com and was interviewed in Feb 2021. There were 4 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. About previous project experience
  • Q2. SQL concepts
  • Q3. Non-sql concepts
  • Q4. Devops

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare all the concepts which you have worked on.

I applied via Walk-in and was interviewed in Feb 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. SQL server advanced interview questions and answers
  • Q2. This is best usually used

Interview Preparation Tips

Interview preparation tips for other job seekers - Hi, am I mastanrao and I will used best interview questions and answers

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

Interview Questionnaire 

1 Question

  • Q1. Prepare basic

Interview Preparation Tips

Interview preparation tips for other job seekers - Just focus on basics of sql
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - Coding Test 

I have agreep on python basic

Interview Preparation Tips

Topics to prepare for Wipro Database Developer interview:
  • Python
Interview preparation tips for other job seekers - i like to do this job

Optimistic India E-Security and Surveillance Interview FAQs

How many rounds are there in Optimistic India E-Security and Surveillance Database Developer interview?
Optimistic India E-Security and Surveillance interview process usually has 4 rounds. The most common rounds in the Optimistic India E-Security and Surveillance interview process are Resume Shortlist, Coding Test and Aptitude Test.
What are the top questions asked in Optimistic India E-Security and Surveillance Database Developer interview?

Some of the top questions asked at the Optimistic India E-Security and Surveillance Database Developer interview -

  1. What is SQL and why we use...read more
  2. Difference between drop and delete comm...read more
  3. Give me one query to so...read more

Tell us how to improve this page.

Optimistic India E-Security and Surveillance Database Developer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Compare Optimistic India E-Security and Surveillance with

TCS

3.7
Compare

Accenture

3.9
Compare

Wipro

3.7
Compare

Cognizant

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