Get ahead with a $300 test prep scholarship
| Enter to win by Tuesday 9/24
MCSA Capter 3 Key Terms
Terms in this set (37)
A data format in which data is represented as a srier of zeros and ones.
Microsoft's open source project hosting site where you can find useful sample code for a wide range of Microsoft products.
A representation of an attribute of the object modeled by a table, defined witha unique column name and data type.
A condition that imposes a limitation on a value or action;a column restraint such as specific data types.
A logical database structure uesd to improve the speed and efficency of data access. A database index is constructed based on a unique key, and it contains pointers to the underlying rows within the table.
a file that stores database objects and their underlying data; these files are given a .mdf file extension. Data files are subdivided into physical units of storage called pages that are grouped together into extents for space management.
a column attribute that defines the type of data a column can strore; acts as a constraint because it limits the type of vales that can be stored. The main data types include unique indentifers, numbers of varying precision, dates, and times and text strings.
a physical storage unit that is a collection of eight pages, grouped together for space management.
A server that providesw the capability to execute queries against a remote data source for running distributed queries. a linked server uses shared software components (called data providers) from the dynamic-link library (DLL) on the server to manage the interface between SQL Server and the external data source.
a service that enables a client to connect to the SQL server instance over a network
A file that records the series of changes that occur to a database over time, and they enable a database to be restored to a specific point in time.
A way of organizing data, with defined rules for storing manipulating and retrieving the data; client applications interact with logical objects within a database rather than the physical files.
An IP address that sends outbound packets of data directly back to the host computer to simulate a physical network
A system database that stores the configuration settings thjat describe the structure and security of all other dadabases.
a system database that is used as a template when creating a new user database.
An older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts. Each SQL Server instance is able to listen on one named pipe
A component of SQL Server Management Studio that provides a tree view of the different database schema objects oragnized as a series of folders.
Online Transcation Processing (OLTP)
A method of data processing that is geared toward traansaction-oriented applications that have a substantial write component inn their interaction with the database; an OLTP database is defined by a high volume of individuaql read and write transactions.
a physical storage unit in a data file
A column or combination of columns taht uniquely indetify each record within a table.
A precompliled block code that enables frequently performed tasks for querying and/or manipulating data to be stored as objects within the database
A component of SQL Server Management Studio that enables you to create SQL queries to be executed against a database
A logical instance of an object commonly called a record that is modeled by a taqble (e.g., an Employee); may contain several attributes that are defined as colums (e.g., first name, last name, Social Security number).
A local procedure call that requires the client application to be running on the sme host as SQL Server instance. No configuration options are available with a shared memory connection.
A procedure that can be used to view and alter global configuration settings.
A utility that enables you to connect to the database fromm a command prompt and execute SQL commands and scripts
SQL Server Browser
A service that performs instance lookup and name resolution for remote clients.
SQL Server Management Studio
A management tool used to configure manage and admisister the Database Engine Services, Anaylsis Services, Intergration Services, and Reporting Services
SQL Server Newtork Interface layer.
The network protocol layer that manages the handoof of TDS packets between the SQL Server and the operating system-supported network protocol at an endpoint.
SQL Server Resolution Protocol (SSRP)
A protocol used by SQL Server Browser for performing instance lookup and name resolution for remote clients.
A collection of data stored in a database. In a relational database, tables are typically Designed to model real-world objects and the relationships that exist between them. Tables are organized as a two-demensional structure consisting of rows and columns.
A scan of every record within a table undertaken by a database engine in the absence of a suitable index for a query.
Tabular Data Stream (TDS) packet
A message used by SQL Server for communication; when the SQL Server is connected to a remote client, TDS packets must be encapsulated within a standard network protocol packet to enable that data to be sent over the network between the client and server.
The most common protocol used for client/server connectivity
A log of events on the database management system that are captured using the SQL Server Profiler and commonly used for troubleshooting SQL Server preformance issues.
A procedural mechanism that can be configured to automatically fire an event when a row is inserted, modified, or deleted; often used to satisfy compliance aspects of the business requirements by cascading details of a change into a related table or autopopulating metadata within a record.
A type of saved query