If you have me those answers you would get the job. As a pedant, I would also add the following.
4: Microsoft wanted to release a new RDBMS and as IBM already had db2 they wanted to call it and the programming language Sequel, however lawyers pointed out they would never be able to trademark it so they called is SQL instead and SAID it stood for Structured Query Language.
9 SQL is an ANSI standard for conversing with RDBMS. mySQL is a proprietary (open source) implementation of RDBMS and has its own dialect of SQL which builds on top of the ANSI standard. The same applies to Oracle, Microsoft, postgress Progress and a handful of others.
32 certainly in MS Sequel, Delete will write to the transaction log and can be rolled back whereas truncate cannot. In addition truncate will reset the record id incremented whereas delete does not. Both are limited by referential integrity constraints
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
If you have me those answers you would get the job. As a pedant, I would also add the following.
4: Microsoft wanted to release a new RDBMS and as IBM already had db2 they wanted to call it and the programming language Sequel, however lawyers pointed out they would never be able to trademark it so they called is SQL instead and SAID it stood for Structured Query Language.
9 SQL is an ANSI standard for conversing with RDBMS. mySQL is a proprietary (open source) implementation of RDBMS and has its own dialect of SQL which builds on top of the ANSI standard. The same applies to Oracle, Microsoft, postgress Progress and a handful of others.
32 certainly in MS Sequel, Delete will write to the transaction log and can be rolled back whereas truncate cannot. In addition truncate will reset the record id incremented whereas delete does not. Both are limited by referential integrity constraints