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 packaged enterprise solutions

Business Services uses

  1. Value objects

  2. Light Weight Data Objects

  3. Both a and b

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

Business Services use Value Objects to transfer data between layers efficiently. Value Objects encapsulate related data into a single object, reducing the number of method calls and network overhead in distributed systems. This is a standard pattern in EJB and enterprise application architecture for data transfer.

Multiple choice technology packaged enterprise solutions

What is the Database product name that BOM uses for persistence?

  1. IBM DB2 UDB

  2. Oracle

  3. Microsoft SQL server

  4. DBM
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

BOM uses IBM DB2 UDB (Universal Database) for persistence. DB2 is IBM's enterprise relational database, commonly used in enterprise Java applications, especially in financial services. Oracle and SQL Server are competing products, while DBM is not a standard database product name.

Multiple choice technology

In genesys, the file connectionpool.properties is used to

  1. make the connection to the network.

  2. determine how to access data on an Oracle database

  3. which defines what event needs to be called for the given request.

  4. specifies the environment in which the current system is in.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The connectionpool.properties file in Genesys configures database connectivity - it specifies JDBC drivers, connection URLs, credentials, and pool parameters for accessing databases like Oracle. Option A is incorrect as it's about database connectivity, not network connections. Option C describes event mapping (typically in Event.xml), and option D refers to environment properties files.

Multiple choice technology

The SQL’s that are executed are stored in ----------

  1. Cabinet.xml

  2. Event.xml

  3. Input.xml

  4. Output.xml
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Genesys, Cabinet.xml is the configuration file where SQL queries and statements that need to be executed are stored and defined. Event.xml maps events to handlers, Input.xml defines request structures, and Output.xml defines response formats. The Cabinet provides centralized SQL management for the application.

Multiple choice technology

The database configuration properties have to specified in ------------------

  1. lookup files

  2. database.properties

  3. connectionpool.properties

  4. rulebase.properties
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Database configuration properties in Genesys must be specified in connectionpool.properties, which defines JDBC connection settings, database credentials, and pool parameters. Option B (database.properties) is not the standard Genesys convention. Lookup files contain reference data mappings, and rulebase.properties define business rules.

Multiple choice technology

Typically, data flows from one or more online transaction processing (OLTP) databases into a data warehouse on a monthly, weekly, or daily basis.

  1. True

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

Data warehouses typically receive periodic updates from OLTP systems on monthly, weekly, or daily schedules. This batch pattern separates operational workload from analytical processing and maintains historical snapshots for trend analysis.

Multiple choice technology

why we need data ware housing?

  1. In OLTP approach, historical data was archived to update the recent information in the system and even it is bit difficult to update that information everywhere in OLTP. Unlike OLTP; DW stores historical data to compare trends over period of time.

  2. As it has one DB at the end, number of sources can be used to transfer data and sources cab be relational DB, Flat File, Unix file. ETL tool handles these source files to transfer data from source to target.

  3. DW stores the necessary data for specific analysis; not jus all data.

  4. DW is commonly used by organizations to analyze trends over time.
Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Explanation

Data warehousing addresses four key needs: (A) preserving historical data for trend comparison unlike OLTP which archives, (B) consolidating data from multiple sources via ETL tools, (C) storing only relevant data for analysis rather than everything, and (D) enabling trend analysis over time. All four options correctly describe data warehouse benefits.

Multiple choice technology embedded technologies

Which of below is part of sync in FTC

  1. Database

  2. Transaction Server

  3. NTP

  4. Clock Distribution
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Database synchronization is a core component of Fault-Tolerant Computing (FTC) systems, ensuring data consistency across redundant nodes. While NTP and clock distribution support time synchronization, the database itself is what needs to be synchronized.

Multiple choice technology embedded technologies

Which of below is part of sync in FTC

  1. Database

  2. Transaction Server

  3. NTP

  4. Clock Distribution
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Database is a key component of synchronization in Fault-Tolerant Computing systems, ensuring data consistency across redundant components. The database must be synchronized to maintain integrity during failover scenarios.

Multiple choice technology packaged enterprise solutions

Application Engine offers you an alternative to writing __________ or _______ programs for background SQL processing.

  1. COBOL

  2. SQR

  3. Both

  4. None
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Application Engine provides an alternative to traditional COBOL or SQR programs for background SQL processing. The 'Both' option correctly indicates that it replaces both COBOL and SQR, which were commonly used for batch processing and reporting.

Multiple choice technology packaged enterprise solutions

Application Engine programs can be used for:

  1. row-by-row processing

  2. set-based processing

  3. SQL statements

  4. both 1 and 2
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Application Engine programs support both row-by-row processing (option 1) and set-based processing (option 2), making 'both 1 and 2' the correct answer. Set-based processing is generally preferred for performance, while row-by-row is used when business logic requires it. SQL statements are used within both approaches but are not a processing method themselves.

Multiple choice technology web technology

mysql_connect( ) does not take following parameter

  1. database host

  2. user ID

  3. password

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

mysql_connect() takes three parameters: hostname, username, and password. It does NOT take database name as a parameter - you must select the database separately using mysql_select_db(). Options A, B, and C are all valid parameters. Option D is correct because database name is NOT a parameter of mysql_connect().

Multiple choice technology databases

MYISAM is the default mysql search engine?

  1. True

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

MYISAM was indeed the default storage engine in MySQL versions prior to 5.5. From MySQL 5.5 onwards, InnoDB became the default. For the era when this question was written, the answer 'True' is correct. Note that the question uses 'search engine' which is imprecise terminology - it should be 'storage engine'.

Multiple choice technology web technology

DBMS Full form

  1. Data Base Management Software

  2. Database Management System

  3. Database Business Management System

  4. Database Business Management Software
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

DBMS stands for Database Management System, software that manages databases. Option A incorrectly splits 'Database' into two words and uses 'Software' instead of 'System.' Options C and D incorrectly insert 'Business,' which is not part of the standard acronym.