How to identify and eliminate the duplicate rows in a table?
Sql Support Interview Questions
2,209 sql support interview questions shared by candidates
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
asking Out of subject question (not from sql developer)
Mostly about SQL and PLSQL
Viewing 1661 - 1670 interview questions