Question asked: Two therotical questions rest practical questions. Asked basic theory questions like difference in truncate and drop ,SQL command etc and in practical segregation and agreegation questions alter table questions group by questions
Sql Support Interview Questions
2,214 sql support interview questions shared by candidates
Tell me about yourself
How to identify and eliminate the duplicate rows in a table?
Basic questions on SQL
SQL: joins, constraints, clauses, identity column
SQL queries resume
Asked specific SQL related questions to tesst my skills and knowledge
Detail what occurs during a DBCC CHECKDB command. In hind site this was rediculous because the DBA who interviewed me had turned off all database consistancy check jobs on all customer servers because he didn't understand what the previous DBA had done. It would up being an example of customers paying for something they weren't getting.
What is INNER join? Do you know ROLLBACK? Write a SQL query to retrieve all columns from a table named "Employees." How would you handle a situation where a SQL query returns duplicate rows, and you need to eliminate them?
Keys in SQL
Viewing 1661 - 1670 interview questions