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 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 programming languages

Which library will have the load modules of the IBM utilities?

  1. SYS1.LINKLIB

  2. SYS1.SOTREPROC

  3. SYS1.CATPROC

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

SYS1.LINKLIB is the system library containing load modules (executable programs) for IBM utilities and system programs. SYS1.SVCL (or similar) is for SVC routines, and PROCLIB contains JCL procedure definitions. LINKLIB is where the system looks for executable programs to load and run.

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.

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 fast and flexible indexing for keyword-based queries. It enables efficient searching of text data in character columns, allowing linguistic searches and proximity searches that would be slow with standard LIKE queries.

Multiple choice technology web technology

You want to send Personalized Messages to a group of people. Which SQL Server 2005 services would you use?

  1. Database Mirroring

  2. Integration Services

  3. Notification Services

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

Notification Services in SQL Server 2005 is designed specifically for generating and sending personalized notifications to users based on subscriptions, events, and schedules. Database Mirroring is for high availability, Integration Services is for ETL.