Database Management Systems

A Typical installation of SQL Server on NT includes the core database engine (MSSQLServer), the SQL Server Agent for automation, and the Microsoft Distributed Transaction Coordinator (MS DTC) for managing transactions across multiple servers.

The msdb database is used by SQL Server Agent for scheduling alerts and jobs, as well as recording history. Master stores system-level info, tempdb stores temporary objects, and model is the template for new databases.

Data Transformation Services (DTS) is the legacy SQL Server 7.0/2000 tool designed specifically for importing, exporting, and transforming data between different formats, such as moving an Access table into a SQL Server database.

To restore the master database, SQL Server must be started in single-user mode using the sqlservr.exe command with the -m option. This prevents other connections from interfering with the restore operation. The master database cannot be restored while SQL Server is running normally.

DataReader provides a read-only, forward-only stream of data from a database, making it ideal for scenarios requiring high-performance sequential access. DataSets (A, B) load entire result sets into memory, which is inefficient when you only need to read data once sequentially.

The DataAdapter uses a Command object to execute SQL queries or stored procedures and retrieve data from the database. The Connection object (A) establishes the database connection, but the Command executes the actual query. DataReader (C) is what gets filled, not what the adapter uses.

Server Side Includes (SSI) is a simple interpreted server-side scripting language. Unlike many web technologies, it has no official W3C standard; different web servers (like Apache or IIS) implement their own variations and sets of directives.

When you end a disconnected session on a Remote Desktop server, the session terminates completely and all resources are freed, making that session slot available for new connections. Applications running in that session are closed. The session does not remain active (C), data is preserved in user profiles not lost (A), and more than just the connection closes (B).

XSLT is a transformation language that can convert XML documents into other formats, including SQL statements. This allows database structures (tables, indexes, views) described in XML to be generated as executable SQL code. It's a common use case for XML-to-database migration and schema generation.

Ordered Categories (ordinal data) can be logically ranked or rated on a scale, such as customer satisfaction (very dissatisfied to very satisfied), performance ratings, or agreement levels. Unlike continuous data with precise measurements, or binary categories with only two values, ordered categories have a clear sequence but the intervals between categories may not be equal.

Data consistency comes from stable measurement systems and consistent procedures, not from using the same inspectors repeatedly. Different trained inspectors following the same documented procedures can produce equally consistent data. Relying on the same inspectors is not necessary and could even introduce bias if that person has consistent measurement habits. Therefore, 'Same inspectors for data collection' is the correct exception.

Attribute data represents categorical or binary outcomes where each observation falls into distinct categories. YES/NO and pass/fail are classic examples of attribute (also called discrete or categorical) data because they have only two possible states. This differs from continuous data which can take any value within a range. Therefore, 'Attribute data' is the correct classification.

Informatica is primarily an ETL (Extract, Transform, Load) tool used for data integration and warehousing. It extracts data from various sources, transforms it according to business rules, and loads it into target systems like data warehouses. Reporting and modeling are separate activities, not the core purpose of Informatica.