Deloitte SQL Interview Questions and Answers

This video talks about
Deloitte SQL Interview Questions and Answers
Top SQL Interview Questions
Top SQL Interview Questions and answers
sql faq
sql interview questions with answers
Top 10 SQL Interview Questions and Answers
Deloitte Interview Questions and Answers
Deloitte Questions with Answers
SQL Procedure Interview Questions
SQL Interview Questions
SQL Interview Questions and answers
Top SQL Interview Questions
SQL Interview call
SQL FAQ's
top sql faq
sql training videos
sql stored procedure
stored procedure in sql server
sql server interview questions and answers for experienced
advantages of using stored procedure
sql procedure questions
differences between Stored Procedure and Functions in SQL
What are stored procedures-Advantages of Stored procedures in sql
sql tutorial
SQL Server Interview Questions and Answers: For All Database Developers and Developers Administrators
a.What is Truncate in SQL?
Syntax : Truncate Table Table Name
b. What is Cross apply?
join table and table valued function ..
c. What is Outer apply?
d. What is Rank function in SQL Server?
e. Is there any other function which generates rank(similar) in sql server?
f. What are all the indexes you used in your project?
g. What is the normalization and its purpose??

[@shallychoudhary4969]

Nice explanation of each question

[@Training2SQLMSBI]

Thanks for your feedback .. appreciate your time..

[@sathyanarayanaguptha8956]

Thanx for giving valuable information....

[@gopisateesh7924]

@@Training2SQLMSBI ఉప f

[@aishwaryajumnani8737]

Thank you for all questions and explanations

[@47tanveer]

Hi sir very helpful interview questions
Can u plz upload some real time telephonic interview for SQL server developer.

[@ravitejapinapaka3005]

Nice Explanation

[@vdharman1272]

Nice explanation each of questions...

[@Training2SQLMSBI]

Thank for your feedback .. Feeling happy with your feedback ..

[@felixrajaj6231]

Very good questions and explanation. Thank you.

[@Training2SQLMSBI]

You are welcome!

[@daminiogety1258]

Thanks sir for nice explanation

[@srijitkar8143]

For the question of cross apply function i hope it can be dont via left/right join also as you need data from other table also which are not common value

[@dadwilld4209]

Very nice...

[@shantanurauthan9318]

you could have just uploaded the doc from where you were reading that stuff out loud..Anyway your efforts are appreciated

[@nitagawade3330]

Very nicely explained each question... Thank you!!!

[@lemidebel6396]

I am using SMS 2016, JOIN works for Table and Table UDF without error

[@chennareddy8147]

Nice explanation for about interview questions sir

[@Training2SQLMSBI]

Thanks and welcome

[@mradulgupta3694]

Nicely explained.. Thanks

[@Training2SQLMSBI]

You are welcome

[@dheerendrakumarjoshi2126]

Nice

[@gauravjoshi5054]

Helpful info nice explanation

[@Training2SQLMSBI]

Thanks for your feedback .. appreciate your time..

[@iyappanc2747]

wats the difference between outer apply and left join and right join

[@zachpan4143]

Thank you so muchhh❤❤

[@Training2SQLMSBI]

thanks for your valuable feedback.

[@rishabhjain7777]

great explanation Thank you 👍

[@Training2SQLMSBI]

You are welcome!

[@surajkshirsagar6209]

very good explanation!

[@Training2SQLMSBI]

Thanks for your feedback ..

[@monday6740]

1:30 DELETE causes redo, TRUNCATE does not, if I am correct (on Oracle at least), because DELETE is part of INSERT/UPDATE/DELETE set, and TRUNCATE is not

[@rahulkherde]

Correct.. delete do a log entry..

[@ak6877]

Those are DML including SELECT

[@athiraprabhakaran7281]

Truncate is a DDL command and all DDLs are auto commit.. where as Delete is a DML command.. so u can roll back after performing delete .

[@ranveermishra2]

Hello sir i like to tell you i following your video ..its very helpful...i have question copy one table to another table change the datetime(dt of brth column) format to year (birth year) how we can achive this plz if you can suggest i will be thankful to you

[@Training2SQLMSBI]

First of all thank for your feedback ..
Get the year from date of birth column and save in the second table..

[@Cora-me]

Training2SQL MSBI 4
l o.

[@mohammedmujtabaahmed8337]

Arent these a bit too simple for Deloitte ? I was under the assumption that tech rounds will be very difficult in these consulting companies. TCS, Accenture, Deloitte etc

[@sofinusrat7914]

SQL server use in pdd working kaisay karay ga

[@saranyakalai4281]

Can u able give ssas training

[@yashashoysal1763]

set it to 2.0

[@maheshgupta568]

How to truncate command reset Identity column value?

[@prasadkharate]

DBCC CHECKIDENT ('tableName', RESEED, 0)

[@devashishghosh7497]

Truncate table

[@pratikmayekar314]

Now even truncate can be rolled back😉

[@shakiraafshan6544]

How?

[@alm5966]

Here's one for you....find your most important table and enter Truncate and the table name and press enter! It's so much fun.

[@foodislove6295]

why didnt you mention that TRUNCATE frees up the memory which DELETE cant.

[@nagulapallykumar2401]

Normalization explaination

[@gamersglimpse7548]

Dont u think it was too much add

[@Anonymous-cj4gy]

Truncate can be rolled back if the transaction is not committed.

[@TheChandansss]

Soo poor in explaining Rank and Dence Rank

[@abhijeetpandey8052]

He should have shown with examples keeping same salary