Computer Knowledge

Database Management Systems

5,344 Questions

Database Management Systems (DBMS) form the core framework for data storage, retrieval, and security in modern software applications. Concepts such as the E-R model, backup planning, SQL integration, and big data architecture are essential for computer knowledge sections. This hub offers a comprehensive set of practice questions to master DBMS fundamentals and advanced database operations.

E-R Model ConceptsBackup and RecoverySQL Server UpgradesJDBC and ODBCBig Data CharacteristicsData VirtualizationOracle Database

Database Management Systems Questions

Multiple choice technology programming languages
  1. [ServiceContract(Namespace = "http://Microsoft.ServiceModel.Samples", SessionMode=SessionMode.Required)] public interface ICalculator{ [OperationContract] double AddTo(double n); }

  2. [ServiceBehavior(InstanceContextMode = InstanceContextMode.PerSession)] public class CalculatorService : ICalculator { double result = 0.0D; public double AddTo(double n) { return result+=n; } }

  3. a and b both

  4. None of the above

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Enabling sessions in WCF requires both: (1) marking the service contract with SessionMode.Required, and (2) setting InstanceContextMode to PerSession in the ServiceBehavior. Option A shows the contract requirement, Option B shows the service behavior - both are necessary.

Multiple choice technology programming languages
  1. [ServiceContract] interface IStock { [OperationContract] [WebGet] int GetStock(string StockId); }

  2. [ServiceContract] interface IStock { [OperationContract] [WebInvoke] int GetStock(string StockId); }

  3. a and b

  4. None

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

WCF REST services are created by adding WebGet (for HTTP GET) or WebInvoke (for other HTTP methods) attributes to operation contracts. Both approaches are valid for creating RESTful services.

Multiple choice technology programming languages
  1. Use a BasicHttpBinding binding with the security mode set to Message

  2. Use a BasicHttpBinding binding with the security mode set to TransportWithMessageCredential

  3. Use a WSFederationHttpBinding binding with the security mode set to Message

  4. Use a WSFederationHttpBinding binding with the security mode set to TransportWithMessageCredential

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

WSFederationHttpBinding with Message security is the correct choice for STS-based token authentication when SSL/TLS is not available. This binding is specifically designed for federated security scenarios where a Security Token Service issues tokens. TransportWithMessageCredential requires SSL transport security, which the scenario explicitly states clients cannot use.

Multiple choice technology programming languages
  1. <windows allowedImpersonationLevel="Delegation"/>

  2. <windows allowedImpersonationLevel="Impersonation"/>

  3. <windows allowedImpersonationLevel="Identification"/>

  4. <windows allowedImpersonationLevel="Impersonation" allowNtlm="false"/>

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Delegation is required when the WCF service needs to access remote resources on behalf of the client (multi-hop scenario). Impersonation only allows accessing local resources on the service machine. Identification allows the service to identify the client but cannot impersonate at all.

Multiple choice technology programming languages
  1. basicHttpbinding

  2. wsDualHttpBinding

  3. wsHttpHttpBinding

  4. netTcpBinding

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Windows Communication Foundation (WCF), the wsDualHttpBinding is designed specifically to support dual-way communication, which inherently requires and supports reliable sessions by default. BasicHttpBinding does not support reliable messaging by default, and netTcpBinding supports reliable sessions but requires explicit configuration or different defaults depending on context.

Multiple choice technology programming languages
  1. basicHttpBinding

  2. netTcpBinding

  3. netNamedPipeBinding

  4. wsDualHttpBinding

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

wsDualHttpBinding does not support streaming because it uses HTTP for both request and response channels, and HTTP is inherently message-based (no streaming). TCP and named pipe protocols (netTcpBinding, netNamedPipeBinding) support streaming. basicHttpBinding can support streaming with appropriate transferMode settings.

Multiple choice technology programming languages
  1. System.Service

  2. System.Data

  3. System.ServiceModel

  4. System.Web

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The System.ServiceModel namespace contains the core classes, interfaces, and structures required to build and consume WCF service clients and hosts. Namespaces like System.Web, System.Data, and System.Service do not contain these WCF-specific constructs.

Multiple choice technology programming languages
  1. IDispatchMessageInspector

  2. IAttachMessageInspector

  3. IlogMessageInspector

  4. IMessageInspector

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

IDispatchMessageInspector is the service-side interface for message inspection and logging. It provides AfterReceiveRequest (inspect incoming messages) and BeforeSendReply (inspect outgoing responses) methods. IClientMessageInspector is the client-side equivalent.

Multiple choice technology programming languages
  1. Simple Server Topology

  2. Complex server Topology

  3. Moderate server topology

  4. Hybrid Topology

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Complex server topology in TFS uses multiple servers configured in clusters or failover arrangements to host both the data tier (databases) and application tier (TFS application servers). This provides high availability and redundancy - if one server fails, another takes over. Simple topology uses a single server, while moderate separates data and application tiers without clustering.

Multiple choice technology databases
  1. AMP stores and retrieves data using the file system

  2. AMP parses the SQL to determine the type and validity

  3. AMP sorts and formats the output

  4. AMP environment is a Shared Nothing Architecture

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In a Teradata database system, parsing SQL, verifying validity, and optimization are done by the Parsing Engine (PE), not the Access Module Processor (AMP). The AMP is responsible for database operations like storing, retrieving, sorting, and formatting data on its own disk.

Multiple choice technology databases
  1. Perm space can be dynamically modified.

  2. All Perm space specifications are subtracted from the immediate owner or parent.

  3. Perm space currently unused is available to be used as Spool or Temp space.

  4. Perm space is only used for tables and stored procedures.

  5. Volatile Temporary tables and “derived” tables utilize Perm space.

Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Explanation

Perm space in database systems has four key characteristics: (1) it can be dynamically modified to accommodate growing data needs, (2) specifications are subtracted from the immediate parent/owner in the space hierarchy, (3) unused perm space is available for spool or temp operations, and (4) it's used for permanent objects like tables and stored procedures. Volatile tables use temp space, not perm space.

Multiple choice technology mainframe
  1. DB2

  2. ORACLE

  3. Z OS/DB2

  4. MVS DB2

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

DB2 is IBM's proprietary relational database management system, designed specifically to exploit IBM hardware and system architectures. While Oracle can run on IBM systems, DB2 is optimized for and integrated with IBM's hardware platforms like mainframes (z/OS), Power Systems, and AIX. The other options are variants of DB2 on IBM systems, but the general answer is DB2 itself.

Multiple choice technology databases
  1. Mapplets

  2. Sessions

  3. Transformations

  4. Workflows

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A mapping in Informatica PowerCenter must include transformations to process and route data from sources to targets. Transformations define the data manipulation logic (filtering, joining, aggregating, etc.). Mapplets are optional reusable components, while Sessions and Workflows are execution components that manage runtime - they are not part of the mapping structure itself.

Multiple choice technology platforms and products
  1. farms

  2. web applications

  3. site collections

  4. web parts

  5. web sites

  6. sites

Reveal answer Fill a bubble to check yourself
A,B,C,F Correct answer
Explanation

WSS 3.0 hierarchy is: Farms (top-level server grouping) → Web Applications (IIS websites) → Site Collections (logical grouping) → Sites (actual team sites). 'Web parts' are components placed on pages, not a hierarchy level. 'Web sites' (option E) is ambiguous - the correct term in the hierarchy is 'sites' (option F), and web applications already represent the IIS web site level.

Multiple choice technology platforms and products
  1. Document Libraries

  2. Webparts

  3. Farms

  4. Lists

  5. Workflows

  6. Business Data Applications

Reveal answer Fill a bubble to check yourself
A,B,D,E,F Correct answer
Explanation

MOSS 2007 (Microsoft Office SharePoint Server) provides Document Libraries, Webparts, Lists, Workflows, and Business Data Applications as core application services. These are all valid components of SharePoint's service architecture. Farms (option C) refer to the deployment topology, not an application service - it's the infrastructure level, not a user-facing service.