Jun 16, 2012 · If you don't understand operating in sets, you can't effectively query a relational database. I would give them some cursor examples and ask how they would rewrite them to …

Apr 3, 2010 · Way too broad of a question for an interview - it could fill a small book. I would simply remember a few key points about the first 3 normal forms (4 and 5 for extra credit). Here's a …

May 2, 2012 · Questions every good Database/SQL developer should be able to answer. Looking for some good questions to be asked for in Database interview / practical lab exam. The topics I …

Ask questions, find answers and collaborate at work with Stack Overflow for Teams. ... Create new database ...

Oct 13, 2009 · If I had asked them to show me a snippet of the code during the interview, and they had shown me some of the core stuff (the extension code actually mostly contained the client …

May 6, 2010 · EDIT: I just re-read your question. With an auto-increment field, the database decides the value at the time of insert. It manages locking tables and ensuring uniqueness - one of the …

Mar 6, 2020 · Here's one option: SQL> with 2 -- sample data 3 a (col1, col2) as 4 (select 11, 'A' from dual union all 5 select 26, 'B' from dual union all 6 select 31, 'C' from dual union all 7 select 43, 'D' …

Aug 25, 2023 · There have been similar questions raised, but I wanted some clarity nevertheless. I have been using the AdventureWorks2017 package on SQL and I am meant to get 290 rows as …

Newest vector-database questions feed To subscribe to this RSS feed, copy and paste this URL into your RSS ...

Dec 16, 2013 · I was hoping to rewrite it so they can manage the questions in the new admin panel so they can add/edit/remove questions in the backend with out editing views or leaving old …