MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide

Object permission

A permission on a database object that controls how the object can be accessed.

One-to-many relationship

Used in a relational database to denote that a single row in the parent table can be related to one or more rows in the related child table but that a row in the child table can be related to only a single row in the referenced parent table.

One-to-one relationship

Used in a relational database to denote that a single row in the parent table can be related to only one row in the related child table and that a row in the child table can be related to only a single row in the referenced parent table.

Ownership chaining

Where the same object owner exists across all the dependency chains between the objects.

Категории