What is Concurrency? What are Software Metrics? What is the difference between cohesion and coupling? Explain the concept of modularization What is Data Flow Diagram? What is Software Configuration Management? What is the difference between Quality Assurance and Quality control? What is baseline in Software Development? What is SRS?
Tell about your self
majorly focused on projects and internships and what was my role in those
I was asked multiple Database design questions and SQL queries based on the schemas designed. Other rounds comprised of Market estimation and business case questions.
1.Joins 2. SP 3. Index
Salary queries CTE vs Table variable Vs Temp table Manager hierarchy Where vs Having How to remove duplicate records - Different ways? Indexing - Can we add primary constraint and cluster index on different columns? Index seek, table scan, key lookup, row look up, Views - can we Update, types, Indexed view, materialized view Department-wise highest salaries - Queries How will you design car showroom maintenance DB? Image datatypes Window functions Second round - Indexes Projects you worked on which procedures you have worked on, and what logic have you written? Temp tables, CTE, table variable Cursor Views Integer pattern Functions and stored procedures Nested stored procedure Query optimization How it works Why cursors should not be used. Cursor ka workaround Wild cards and ways of implementation without using like operator. Filter vowels from string, count of vowel. The composite index, Index seek and scan, SQL injection Linked server
Sharding and High availability
How do you determine why the same stored procedure may run with different execution plans.
1. Written Test 2. Interview: (Introduce yourself . . . followed by: ) a) Write fibonacci code b) Difference between: i) Struct, Union ii) Compiler, Interpretor iii) Processor, Controller c) What do you mean by OOP?
Basic PLSQL use cases like user defined exception, procedures and functions. Intermediate level sql queries
Viewing 3131 - 3140 interview questions