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

Which table type should be used to provide fast key-based access to table data for queries involving exact matches and range searches?

  1. Regular table

  2. Clustered table

  3. Partitioned table

  4. Index-organized table
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Index-organized tables (IOTs) store rows in B-tree index structure sorted by primary key, providing fast key-based access for both exact matches and range searches. Regular tables store rows in heap format, clustered tables group related tables together physically, and partitioned tables divide data into segments but don't optimize key-based access specifically.

Multiple choice

What is the equivalent of the old DROP TABLE command in Oracle Database 10g?

  1. DROP TABLE NO PURGE

  2. DROP TABLE works exactly the way it did in previous versions.

  3. DROP TABLE … PURGE

  4. DROP TABLE … TO BEFORE DROP
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In Oracle 10g, DROP TABLE by default moves tables to the recyclebin. The PURGE option drops the table permanently without sending it to the recyclebin, making it equivalent to pre-10g DROP TABLE behavior. DROP TABLE NO PURGE is not valid syntax, and DROP TABLE...TO BEFORE DROP is used for flashback recovery, not permanent deletion.

Multiple choice

Which Oracle Net Services feature supports authentication methods such as token cards through the use of authentication adapters?

  1. Heterogeneous Services

  2. Firewalls

  3. Oracle Advanced Security

  4. Oracle Connection Manager
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Oracle Advanced Security Option provides authentication adapters that support various methods including token cards, biometrics, and Kerberos. Heterogeneous Services is for non-Oracle data access, Firewalls are network security devices, and Oracle Connection Manager handles connection pooling and multiplexing but not advanced authentication.

Multiple choice

Which of the following statements about an Oracle instance is true?

  1. The redo log buffer is NOT a part of the shared memory area of an Oracle instance.

  2. Multiple instances can be executed on the same computer, each accessing its own physical database.

  3. An Oracle instance is a combination of memory structures, background processes, and user processes.

  4. In a shared server environment, the memory structure component of an instance consists of a single SGA and a single PGA.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Multiple Oracle instances can run on the same machine, each accessing separate physical databases - this is how Oracle Real Application Clusters (RAC) and standalone instances coexist. Option A is incorrect because redo log buffer IS part of SGA. Option C is incorrect because instances consist of memory structures and background processes, not user processes. Option D is incorrect because shared server environments have one SGA but multiple PGAs (one per server process).