Skip to contentSkip to footer

Analista Sql Interview Questions

Salaries
Interviews

2,215 analista sql interview questions shared by candidates

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.)
avatar

PL/SQL Developer

Interviewed at Capgemini

4.2★
May 2, 2023

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
avatar

SQL Server Developer

Interviewed at Fulcrum Worldwide

4.1★
Jan 20, 2014

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

Are you looking for a change? We can help you find a job within a week. We work directly with IT Giants in US and we have a very good and dedicated marketing team. maximum it would take 10-15 days for us to find a job for you.
avatar

SQL Developer

Interviewed at Dextro Software Systems

3.2★
Jul 28, 2016

Are you looking for a change? We can help you find a job within a week. We work directly with IT Giants in US and we have a very good and dedicated marketing team. maximum it would take 10-15 days for us to find a job for you.

Viewing 1551 - 1560 interview questions

Glassdoor has 2,215 interview questions and reports from Analista sql interviews. Prepare for your interview. Get hired. Love your job.