Questions technique C++ et Python
Database Analyst Interview Questions
5,616 database analyst interview questions shared by candidates
How will you troubleshoot the issue faced by the end user that the db is running slow?
How to create tables in Innodb?
NOt selected in the interview
Tell about your self
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?
Viewing 3131 - 3140 interview questions