Download Aptitude Crack
img not found img not found

Data Models into Database Designs

Q1: A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):

A primary key.

B foreign key.

C composite key.

D surrogate key.

ANS:D - surrogate key.

Surrogate keys are keys that have no “business” meaning and are solely used to identify a record in the table. Such keys are either database generated (example: Identity in SQL Server, Sequence in Oracle, Sequence/Identity in DB2 UDB etc. ) or system generated values (like generated via a table in the schema).



img not found
img

For help Students Orientation
Mcqs Questions

One stop destination for examination, preparation, recruitment, and more. Specially designed online test to solve all your preparation worries. Go wherever you want to and practice whenever you want, using the online test platform.