| |||||
 |
|
|
|||
|
|
Is the Identity the equivalent of Oracles auto-s More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...) Is the Identity the equivalent of Oracles auto-sequencing in Sybase? Answer: More or less yes. Oracle's auto-sequencing feature is somewhat transparent to the end user and automatically increments if created as a primary key upon a row insert. The Sybase Identity column is normally specified at table creation and thus is a functional column of the table. If however you set the "auto identity" feature for a database, the tables created will have a "hidden" identity column that doesn't even appear when you execute a select * from [table]. See the Advantages of Identities for more details. (Continued on next question...)
Other Job Interview Questions
|
||||
|
|
|
|||
