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 testing

What does the source property of a database checkpoint object represent?

  1. A. The SQL query

  2. B. The identification number of the database

  3. C. The number of rows returned from the query

  4. D. The connectionstring used to connect to the database
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Source property of a database checkpoint contains the SQL query that retrieves data for comparison. This query defines which data to fetch from the database for checkpoint validation. The connection string is in ConnectionString property, and the number of rows or ID are not represented by Source.

Multiple choice technology testing

What is the first thing that must be defined in a Recovery Scenario?

  1. A. Trigger

  2. B. Recovery Operation

  3. C. Recovery Scenario Name

  4. D. The Function used in the scenario
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In QTP/UFT Recovery Scenarios, the Trigger must be defined first as it specifies the event that activates the recovery scenario (e.g., a popup window appears or an application crash). Only after defining the trigger can you specify the recovery operations and other settings. The Recovery Scenario Name and Function definitions come after the trigger is established.

Multiple choice technology testing

What are the two most commonly used ADO objects?

  1. A. Fields

  2. B. Execute

  3. C. Connection, RecordSet

  4. D. Open, ConnectionString
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

ADO (ActiveX Data Objects) uses Connection objects to establish database connectivity and Recordset objects to manipulate and query the returned data. These two objects form the foundation of ADO database operations - you first connect, then work with recordsets to read or modify data. Fields is a property of Recordset, Execute is a method, and Open/ConnectionString are properties/methods of Connection, not standalone objects.

Multiple choice technology testing

What are the two most commonly used ADO objects?

  1. A. Fields

  2. B. Execute

  3. C. Connection, RecordSet

  4. D. Open, ConnectionString
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

ADO (ActiveX Data Objects) uses Connection objects to establish database connectivity and Recordset objects to manipulate and query the returned data. These two objects form the foundation of ADO database operations - you first connect, then work with recordsets to read or modify data. Fields is a property of Recordset, Execute is a method, and Open/ConnectionString are properties/methods of Connection, not standalone objects.

Multiple choice technology programming languages

SQL was first developed by ?

  1. IBM

  2. Oracle

  3. Sybase

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

IBM developed SQL in the 1970s at their San Jose Research Laboratory (now IBM Almaden). The language was originally called SEQUEL (Structured English Query Language) for System R, IBM's pioneering relational database project. Oracle (then Relational Software) was the first commercial vendor in 1979, but IBM originated the language.

Multiple choice technology storage

Rebooting a Data Mover involves un-mounting and mounting filesystems that often consumes the majority of reboot time (more than three minutes), depending on the complexity of the configuration. A Data Mover reboot procedure that optimizes these two steps will reduce the overall reboot time including disruptions during upgrades (reboot) and recovery from fatal hardware and software events (failover or reboot for single DM).

  1. Fast Mount

  2. Slow Mount

  3. Mount

  4. All the Above
Reveal answer Fill a bubble to check yourself
D Correct answer
Multiple choice technology platforms and products

The New object Relational Mapping (ORM) framework introduced with .NET 3.5 SP1 is known as

  1. ADO.ORM

  2. ADO.NET Entity Framework

  3. ADO.EDM

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

ADO.NET Entity Framework is the ORM framework introduced with .NET 3.5 SP1. It provides object-relational mapping capabilities allowing developers to work with relational data as domain-specific objects. ADO.ORM and ADO.EDM are not actual framework names, and ORM.ADO is in the wrong order.

Multiple choice technology platforms and products

.NET Framework 3.5 Language Integrated Query (LINQ) supports all the listed providers except

  1. LINQ to Objects

  2. LINQ to XML

  3. LINQ to ORACLE

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

LINQ in .NET Framework 3.5 supports LINQ to Objects (in-memory collections), LINQ to XML (XML documents), and LINQ to SQL (SQL Server databases). LINQ to ORACLE is NOT a built-in LINQ provider in .NET 3.5 - Oracle data access requires third-party providers or Entity Framework.

Multiple choice technology programming languages

Which of the statement below does not correctly defines the difference between JDBC and ODBC ?

  1. ODBC can be directly used with Java because it uses a C interface

  2. ODBC makes uses of pointers which has been totally removed from JAVA

  3. ODBC is from Microsoft while JDBC is from java applications

  4. ODBC requires manual installation of the ODBC driver manager and driver on all client machines. While for JDBC driver are written in Java and JDBC code is automatically installable, secure and portable on all platforms.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

ODBC cannot be directly used with Java because ODBC uses a C interface with pointers, which Java does not support. JDBC was created specifically to provide a pure Java interface for database connectivity, avoiding the pointer issues inherent in ODBC's C-based design.

Multiple choice technology mainframe

How can we check whether DB2 environment is available for use ?

  1. "SUBCOM DSNDB2"

  2. "ADDRESS DSNREXX"

  3. "SUBCOM DSNREXX"

  4. "ADDRESS DSNDB2"
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This question is DB2-mainframe specific. The SUBCOM command checks if a subsystem (like DSNREXX for DB2) is available for use. Option C ('SUBCOM DSNREXX') is the correct command to verify DB2 environment availability in a mainframe context. The other options either use incorrect command names or incorrect syntax.

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, no log backups), Full (complete logging, point-in-time recovery), and Bulk-logged (minimal logging for bulk operations). Since all three listed options (Simple, Bulk Logged, Full) are valid recovery models, 'All of the above' is the correct answer.