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 web technology

What are the different recovery models in SQL Server 2005?

  1. Simple

  2. Bulk Logged

  3. Full

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

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.

Multiple choice technology web technology

What is Full Text Search in SQL Server 2005?

  1. Allows fast and flexible indexing for keyword based query

  2. Provides a message based communication platform

  3. Supports sending Email from the database

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Full Text Search in SQL Server 2005 provides specialized indexing and querying capabilities for text data stored in character columns. It enables fast linguistic searches for words and phrases, supporting features like stemming, thesaurus lookups, and proximity searches. Option B describes Service Broker and option C describes Database Mail, both unrelated features.

Multiple choice technology platforms and products

A company has developed several applications containing mediation flows that utilize the message logger mediation primitive to track request and response messages flowing through their business processes. Which database will contain the messages generated by the mediation flow?

  1. Common Database (WPRCSDB)

  2. Messaging Engine Database (MEDB)

  3. Service Integration Bus Database (SIDB)

  4. Business Process Choreographer Database (BPEDB)
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In WebSphere ESB, the message logger primitive stores messages in the Common Database (WPRCSDB). The other databases serve different purposes: MEDB for the messaging engine, SIDB for service integration bus configuration, and BPEDB for business process choreographer data.

Multiple choice technology platforms and products

An administrator finished installing WebSphere Process Server V6.1 and is preparing to configure the Business Process Choreographer container. The Business Process Choreographer container will be configured via the bpeconfig.jacl script.The database the administrator wants to use is already in use by the company for mission critical processes and confidential company information.The database administrator is ready to configure the database for the Business Process Choreographer container to use, however they are very concerned about giving Business Process Choreographer the authority to create tables in the database.Which action should the WebSphere Process Server administrator take to ensure that the tables are created correctly?

  1. In the Business Process Choreographer Containers datasource configuration, ensure that the Create Tables option has been selected.

  2. Send the sibDDLGenerator to the database administrator to allow the generation of the createSchema.sql script to create the tables.

  3. When running the bpeconfig.jacl, set the -createDB option to no and following completion, supply the database administrator with the generated createSchema.sql script to create the tables.

  4. When running the bpeconfig.jacl, set the -createDB option to no and following completion, use the sibDDLGenerator to generate the createSchema.sql script to supply to the database administrator.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When database administrators restrict table creation permissions, the bpeconfig.jacl script with -createDB option set to 'no' will generate the createSchema.sql script. This script can be given to DBAs to execute tables creation under their authority, maintaining security while ensuring proper schema setup.

Multiple choice technology databases

DMS is what kind of database system?

  1. Network

  2. Hierarchical

  3. Relational

  4. None of These
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

DMS (Data Management System), originally IDMS (Integrated Data Store), is a network database model. In network model databases, records are connected in a many-to-many relationship graph, unlike hierarchical databases which use tree structures.

Multiple choice technology databases

Which command is used to connect to the DMS database in a COBOL program?

  1. Invoke

  2. Impart

  3. Get

  4. Open
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In IDMS (Integrated Database Management System) COBOL programming, the IMPART command is used to establish a connection to the DMS database. This is the standard command for database connectivity in IDMS environments. The other options (Invoke, Get, Open) are not valid commands for this purpose in the DMS COBOL context.

Multiple choice technology

What is data Warehouse?

  1. Structured repository of historic data

  2. Unstructured repository of historic data

  3. Structured repository of current data

  4. Structured repository of forecasted data
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A data warehouse is a structured repository of historic data that is used for analysis and reporting. Unlike operational databases that store current data, data warehouses aggregate historical data from multiple sources in a structured format for decision support.

Multiple choice technology

Datawarehouse and OLAP are one and the same.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Data warehouse and OLAP are not the same. A data warehouse is the structured repository that stores historic data, while OLAP (Online Analytical Processing) is the technology/tools used to analyze and query that data. They are related concepts but distinct - one is storage, the other is analysis methodology.

Multiple choice technology

Is OLAP databases are called decision support systems?

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

OLAP databases are commonly called decision support systems because they enable complex analysis and querying of historical data to support business decision-making. Unlike operational databases for transaction processing, OLAP databases are optimized for analytical queries and reporting.

Multiple choice technology

What is star schema?

  1. A single fact table with one Dimension

  2. A single fact table with N number of Dimension

  3. A single fact table with two Dimension

  4. Any dimensions with extended dimensions
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A star schema consists of a single central fact table connected to multiple dimension tables, forming a star-like structure when visualized. The fact table stores quantitative data, while dimension tables contain descriptive attributes. This differs from snowflake schemas where dimensions are normalized.

Multiple choice technology

What is cube?

  1. physical representation of multidimensional data

  2. virtual representation of multidimensional data

  3. logical representation of multidimensional data

  4. logical representation of three dimensional data
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

An OLAP cube is a logical representation of multidimensional data that enables fast analysis of data across multiple dimensions. While it appears as a multi-dimensional structure to users, the underlying physical storage can be implemented in various ways (relational, specialized formats). The 'logical' term correctly describes this abstraction layer that simplifies complex data navigation.

Multiple choice technology

Which of the following is not an ETL tool?

  1. Ab Initio

  2. Oracle Warehouse Bulider

  3. Data Junction

  4. Microstrategy
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

To answer this question, the user needs to know what an ETL tool is. ETL stands for Extract, Transform, Load, and refers to a type of software that is used to integrate data from multiple sources, transform the data into a consistent format, and then load it into a target system. With this knowledge, we can now evaluate each option:

A. Ab Initio: This is an ETL tool, so it is not the correct answer.

B. Oracle Warehouse Builder: This is an ETL tool, so it is not the correct answer.

C. Data Junction: This is an ETL tool, so it is not the correct answer.

D. Microstrategy: This is not an ETL tool. Microstrategy is a business intelligence and analytics platform that provides a range of data visualization, reporting, and analysis features, but it is not designed for data integration tasks like ETL.

Therefore, the answer is: D. Microstrategy

Multiple choice technology

What are Conformed dimensions?

  1. dimensions which can be used across single Data Marts in combination with multiple facts tables accordingly

  2. dimensions which can be used across multiple Data Marts in combination with multiple facts tables accordingly

  3. dimensions which can be used across single Data Marts in combination with single facts table accordingly

  4. simply other name for dimensions
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Conformed dimensions are standardized dimensions that can be shared across multiple data marts and fact tables, ensuring consistency when analyzing data across different business processes. They're the glue that integrates the enterprise data warehouse.