You probably already know that a primary key is used to uniquely identify a row of data in a table. In some cases, one column in the table can server as a primary key. In other cases, it takes multiple columns to serve as a primary key. Any primary key based on two or more columns is called a composite primary key.
The columns in a table are often called fields or attributes of the entity the table represents. Each row in that table is called a record or tuple. The word "tuple" is most commonly used in relational data theory. Most practitioners use "record" or "row" instead of "tuple."
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading