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

The actual call to access the database will be done by calling

  1. CBLTDLI

  2. PLITDLI

  3. Only a

  4. A or b
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

To answer this question, the user needs to have knowledge of database access methods.

The correct answer is:

D. A or B

Explanation:

CBLTDLI and PLITDLI are both programming interfaces for accessing databases. CBLTDLI is a COBOL interface, and PLITDLI is a PL/I interface. Both interfaces are used to submit commands and retrieve data from databases. Therefore, either option A or option B can be used to access the database. Option C is incorrect because only option A or B can be used to access the database, not just option A.

Multiple choice technology platforms and products

What is the name of the brbackup and brarchive parameter file for an Oracle database used by an R/3 Central Instance with SAP System ID PKR?

  1. initPKR.ini

  2. initPKR.ora

  3. initPKR.sap

  4. initPKR.brt
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In SAP R/3 systems using Oracle databases, BR*Tools (brbackup and brarchive) use parameter files with the .sap extension. The naming convention follows the format init.sap where SAPSID is the System ID. For SAP System ID PKR, the correct parameter file name is initPKR.sap. The .ora extension is used for Oracle's own initialization files, while .ini and .brt are not standard for this purpose.

Multiple choice technology

What is/are the prerequisite/s for installing Tibco Business works?

  1. Tibco runtime agent

  2. Tibco administrator

  3. Tibco Adapter for Active database

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

TIBCO Runtime Agent (TRA) is the foundational requirement for installing TIBCO BusinessWorks. TRA provides the runtime environment, Java_HOME configuration, and service infrastructure. TIBCO Administrator and Active Database Adapter are optional components installed separately for specific needs.

Multiple choice technology programming languages

Which line of code represents the correct syntax to establish a reference to a database handle?
  1. $dbh = DBI::connect("dbi:mysql:myPhoneBook");
  2. $dbh = DBD:->connect("dbi::mysql::myPhoneBook");
  3. $dbh = DBD::connect("mysql:dbi:myPhoneBook");
  4. $dbh = DBI->connect("dbi:mysql:myPhoneBook");
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The correct Perl DBI syntax is DBI->connect() with the DSN string 'dbi:mysql:myPhoneBook'. Options A and B incorrectly use static (::) instead of arrow (->) syntax. Option C has the wrong DSN format (mysql:dbi instead of dbi:mysql). The DBI module uses object-oriented syntax with the arrow operator.

Multiple choice technology databases

An Oracle instance is executing in a nondistributed configuration. The instance fails because of an operating system failure. Which background process would perform the instance recovery when the atabase is reopened ?

  1. PMON

  2. SMON

  3. RECO

  4. ARCn

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

The System Monitor (SMON) background process is responsible for performing instance recovery when an Oracle database is restarted after an unexpected crash. PMON cleans up failed user processes, RECO resolves pending distributed transactions, ARCn archives redo logs, and CKPT signals checkpoints, making them incorrect for instance recovery.

Multiple choice technology databases

CREATE TABLESPACE user_data DATAFILE '/u01/oradata/user_data_01.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size of 1 MB?

  1. Extent

  2. Segement

  3. Oracle block

  4. Operating system block
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In a LOCALLY MANAGED tablespace with UNIFORM SIZE 1M, every EXTENT allocated within that tablespace is exactly 1 MB. This provides predictable space allocation and avoids fragmentation.

Multiple choice technology databases

The ORDERS table has a constant transaction load 24 hours a day, so down time is not allowed. The index become fragmented. Whic statment is true ?

  1. The index need to be dropped, and then re-created.

  2. The resolution of index fragmentation depends on the type of index.

  3. The index can be rebuilt while users continue working on the table.

  4. The index can be rebuilt, but users will not have access to the index during this time.

  5. The fragmented can be ignored because Oracle resolve index fragmentation by means of a freelist.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Oracle allows online index rebuild using the ONLINE keyword (ALTER INDEX ... REBUILD ONLINE), enabling users to continue DML operations during the rebuild. This is essential for 24/7 systems.

Multiple choice technology

What is the effect of checking out a project?

  1. Locks the project in the server repository but not in the local repository

  2. Locks the projects in the local database repository

  3. Locks the projects in the server database repository

  4. Copies all object definitions in the project on the server to the local database
Reveal answer Fill a bubble to check yourself
B,C,D Correct answer
Explanation

Checking out a Siebel project locks it in both local and server repositories (preventing concurrent modifications), and copies all object definitions from server to local database, enabling offline development.

Multiple choice technology

Which server task creates the Docking\User directory on the Siebel Server for a new Mobile Client?

  1. Transaction Router

  2. Generate New Database

  3. Synchronization Manager

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

In Siebel Mobile Web Client architecture, the Database Extract task is responsible for initializing a new mobile client's local database. This task creates the necessary directory structure including the Docking\User directory on the Siebel Server, which stores the client-specific data and configuration files.

Multiple choice technology programming languages

Which line of code represents the correct syntax to establish a reference to a database handle?
  1. $dbh = DBI::connect("dbi:mysql:myPhoneBook");
  2. $dbh = DBD:->connect("dbi::mysql::myPhoneBook");
  3. $dbh = DBD::connect("mysql:dbi:myPhoneBook");
  4. $dbh = DBI->connect("dbi:mysql:myPhoneBook");
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The correct Perl DBI syntax is $dbh = DBI->connect("dbi:mysql:myPhoneBook"); DBI is the database interface module, and connect is called as a class method using arrow notation. The dbi:mysql: prefix specifies the DBI driver and database name. Options B and C incorrectly use DBD or wrong syntax, and option A omits the arrow operator.