EXAM CRAM™ 2 Designing and Implementing Databases with SQL Server 2000 Enterprise Edition [Electronic resources] نسخه متنی

K-L

The LIKE predicate is used to search through character strings by specifying a search string. A LIKE search is primarily used for searches based on wildcard characters, such as the percent sign (%).

linked server

A database object that represents a particular data source and the attributes, including security and collation attributes, necessary to access the data source.

local partitioned view

A partitioned view where all member tables reside on the local instance of SQL Server.

lock

A method of ensuring concurrency. Locking enables users to temporarily "check out" an object, preventing other users from changing the object, for the purpose of ensuring consistency.

log file

A file or set of files containing a record of the modifications made in a database.