character streams

byte streams

Both (A) and (B)

None of the Above

service() method

init() method

constructor for HttpServlet()

None of the Above

out is a PrintStream object

Java support pointers

AWT components are heavy-weight

An abstract class has to be sub-classed

Key based

Freelist

Hash

Index

DB_CREATE_FILE_DEST

DB_CREATE_ONLINE_LOG_n

USER_DUMP_DEST

LOG_ARCHIVE_DEST

SystemException

ApplicationException

Both (A) and (B)

None of the Above

CodeSite

CodePlex

A & B

None of the Above

You need to have the same hardware.

The database you mirror to will be in an unused standby state.

You cannot have automatic failover.

You need to have at minimum three servers.

float

int

byte

double

ServletContext

Servlet mapping

Lifecycle

None of the Above

Transaction Management

Batch Processing

Queue Management

Interval Control

Database Engine Tuning Advisor

SQL Server Configuration Manager

Database Maintenance Plan Wizard

Database Maintenance design surface

Read Committed

Read Uncommitted

Repeatable Read

Serializable

Find the process in System Monitor and select Kill Process.

Find the process in Activity Monitor and select Kill Process.

Find the process in SQL Profiler and select Kill Process.

Find the process in SSRS and select Kill Process.

The user had to have knowledge of the table and index structures.

Navigational data access was far slower than declarative access.

Navigational access languages required the coder to embed their queries inside a procedural language shell.

Navigational languages were far slower then SQL

Use the sys.dm_exec_requests dynamic management view.

Use the sys.dm_exec_sessions dynamic management view.

Use the sys.dm_exec_query_stats dynamic management view.

Use the sys.dm_exec_query_optimizer_info dynamic management view.

Can be updated by end users.

Contains numerous naming conventions and formats.

Organized around important subject areas.

Contains only current data.

A system that is used to run the business in real time and is based on historical data.

A system that is used to run the business in real time and is based on current data.

A system that is used to support decision making and is based on current data.

A system that is used to support decision making and is based on historical data.

Servlet Interface

servlet mapping

Servlet Container

None of the Above

At the beginning

At the end

Where they are programmed

After each READ FOR UPDATE command