If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
967how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
1631We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
1385
What are differences in between sql server 2012 and sql server 2016?
Can sql servers linked to other servers?
what is the difference between Tabular and Matrix report?
What are data resources?
What is the fastest way to permanently delete a 1 million row table named customers?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
What are the different sql server versions?
Describe in brief system database.
What is difference between count (*) and count 1?
What are the steps you can take to avoid “deadlocks”?
Explain how you can configure a running aggregate in SSRS?
Does windows server 2016 come with sql server?
What is RAID? What are the different types of RAID configurations?
Do you think BCNF is better than 2NF & 3NF? Why?
What is awe?