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

When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?

  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Oracle will give an error

  5. Undefined

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When a user creates an object without specifying a tablespace, Oracle stores it in that user's default tablespace. This is set at user creation time with the DEFAULT TABLESPACE clause or inherited from the database default.

Multiple choice

In a client-server configuration, a user is executing a long-running script that performs many inserts. The process hangs, and the user reboots their machine. The user has called for assistance. What steps should the DBA take to assist the user in the execution of the script?

  1. Apply archived redo log files to recover any inserts that were committed prior to the termination of the transaction.

  2. Do nothing. The Oracle Server will automatically perform instance recovery.

  3. Do nothing. The PMON background process will roll back the transaction releasing any resources and locks.

  4. Restore the database to a point-in-time prior to the abnormal termination of the transaction..
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When a client abnormally terminates, PMON (Process Monitor) automatically detects the failed session, rolls back the uncommitted transaction, releases locks, and frees resources. No manual intervention by the DBA is needed - PMON handles this cleanup automatically.

Multiple choice

In a client-server configuration, a user is executing a long-running script that performs many inserts. The process hangs, and the user reboots their machine. The user has called for assistance. What steps should the DBA take to assist the user in the execution of the script?

  1. Apply archived redo log files to recover any inserts that were committed prior to the termination of the transaction

  2. Do nothing. The Oracle Server will automatically perform instance recovery

  3. Do nothing. The PMON background process will roll back the transaction releasing any resources and locks

  4. Restore the database to a point-in-time prior to the abnormal termination of the transaction.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When an Oracle client process terminates abnormally, the PMON (Process Monitor) background process automatically detects the failure and rolls back any uncommitted transactions. PMON releases all resources and locks held by the terminated transaction, making them available to other sessions. This is automatic instance recovery at the transaction level. Option A is incorrect because archived redo logs are for media recovery, not transaction rollback. Option B is incorrect because instance recovery doesn't help with incomplete user transactions. Option D is incorrect because point-in-time recovery would lose committed work.

Multiple choice

Which of the following has a physical structure that is visible to the operating system made up of operating system made up of operating system files and a logical structure that is recognized only the oracle server?

  1. Oracle database

  2. Oracle instance

  3. Redo log buffer

  4. SQL work area

  5. Mounting the database
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

It has a physical structure that is visible to the operating system made up of operating system files and a logical structure that is recognized only the oracle server.