Viewing 15 posts - 31 through 45 (of 69 total)
Anyone yet to take me up on explaining why a relational DBMS is called "relational"? It's a pretty fundamental question for a DBA.
June 18, 2021 at 6:34 pm
CURRENT_TIMESTAMP is an ISO Standard supported by Oracle and DB2 so that's not an excuse.
Which would explain why they don't know about getdate() - thanks by the way, I prefer...
June 18, 2021 at 6:31 pm
would you actually want to hire someone that claims to know T-SQL if you ask them how to get the current date and time using T-SQL and they HAVE to...
June 18, 2021 at 5:50 pm
Ask them about real situations or problems. See if they teach you anything or approach a problem in a better way. See if they bother to ask me for more...
June 18, 2021 at 5:46 pm
Some more questions for the senior candidate
What do you understand by closure in a relational context?
What transformation rules would you apply to simplify queries and check constraints?
June 18, 2021 at 4:25 pm
What answer are YOU looking for?
Why is it called relational?
June 18, 2021 at 3:43 pm
Ask someone if they know why an RDBMS is called relational.
Is no one going to take the bait?
June 18, 2021 at 3:30 pm
Ask someone if they know why an RDBMS is called relational.
The majority of candidates will give the wrong answer. This doesn't mean they should be rejected - they just need...
June 18, 2021 at 2:33 pm
In the DBMS; assertions - in the SQL Standard since 1992. They would make the implementation of multi-row and multi-table constraints much easier and much more reliable.
In SSMS the possibility...
June 17, 2021 at 8:44 pm
As an additional point, lobby Microsoft to implement assertions (in the SQL Standard since 1992) which would eliminate the need for constraints in triggers. I know that the implications for...
June 13, 2021 at 7:42 am
The referential and check constraints in SQL don't cover all possible necessary constraints.
Therefore you need to use triggers to enforce these constraints.
The arguments against triggers come from the Oracle camp....
June 13, 2021 at 7:36 am
They answer I gave were correct, but not elegant.
Sometimes there is a difference between the right answer and the right answer for the interview. You have to know both and...
May 23, 2021 at 7:54 pm
I've found learning about the mathematical background to the relational model very enlightening.
Some programmers and DBA seem to panic when I mention the "M" word, but the mathematics behind the...
May 22, 2021 at 11:22 am
And how it is actually stored and transmitted is not at all standard.
Well of course not, the whole point of the relational model is that you don't have to know...
May 21, 2021 at 6:14 pm
The information_schema is an ansi standard for SQL metadata supported by every DBMS. So the format for representing SQL data is standard.
May 21, 2021 at 5:57 pm
Viewing 15 posts - 31 through 45 (of 69 total)