SQL SERVER

Start Studying!

Terms

undefined, object

copy deck

Permissions within specific databases are controlled by what?: user accounts
What is a stored procedure?: A precompiled collection of Transact-SQL statements stored under a name and processed as a unit. SQL Server supplies stored procedures for managing SQL Server and displaying information about databases and users. SQL Server-supplied stored procedures are called system stored procedures.
When the application is on a separate client, a network what is used to communicate with SQL Server?: Windows Interprocess Communication (IPC) components
A client/server database system comprises two components. What are they?: 1) Programs that provide an interface for client-based users to access data.
2) The database structure that manages and stores the data on the server.
What is full integrity protection?: All data modifications are performed in transactions, and each transaction is either wholly committed if it reaches a state of consistency, or completely rolled back if it encounters errors. If a server fails, all uncompleted transactions are automatically rolled back from all SQL Server 2000 databases when the server is restarted.
SQL Server tables have two main components what are they?: columns and rows.
Tables have several types of controls name some.: constraints, rules, triggers, defaults, and customized user data types
Each instance of SQL Server has four system databases what are they?: master, model, tempdb, and msdb
What are they ways Microsoft® SQL Server 2000 is designed to work?: As a central database on a server shared by many users who connect to it over a network. The number of users can range from a handful in one workgroup, to thousands of employees in a large enterprise, to hundreds of thousands of Web users.

A desktop database that services only applications running on the same desktop
This refers to each occurrence of a column having a correct data value. The data values must be of the right data type and in the correct domain.: Data integrity
What does the SQL Server Performance Monitor do?: integrates SQL Server counters into the Windows Performance Monitor, allowing administrators to monitor and graph the performance of SQL Server with the same tool used to monitor Microsoft Windows NT Servers.
What are triggers?: They are are a special class of stored procedure defined to execute automatically when an UPDATE, INSERT, or DELETE statement is issued against a table or view.
What is new in the SQL Sever 2000 Analysis Services?: Includes a new data mining component
What is a View?: It can be thought of as either a virtual table or a stored query. The data accessible through a view is not stored in the database as a distinct object. What is stored in the database is a SELECT statement. The result set of the SELECT statement forms the virtual table returned by the view. A user can use this virtual table by referencing the view name in Transact-SQL statements the same way a table is referenced
What does (OLAP) stand for?: Online Analytical Processing
Defaults can be anything that evaluates to a constant, such as what?: Constant
Built-in function
Mathematical expression
The OLAP Services feature available in SQL Server version 7.0 is now called what?: SQL Server 2000 Analysis Services
SQL Server stores the data defining the configuration of the server and all its tables in what?: system table
To connect to an instance of Microsoft SQL Server 2000, you typically give an application only two or three pieces of information what are they?: The network name of the computer on which the SQL Server instance is running.

The name of the instance (optional, required only if you are connecting to a named instance).

Your login identifier (ID).
Which datatype can be used to store the result set of an SQL statement?: table base data type
The Repository component available in SQL Server version 7.0 is now called what?: Microsoft SQL Server 2000 Meta Data Services
What can views do?: Restrict a user to specific rows in a table.
Restrict a user to specific columns.
Join columns from multiple tables so that they look like a single table.
Aggregate information instead of supplying details
What does ISV stand for?: Independent Software Vendors
IPC has two components what are they?: Application Programming Interface (API)

Protocol
What does the SQL Server Agent do?: allows the definition and scheduling of tasks that run on a scheduled or recurring basis.
These specify what values are used in a column if you do not specify a value for the column when inserting a row.: Defaults
What can be added to the tables to ensure that interrelated data in different tables remains consistent?: Declarative referential integrity (DRI) constraints
What are the objects used to maintain integrity?: Constraints
Rules
Defaults
Triggers
A database in Microsoft SQL Server 2000 consists of a collection of what?: tables
Using constraints is preferred to what?: triggers, rules, and defaults
What does SQL-DMO stand for?: SQL Distributed Management Objects.
What are user defined functions in SQl Server?: Allow you to define your own Transact-SQL functions using the CREATE FUNCTION statement. Can take input parameters.
What is replication?: Allows you to maintain copies of data in multiple sites, sometimes hundreds of sites, using a publish-subscribe metaphor. This allows sites to locate data close to the users who most frequently access it, while keeping it synchronized with copies in other locations.
What is referential integrity?: indicates that the relationships between tables have been properly maintained.
Data in one table should only point to existing rows in another table; it should not point to rows that do not exist.
What are the tools that SQL Server 2000 offers database administrators for managing their systems: SQL Server Enterprise Manager
SQL Server Agent
SQL Profiler

SQL Server Performance Monitor

Index Tuning Wizard
What allow you to define the way Microsoft SQL Server 2000 automatically enforces the integrity of a database?: Constraints
What does the SQL Profiler do?: Offers administrators a sophisticated tool for monitoring and analyzing network traffic to and from a server running SQL Server 2000.
Microsoft SQL Server 2000 uses components called ___ to shield the OLE DB Provider for SQL Server 2000, the SQL Server 2000 ODBC driver, and the DB-Library DLL, from the details of communicating with different Interprocess Communication (IPC) components.: Client Net-Libraries
All data and objects in the database, such as tables, stored procedures, triggers, and views, are stored within these operating-system files. What are they?: Primary
Secondary
Transaction Log
What are Distributed Query's?: They allow you to integrate data from several sources with the data in a SQL Server 2000 database.
What does stand for(OLTP)?: Online Transaction Processing
Microsoft SQL Server 2000 includes several features that support the complex data storage needs of large Web sites and modern, enterprise data processing systems. Name some.: Distributed Query
Dynamic Row-Level Locking
Full Integrity Protection
Distributed Transactions
Replication
What do the SQL Distributed Management Objects (SQL-DMO)do?: It is a set of automation objects that can be used to code applications with the logic to administer an instance of SQL Server 2000. This gives application packages the ability to transparently embed SQL Server 2000 into their applications. Experienced database administrators can also use it to build applications for many of the common administrative tasks unique to their site.
What allows you to integrate data from several sources with the data in a SQL Server 2000 database.: Distributed Query
Both the relational database engine and Analysis Services provide native support for what kind of programming interfaces?: The common Windows DNA or Win32 data access interfaces, such as ActiveX Data Objects (ADO), OLE DB, and Open Database Connectivity (ODBC).
What is the Index Tuning Wizard?: It analyzes how a SQL statement, or group of statements, uses the existing indexes on a set of tables.
The wizard makes recommendations on index changes that would speed up the SQL statements.

Start Studying!

Deck Info

Number of cards 46