Computer Knowledge

Database Management Systems

5,543 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 mainframe
  1. Field for Length

  2. Field for Attribute

  3. Field for Modified Data Identification

  4. Field for Input/Output Data

  5. All of the above

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

In a CICS BMS symbolic map, multiple variable levels are generated for each field: suffix L for length, A for attribute, F for flag/modified data, and I/O for input/output data. Since all these components are generated, 'All of the above' is the correct answer.

Multiple choice technology architecture
  1. Value Objects Layer.

  2. Presentation Layer.

  3. Data access object layer.

  4. Deployment Layer.

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

The Data Access Object (DAO) layer is specifically responsible for managing CRUD operations (Create, Read, Update, Delete) on stored data. It provides an abstraction interface between the application and persistent storage. Value Objects carry data, Presentation Layer handles display, and Deployment Layer manages infrastructure - only DAO handles data persistence operations.

Multiple choice technology
  1. Shared resoruces contain design elements that can be shared among databases

  2. contain images, files

  3. contain applets, style sheets

  4. All of the above

  5. None

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

Shared resources in Domino Designer contain various design elements that can be shared across databases, including images, files, applets, and style sheets. This allows for consistency and reusability across multiple applications within an organization. Option D correctly encompasses all the individual types of shared resources listed in options A, B, and C.

Multiple choice technology
  1. True

  2. False

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

The statement as written is grammatically incorrect because it states 'Images are the central place' rather than identifying the shared resource container called 'Images' as the central place. While the Images shared resource is indeed where images are imported and stored for database-wide use, the phrasing makes the statement technically false as written.

Multiple choice technology
  1. Using an existing template

  2. Using an existing database

  3. Creating a new/blank database

  4. All of these

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

All three methods are valid ways to create a database in Domino: using an existing template as a starting point, copying from an existing database, or creating a completely new blank database from scratch. Each approach serves different needs - templates provide pre-built structure, existing databases preserve design and data, and blank databases offer complete flexibility.

Multiple choice technology
  1. 1

  2. 2

  3. 5

  4. 3

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

Siebel supports two primary types of data model extensions: 1) Extension tables that add columns to existing base tables, and 2) Custom extension tables (1:1 or 1:M) for new data. This is a fundamental Siebel architecture concept.

Multiple choice technology
  1. One Base Table

  2. EIM Tables

  3. Extension Tables

  4. More than one base table

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

User data is stored in base tables. While complex entities may span multiple base tables joined by relationships, and extension tables store additional attributes, the fundamental storage unit is the base table. 'More than one base table' correctly reflects that user data can span multiple base tables for complex entities.

Multiple choice technology
  1. External Data

  2. Seed Data

  3. Repository Data

  4. None

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

Interface tables (EIM tables) are designed to temporarily hold external data being imported into Siebel. They act as a staging area where external data is loaded before EIM processes and moves it into base tables. They don't store seed data (built-in reference data) or repository data (metadata).

Multiple choice technology
  1. One Base table

  2. EIM Tables

  3. Extension tables

  4. More than one base table

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

In Siebel applications (or similar database systems), user data is stored across multiple base tables rather than a single table. This normalized database design allows efficient data management and relationships. Option D 'More than one base table' correctly represents this multi-table architecture.

Multiple choice technology
  1. List of documents in a database

  2. place holder for entering the data

  3. Place holder for viewing the data from the database

  4. Both a&c

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

A view in database systems (like Lotus Notes) displays a list of documents/records from the database. It serves as a placeholder/interface for viewing data. Option D combines both the definition (list of documents) and function (viewing data), making it the most complete answer.

Multiple choice technology
  1. Place holder for entering information in a database

  2. Framework for entering and storing information in a database

  3. Both a&b

  4. none of these

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

A form serves as both the interface placeholder for entering information AND the structural framework for storing that information in a database. Option C correctly combines both aspects - it's where you enter data (placeholder) and the system that stores it (framework).