A transaction must have the ability to pass four primary tests: atomicity, consistency, insolation and durability.
A.
Distributor
B.
Domain controller
C.
ACID Test
2.
select 2 aggregate functions
A.
COUNT
B.
REVISE TO
C.
MAX
D.
PLAY
3.
Created using SQL server Enterprise Manager, these are broadcasts to administradors of potencial problems using beachmarks or parameters set by the administrator.
A.
Alerts
B.
DB-Library
C.
Disk mirroring
4.
A generation of processors developed and marketed by Digital/Compad Computer Corpotarion
A.
Omega Server
B.
Alpha Server
C.
ANSI
5.
An american organization of business and industry groups thats develops communications and trade standards for the United States.
A.
ANSI
B.
Apple Talk
C.
consistency
6.
The protocol designed for communicating with Macintosh computers. It is one of the protocols supported by SQL Server
A.
Apple Talk
B.
Cache
C.
Code Page
7.
Allows administrators to protect a database with a password. these types of roles do not contain any members(a user is associated with an application role only), and aplication roles are by default inactive..
A.
cursors
B.
application database roles
C.
database(BD)
8.
Part of the ACID test, this "all or nothing test" stipulates that a transaction must complete its run fully or be discontinued and completely rolled back and suspended bt its process
A.
Data Type
B.
Atomicity
C.
Index
9.
A system-supplied data type include: char, varchar,binary, and varbinary.
A.
Batch
B.
Base data type
C.
Binn
10.
A group of SQL statements submitted and executed together
A.
Base Table
B.
cata warehouse
C.
Batch
11.
The simplest of sort methods, it uses ASCII values to distinguish characters based on a preset group of parameters
A.
Binary sort order
B.
Composite index
C.
Fixed memory allocation
12.
A search method that allows the user to employ the use of Boolean operators: and, not, and or.
A.
Candidate Key
B.
Boolean Search
C.
Clustering
13.
A command line utility that allow external sources the ability to paste information into SQL server.
A.
Insolation
B.
Filegroups
C.
Bulk copy program
14.
A buffer that bolds data during an input/ourput (I/O) transfer betwen a disk and the random access memory (RAM)
A.
Cache
B.
Composite index
C.
Data replication
15.
A unique identifier for a row in a table. It can be made up for one or more columns.
A.
Query
B.
Candidate Key
C.
Remote Server
16.
A model in which multiple user workstations connrct to one central serve or many different servers with the intention of sharing information.
A.
durabiility
B.
Log file
C.
client/server model
17.
A technology that allow for recovery from catastrophic network failure.
A.
Clustering
B.
deadlock
C.
Join
18.
Part of the ACID test, this is the property of a transaction that defines how it manages the state of the database over time.
A.
Consistency
B.
Constraint
C.
Select list
19.
A container for the collection of computerized data files that allows users to perform operations on the files, including appending, editing, generating reports, retrieving, and updating.
A.
database management system (DBMS)
B.
database owner (DBO)
C.
GUID
20.
The SQL statements used to define all the objects (components), such as tables, queries,forms and views in a SQL database
A.
DDL
B.
DML
21.
The SQL statements used to select, insert, update and delete data in database objects.
A.
DDL
B.
DML
22.
A database that is structured for query and analysis.It usually contains data that represents an organization's business history
A.
Merge Agent
B.
Data Warehouse
C.
Model Database
23.
Part of the ACID test, this propery refers the to ability of the database to recover if data is left in an inconsistent state
A.
Locks
B.
Heaps
C.
Durability
24.
Defined at the database level, they exist within each database. In order to be added and granted access to a database, a user must have either an NT login account or a SQL login account.
A.
Fixed database role
B.
Fixed memory allocation
C.
Multipublisher
25.
The columm or columns whose values match the primary key in the same or another table. It does not have to be unique
A.
Object permission
B.
Jobs
C.
Foreign Key
26.
A database object that can speed up queries by looking up the data by key values instead of having to scan the entire table
A.
Intent Locks
B.
Batch
C.
Index
27.
Part of the ACID test, this property defins the level of exposure that data modifications in the current transaction will have to other transactions
A.
Master Server
B.
Insolation
C.
Nonclustered index
28.
A query that allows users to retrieve data from multiple tables based on logical relationships
A.
Locks
B.
Jobs
C.
Join
29.
Peripheral hardware machine, typically hard disks and tape drives, that allow for physical backup of mission-critical data.
A.
Query optimizer
B.
Roles
C.
Physical devices
30.
A column or columns that uniquely identify one row from any other row in a table
A.
Row
B.
Primary Key
C.
Single Publisher
31.
The Microsotf technology that automatically copies data to multiple locations and can restore and/or move it to multiple locations.
A.
Replication Technology
B.
Restoration time
C.
Scalability
32.
The capability to expand to meet future needs ( in other words, to upgrade) it is a characteristic of both software and hardware
A.
Showplan
B.
Scalability
C.
Spin Counter Option
33.
The complete copy and replication of all data that currently exists on the server
A.
Server Backup
B.
Snapshot Replication
C.
System Administrator
34.
Installed in a typical SQL Server installation, this tool allows for periodic scheaduling of server jobs. It can be configured to respond on demand to activities raised by alerts
A.
TerraServer
B.
SQL Server Enterprise Manager
C.
SQL Server Agent
35.
A graphical user interface used to manage and control useers and processes on database running under Microsoft SQL server
A.
Structure Query Language
B.
SQL Server Enterprise Manager
C.
Subquery
36.
Developed by IBM in the 1970, it is a language to retrieve information from database
A.
Transact-SQL
B.
Structured Query Language (SQL)
C.
Trigger
37.
A collection of data that is stored in multiple row and columns
A.
Table
B.
Thread
C.
Database
38.
An industry standard suite of protocols designed for local and wide area networking Widely used for internet communication
A.
SQL Server Profile
B.
Terra Server
C.
TCP/IP
39.
The standard language used for communication between applications and SQL Server. It allows users to access the database and create and modify the data.
A.
Transact-SQL
B.
System Catalog
C.
SQL Mail
40.
Is the smallest logical unit of work for the database all actions that occur on the database breack down in one or more. Consist of the four properties callled the ACID properties.
A.
Table
B.
Transaction
C.
Index
41.
A stored procedure that runs when data in a specific table is modified such as with an update, delete,or insert.
A.
Replication Technology
B.
Heaps
C.
Trigger
42.
Defines a set of numbers, letters, and symbols that SQL Server recognizes in the nchar, nvarchar and ntext data types.
A.
DDL
B.
Unicode
C.
Trigger
43.
A data structure within a table that contain the complete set of columns. It is called a record traditional programming
A.
Row
B.
Table
C.
Model Database
44.
A critical point in data recovery. It is the point ar which the network crashed.
A.
Point-of-failure
B.
Port number
C.
Candidate key
45.
A set of standardized rules that multiple entities agree to abide by Computers need standard set of procedures in order to manage the data packets they send and receive.
A.
Replication Technology
B.
Protocol
C.
Durability
46.
A computer that provides shared resources to network users.
A.
Server
B.
Scalability
C.
Single Publisher
47.
Microsoft SQL Serer maintains its own security log by requiring the user to authenticate to access the database.
A.
Statement Permission
B.
Standard Security Model
C.
System Administrator
48.
A SQL server on the network that can be accessed from a user's local server
A.
Remote Server
B.
Scalability
C.
Spin Counter Option
49.
Granted at the database level, this account allows for complete access to the database all its objects
