Multiple choice technology databases

In NPS, it's a best practice to use 'rowid' as a primary key in a database table to guarantee quick access

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The answer is False because while rowid provides fast access, it's not recommended as a primary key in NPS. Rowids can change during operations like DELETE and INSERT, making them unreliable as permanent identifiers. Best practice is to use explicit surrogate keys or natural keys that remain stable. Rowid is useful for performance but not as a primary key.

Keep practicing — related questions