DBA > Job Interview Questions > Sybase Interview Questions and Answers

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