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 databases

In oracle 10g, which statement is true about the analysis of the Automatic Database Diagnostic Monitor (ADDM)?

  1. The analysis tool doesn’t provide output for the performance of SQL statement

  2. The results of analysis are stored in tables, belonging to SYS user in the SYSAUX tablespace.

  3. The results of analysis are stored in tables, belonging to SYS user in the SYSTEM tablespace.

  4. The analysis runs automatically after each Automatic Workload Repository (AWR) snapshot.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

ADDM (Automatic Database Diagnostic Monitor) runs automatically after each AWR snapshot is taken, analyzing the performance data between snapshots. The results are stored in the SYSAUX tablespace (not SYSTEM), in tables owned by the SYS user. ADDM provides comprehensive analysis including SQL statement performance recommendations.

Multiple choice technology databases

In oracle 10g, which statement regarding the usage of redo log file during instance recovery is true?

  1. Transactions are rolled back using redo log files.

  2. Transactions are rolled forward using redo log files.

  3. Transactions are rolled back using redo log files and archived log files.

  4. Transactions are rolled forward using redo log files and rolled back using redo log files
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

During instance recovery, Oracle uses redo log files to roll forward (reapply) all committed and uncommitted changes. Uncommitted transactions are subsequently rolled back using undo data, not redo logs.

Multiple choice technology databases

You have determined that the archiving was not successful in on of the destinators. You want to check the alert log file for more information on this. Which initialization parameter gives you the location of the alert log file?

  1. USER_DUMP_DEST

  2. CORE_DUMP_DEST

  3. ALERT_LOG_DEST

  4. BACKGROUND_DUMP_DEST

  5. ALERT_DUMP_DEST
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The BACKGROUND_DUMP_DEST initialization parameter specifies the directory location for background process trace files, including the alert log (alert_.log). The alert log contains diagnostic information about database operations, errors, and archiving issues. USER_DUMP_DEST is for server process traces, CORE_DUMP_DEST for core dumps.

Multiple choice technology databases

You want to administer your database servers, which are running on different host machines using the web enabled grid control interface. You have configured the agent in the host machines. You have started Oracle database10g grid control utility on your machine. Which two additional components would you configure to achieve this objective?

  1. Application server control.

  2. Oracle Management service.

  3. Oracle enterprise manager repository.

  4. Oracle enterprise manager database control.
Reveal answer Fill a bubble to check yourself
C,D Correct answer
Multiple choice technology databases

Your database is in NOARCHIEVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case?

  1. Hot backup

  2. Online backup

  3. Consistent backup

  4. Incremental backup

  5. Inconsistent backup
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In NOARCHIVELOG mode, you cannot perform hot (online) backups because the database must be shut down cleanly to ensure a consistent backup. A consistent backup requires the database to be closed with all changes written to disk (consistent state). Hot/incremental backups require ARCHIVELOG mode to apply archived logs during recovery.

Multiple choice technology databases

You have enabled tracking while creating a listener to your database. What additional information is available to you when you enable tracking?

  1. Information about each oracle Net connection.

  2. Information about each entry in the Listener.ora file

  3. Information about the changes done in the database.

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

When listener tracking is enabled, the listener logs detailed information about each Oracle Net connection attempt, including client network address, connection timestamp, and any errors encountered. This helps in troubleshooting connectivity issues. It does not track Listener.ora changes (that's static configuration) or database DDL changes.

Multiple choice technology databases

Your database is opened in NOARCHIVELOG mode. You decide to place the database in ARCHIEVELOG mode. How would you do this? ( Choose two)

  1. Execute the ALTER DATABASE ARCHIVELOG statement

  2. Select ARCHIVELOG option in database control and restart the database to apply the changes.

  3. Shutdown and restart the instance, and in NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.

  4. Shutdown and restart the instance mount the database and execute the ALTER DATABASE ARCHIVELOG statement.
Reveal answer Fill a bubble to check yourself
B,D Correct answer
Explanation

To enable ARCHIVELOG mode, the database must be in MOUNT state (not open or NOMOUNT). You can: 1) Use Database Control to select ARCHIVELOG mode and restart (option B), or 2) Manually shutdown, mount with STARTUP MOUNT, execute ALTER DATABASE ARCHIVELOG, then open. Option C is wrong because NOMOUNT doesn't access control files, and option A is incomplete without the mount state requirement.

Multiple choice technology databases

Suppose you are using three databases, DB01, DB02, and DB03 on different host machines in development environment. The database server configuration such as server IP address and listener Port number changes frequently due to development requirements. And you have the task of notifying the developers of the changes. Which connection method would you use to overcome the overhead?

  1. Host naming

  2. Local naming

  3. Easy Connect

  4. External naming

  5. Directory naming
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Directory naming centralizes database service name resolution in an LDAP-compliant directory server (like Oracle Internet Directory). When IP addresses or ports change, they only need to be updated in the directory, eliminating client-side configuration overhead.

Multiple choice technology databases

Suppose you are working in a test database where instance recovery takes a considerable amount of time. How can reduce the recovery time? (Choose two)

  1. By multiplexing the control files.

  2. By multiplexing the redo log files.

  3. By decreasing the size of redo log files.

  4. By configuring the Mean Time Recover (MTTR) to a lower value.

  5. By setting UNDO_RETENTION parameter to a higher value.
Reveal answer Fill a bubble to check yourself
C,D Correct answer
Explanation

Instance recovery time depends on the amount of redo to apply since the last checkpoint. Reducing redo log file size (C) causes more frequent checkpoints, leaving less redo to apply. Configuring FAST_START_MTTR_TARGET to a lower value (D) tells Oracle to recover faster by advancing checkpoints more aggressively. Multiplexing files (A, B) improves availability but not recovery speed. UNDO_RETENTION affects undo, not redo recovery.

Multiple choice technology databases

An enhancement in Oracle Database 10g Release 2 is that Enterprise manager computes statistical alert threshold using either static ( user-defined) or dynamic ( self- adjusting) baseline.

  1. True

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

Oracle Database 10g Release 2 introduced dynamic baselines for alert thresholds in Enterprise Manager. This allowed automatic adjustment of thresholds based on historical performance patterns, complementing the existing static user-defined thresholds.

Multiple choice technology programming languages

The interface used to connect the program to the Database in IMS is

  1. ACB

  2. DLI

  3. BMP

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

To answer the question, the user needs to know the basic concepts of IMS, including the different interfaces used to connect the program to the Database in IMS.

Each option is explained below:

A. MPP: This option stands for Message Processing Program, which is not the correct interface used to connect the program to the Database in IMS.

B. ACB: This option stands for Access Control Block, which is not the correct interface used to connect the program to the Database in IMS.

C. DLI: This option stands for Data Language Interface, which is the correct interface used to connect the program to the Database in IMS. It provides a high-level interface for accessing IMS databases.

D. BMP: This option stands for Batch Message Processing, which is not the correct interface used to connect the program to the Database in IMS.

Therefore, the answer is: C. DLI

Multiple choice technology programming languages

What does PLAN parameter refers?

  1. PLAN Name in which the DB2 program has to be bound

  2. Collection name in to which the program has to be bound

  3. Database Name

  4. Dataset in which the DB2 program resides
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

To answer this question, the user needs to have knowledge of DB2 and the process of binding a program.

The PLAN parameter in DB2 refers to the plan name in which the DB2 program has to be bound.

Option A is correct because the PLAN parameter specifies the name of the plan to which the program should be bound during the BIND process.

Option B is incorrect because the collection name refers to a set of related objects in DB2, and it is not related to the PLAN parameter.

Option C is incorrect because the database name refers to the name of the database in which the tables and other objects used by the program are located, and it is not related to the PLAN parameter.

Option D is incorrect because the dataset refers to the physical location of the program code, and it is not related to the PLAN parameter.

Therefore, the correct answer is:

The Answer is: A. PLAN Name in which the DB2 program has to be bound

Multiple choice technology programming languages

Which of the following Environment cannot access DB2?

  1. TSO

  2. CICS

  3. IMS

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

To solve this question, the user needs to have basic knowledge of mainframe environments and their capabilities to access DB2.

Now let's go through each option and explain why it is right or wrong:

A. TSO - This environment can access DB2. TSO (Time Sharing Option) is an interactive dialog with the operating system, which provides an interface for the user to interact with the system. DB2 can be accessed through TSO environment using SPUFI and QMF tools.

B. CICS - This environment can access DB2. CICS (Customer Information Control System) is a transaction processing system that can access DB2 databases to store and retrieve data.

C. IMS - This environment can access DB2. IMS (Information Management System) is a hierarchical database management system that can access DB2 databases using the DLI (Data Language Interface) module.

D. ENDEVOUR - This environment is a software change management tool and does not have the ability to access DB2.

Therefore, the correct answer is:

The Answer is: D. ENDEVOUR