Basics in database administration High availability ways Always On Performance tuning
Sql Analyst Interview Questions
2,215 sql analyst interview questions shared by candidates
Just basic theoritical questions powerbi sql
Cursor and sub queries, trigger and many more
log shipping, mirroring, clustering, Always on
Cursors, types of cursors, and cursors l attributes
Difference between Function and Procedure
1) Write procedure based upon scenario. 2) Write function to count vowels of a string. 3) Index conceptual questions (data will be inserted faster on table with index or without index table, purpose of indexing) 4) Oracle Data Dictionary questions (oracle supplied packages, tables etc.)
what is materialized view and why it is required?what is pivot? when to use the non-clustered index and when to use clustered one.what will you do if your database is growing out of size?how to optimize the query or stored proc? how to read execution plan and what steps to take on it? write query which can add row number column for a table? what is partition? diff between temp table and temp table variable? scope of global variable? there are two tables both have only one column which accepts null, both table have 5 rows as 1,1,1,1,null. how many rows will come for inner join, left, right, union and union all on these two tables.(try this on SSMS)? High level design for employee, tasks and timesheet scenario etc
Basic Plsql interview questions
Introduction SSIS transformation Difference between union all and merge Difference between conditional split and multicast Scenario based questions Query to delete duplicate records
Viewing 1541 - 1550 interview questions