Backend Web Development Technologies

Hibernate allows programmatic loading of mapping files through the Configuration API using methods like addResource(), addFile(), or addClass(). This provides flexibility beyond the declarative approach in hibernate.cfg.xml.

For caching historical library information retrieved from a database, using the Cache object provides the best performance. The Cache object allows explicit control over what data is cached, duration, and expiration policies. Output cache is for entire page responses, ASP.NET central cache is not a standard term, and client cache relies on browser caching which is less reliable for server-fetched data.

The CompareValidator control is specifically designed to validate that two fields (like password and confirm password) are equal. RequiredFieldValidator checks for non-empty values, RegularExpressionValidator validates patterns, and there is no equals() method on fields - this is a concept from programming, not ASP.NET validation controls.

The CLR (Common Language Runtime) is where .NET code actually executes. It provides services like memory management, security, and JIT compilation. MSIL (Microsoft Intermediate Language) is the compiled code format, CLS (Common Language Specification) defines language interoperability rules, and CTS (Common Type System) defines type system rules - none of these execute code directly.

A DiffGram is an XML format used in ADO.NET that preserves both original and current values of data in a DataSet. This format enables tracking changes made to data since it was last loaded. Option A correctly describes this dual-value preservation capability.

XML serialization in .NET cannot serialize type information, which means polymorphic behavior is lost during serialization. When an object is serialized and then deserialized, it may not retain its original runtime type. This is a key limitation compared to binary serialization.

The code demonstrates Composition - a 'has-a' relationship between classes. Car contains an Engine object (myEngine), and Engine contains an array of Piston objects (myPistons). This is object composition, not inheritance (is-a relationship), delegation (forwarding calls), or polymorphism (same interface different implementations).

In .NET, the garbage collector runs when the application is running low on memory or when a generation (typically generation 0) becomes full. It's not triggered by time elapsed (eliminating A), does not run on fixed intervals (eliminating B), and is not truly random (eliminating D). The CLR manages GC based on memory pressure and allocation patterns.

The ASP.NET Session object encapsulates and maintains the state of a specific client/browser across multiple HTTP requests. Each user session stores unique data (like login state, cart items) keyed by session ID. Application stores global shared state, Request handles incoming HTTP data, Response sends output.

The ASP.NET Application object maintains data shared across all users/sessions in the application. Unlike Session (per-user data), Application state is global - any user can read or write it. Request handles per-request data, Response sends output to client. Application is ideal for global counters, shared configuration, or cache data.

System.Xml is the namespace in .NET that provides XML DOM (Document Object Model) support. It contains classes like XmlDocument, XmlNode, XmlElement for parsing and manipulating XML documents. There is no System.DOM namespace in .NET, and System.Data.Xml is not the primary XML namespace.

System.Xml (same as System.XML - case difference) is the .NET namespace for XML DOM support. This question is a duplicate of 135084 testing the same concept - that XML functionality lives in the System.Xml namespace which provides XmlDocument and related DOM classes.

SQL Server 2005 Notification Services was designed for sending personalized messages to large groups. Database Mirroring is for high availability, and Integration Services is for ETL/data transformation.

When upgrading from SQL Server 7.0 Standard Edition SP4, you can only upgrade to SQL Server 2005 Standard Edition. You cannot directly upgrade to Developer, Express, or Enterprise editions from a Standard edition base.

SQL Server 2005 and later versions fully support renaming databases and database objects using system stored procedures like sp_rename or T-SQL statements, as well as through Management Studio.

The correct tool for running T-SQL queries from command prompt in SQL Server 2005 is sqlcmd, which is not listed among the options. DTUTIL is used for SSIS package utilities, BCP is for bulk data copy operations, and Object Explorer is a GUI component in SQL Server Management Studio.

SQL Server 2005 supports three recovery models: Simple (minimal logging, auto-log truncation), Full (complete transaction logging, point-in-time recovery), and Bulk Logged (minimal logging for bulk operations). Since all three listed options are valid recovery models, 'All of the above' is correct.