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 architecture
  1. SessionFactory

  2. Session

  3. Transaction

  4. None of the Above.

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

SessionFactory is a thread-safe, immutable object that is created once during application initialization and shared across all threads. It is heavyweight and maintains the configuration, mappings, and connection pool. Session objects are not thread-safe and should be created per thread/request.

Multiple choice technology architecture
  1. Process of monitoring and updating only objects that have changed.

  2. Process of calling the update () and save () methods explicitly.

  3. Process of releasing memory to heap which is no longer accessible from any live thread.

  4. None of the above.

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

Automatic dirty checking is a Hibernate feature that automatically detects changes made to persistent objects within a transaction and synchronizes them with the database during flush/commit. You do not need to call update() or save() explicitly; Hibernate tracks object state automatically.

Multiple choice technology architecture
  1. Hibernate gets initialized when the application starts.

  2. Hibernate gets initialized when one calls first db access Query object.

  3. Hibernate gets initialized when a SessionFactory is created.

  4. Hibernate gets initialized when first session gets created.

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

Hibernate initializes when the SessionFactory is created, typically via Configuration.buildSessionFactory(). This is when Hibernate reads configuration files, builds mappings, and creates the connection pool. Creating individual Sessions happens after initialization, not during it.

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. True

  2. False

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

The statement is incorrect because it says 'Files are the central place' rather than 'The Files resource is the central place.' Files themselves are not the central place - the shared resource container called 'Files' is where you import and store files like HTML documents for use throughout your applications. The distinction is between the storage mechanism (the resource) and the stored items.

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. Notes Storage Facility

  2. Notes Template Facility

  3. Both

  4. None

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

The .NSF extension stands for 'Notes Storage Facility' and is used for standard database files in Lotus Notes/Domino. These files store both the application design elements and user data. Option B is incorrect because .NTF is the extension for template files, not regular databases. NSF files are the runtime databases that users interact with.

Multiple choice technology
  1. Notes Storage Facility

  2. Notes Template Facility

  3. Both

  4. None

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

The .NTF extension specifically stands for 'Notes Template Facility' and is used for template database files in Lotus Notes/Domino. Templates serve as blueprints for creating new databases - they contain design elements but no user data. Option A is incorrect because NSF refers to regular storage facility databases, not templates. NTF files are the master templates from which NSF databases are created.

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.