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

ORA-1578 stands for

  1. internal errors

  2. block corruption errors

  3. deadlock errors

  4. errors occurred during dispached processes

  5. external errors
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

ORA-1578 – block corruption errors

Multiple choice

Who can modify the data in the database?

  1. Database administrators

  2. Network administrators

  3. Application developers

  4. Application administrators

  5. Database users
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Database users can enter, modify or delete data in the database, where permitted.

Multiple choice

Which task can a DBA perform using the export/import facility?

  1. Examine data files

  2. Examine log files

  3. Recreate the control file

  4. Transport table spaces between databases

  5. Make a logical backup of the rollback segment tablespace
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

 DBA transports table spaces using the export/import facility.

Multiple choice

Before creating a transportable table space, which condition should be satisfied?

  1. All indexes are enabled.

  2. All indexes are disabled.

  3. The tables containing nested tables are contained in the same tablespace.

  4. The source and target system must use the same operating system.

  5. The target system has the tablespace which is created already.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Before creating a transportable table space, the source and target system must use the same operating system.

Multiple choice

Why should a datafile be set to offline when the database is in MOUNT state?

  1. To recover it later, when database is in NOARCHIVELOG mode

  2. To minimise downtime

  3. To prevent further corruption of a damaged datafile

  4. To allow for automatic datafile recovery

  5. To reject the datafile automatically
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When the database is in MOUNT state, a datafile is set to offline to allow automatic recovery.

Multiple choice

Which of the following statements is false about Buffer overflow attack?

  1. It stores the data mostly in a temporary data storage.

  2. It affects the data integrity.

  3. The corrupt data contains certain code for the specified triggering actions by the attackers.

  4. This type of attack can affect the server's configuration.

  5. The buffers are created to contain a finite amount of data.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Buffer overflow attack is caused due to poor programming practices and it does not affect the server's configuration.