Shared Flashcard Set

Details

Chapter 2: Using DDL Statements to Create and Manage Tables
Contains Database Objects that will be on the exam
8
Engineering
Professional
09/23/2011

Additional Engineering Flashcards

 


 

Cards

Term

:DBO:

CONSTRAINT

Definition
A small bit of logic defined by you, to instruct a particular table about how it will accept, modify, or reject incoming data.
Term

:DBO:

TABLE

Definition
A structure that can store data. All data is structured in columns and rows. Each column’s datatype is explicitly defined.
Term

:DBO:

INDEX

Definition
An object designed to speed up searches in a table. An INDEX performs much the same way as an index to a book, by copying a relatively small, select amount of information, sorting it for speedy reference, and tying it back to locations in the table for supporting quick lookups of rows in the source table.
Term

:DBO:

VIEW

Definition
A “filter” through which you can search a table, and interact with a table, but that stores no data itself, and simply serves as a “window” onto one or more tables. VIEW objects can be used to mask portions of the underlying table logic for various reasons—perhaps to simplify business logic, or perhaps to add a layer of security by hiding the real source of information. A VIEW can be used to display certain parts of a table, while hiding other parts of the same table.
Term

:DBO:

SEQUENCE

Definition
A counter, often used to generate unique numbers as identifiers for new rows as they are added to a table.
Term

:DBO:

SYNONYM

Definition
An alias for another object in the database, often used to specify an alternative name for a table or view.
Term

:DBO:

USERS

Definition
The “owners” of database objects.
Term

:DBO:

ROLES

Definition
A set of one or more privileges that can be granted to a user.
Supporting users have an ad free experience!