Database Management Systems

Limiting attributes returned by the adapter reduces processing overhead and improves performance. Server-side sorting is not a performance lever for reconciliation. Decreasing duration might cause incomplete reconciliations. SearchALUnusedTimeout is unrelated to this performance issue.

Database unit tests in VSTT are designed to test programmable database objects like Stored Procedures (SPs), functions, and triggers because these contain business logic that can be validated through testing. DDL statements (CREATE, ALTER, DROP) define database structure and are typically tested through integration or schema tests, while DML statements (INSERT, UPDATE, DELETE) are data operations that are better tested at a higher level.

Stored procedures can execute DDL commands and create various database objects. While stored procedures can technically create views, defaults, and extended procedures, creating indexes within stored procedures is particularly common for maintenance tasks, performance optimization, and automated index management operations.

sp_configure 'allow updates' was a valid configuration parameter in older SQL Server versions, controlling whether users could directly update system tables. This option has been deprecated and removed in modern SQL Server versions for security reasons. The other options (locking, Setup, no of lock) are not valid sp_configure parameter names.

DELETE is a logged operation that can be rolled back because it writes entries to the transaction log. TRUNCATE is minimally logged and cannot be rolled back. DELETE ALL and REMOVE are not standard SQL commands.

A many-to-many relationship requires three tables: two entity tables plus a junction table that stores foreign key references to both. This intermediate table breaks the M:M relationship into two 1:M relationships.

LINQ (Language Integrated Query) is the unified programming model for querying objects, databases, and XML in .NET. The other options are Microsoft code names: Rosario (future Team System), Orcas (VS 2008), Yukon (SQL Server 2005). Only LINQ is the actual technology name for query integration across data sources.

Oracle Adaptive Access Manager supports multiple integration patterns: Native (direct SDK integration), Universal Installation Option (drop-in authentication), Access Management Integration (with Oracle Access Manager), and SAML Integration (federated identity).

Oracle Adaptive Access Manager supports database schemas for both Oracle Database and Microsoft SQL Server, allowing organizations to choose their preferred database platform for deployment.

SharePoint requires all three components: .NET Framework for the application runtime, SQL Server for the content database, and a Windows Server operating system as it cannot run on client Windows versions.

List data in SharePoint can be reused in two primary ways: as a lookup field in another list column, and programmatically through the object model or APIs. Lookup fields create relationships between lists, while programmatic access allows custom solutions to retrieve and manipulate list data. Options A and B are each partially correct, making C the complete answer.

hibernate.cfg.xml configures DTD references, JDBC connection settings (url, driver, credentials), the SQL Dialect, and mapping files. It does not contain tags specifying the physical size of the database on disk.

A shelveset in TFS allows you to store your pending changes on the server without committing them to the source control repository. This is useful for: (1) saving work-in-progress to share with others for code review, (2) switching to another task, or (3) getting a clean workspace for build. Changesets are permanent commits, and check-ins finalize changes.

ON OVERFLOW is an exception handling clause used in procedure division statements like ARITHMETIC verbs, not in data item definitions. PICTURE, VALUE, and USAGE are all valid data clause definitions in the DATA DIVISION.