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

What types of data source(s) can be read with the source qualifier transformation?

  1. Relational Databases

  2. Relational Databases and flat files

  3. Relational Databases,lat files and cobol

  4. Relational Databases,lat files,cobol and certified ERP sources such as Peoplesoft and SAP R/3

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

The Source Qualifier transformation in Informatica PowerCenter can read data from relational databases, flat files, COBOL files, and certified external ERP sources like SAP R/3 and PeopleSoft.

Multiple choice technology programming languages

When would you use Joiner transformation

  1. If you want to join two tables in same database

  2. If the Order By clause needs to be changed

  3. If you want to join two tables on different Oracle databases

  4. If you want to join table and flat file
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Joiner transformation is specifically used to join data from heterogeneous sources like a table and a flat file, or two different database systems. If both tables are in the same database, it's more efficient to use a SQL Join with Source Qualifier rather than Joiner transformation. Joiner adds overhead and should be avoided when database-level joins are possible.

Multiple choice technology platforms and products

What is Value Set?

  1. List of Values with validation.

  2. Storing varchar Data.

  3. Storing number Data.

  4. List of Value.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Oracle Applications, a Value Set defines the format, validation rules, and acceptable list of values for a flexfield segment or concurrent program parameter, ensuring data integrity.

Multiple choice technology databases

Which of the following is the most serious type of redo log file failure?

  1. The loss of an entire redo log file group, but no loss in any other group

  2. The loss of one member of each redo log file group

  3. The failure of the ARC0 background process

  4. The failure of the LGWR background process
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Losing an entire redo log group means complete loss of that redo log data, which is the most serious failure. Losing one member from each group reduces redundancy but preserves data as long as at least one member per group remains.

Multiple choice technology databases

When the database is in ARCHIVELOG mode, database recovery is possible up to which event or time?

  1. The last redo log file switch

  2. The last checkpoint position

  3. The last commit

  4. The last incremental backup using RMAN
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In ARCHIVELOG mode, archived redo logs enable point-in-time recovery to any committed transaction. You can recover the database up to and including the last commit before a failure.

Multiple choice technology databases

Which of the following commands places the database in ARCHIVELOG mode?

  1. ALTER SYSTEM ARCHIVELOG;

  2. ALTER DATABASE ARCHIVELOG;

  3. ALTER SYSTEM SET ARCHIVELOG=TRUE;

  4. ALTER DATABASE ENABLE ARCHIVELOG MODE;

  5. ALTER DATABASE ARCHIVELOG MODE;
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

ALTER DATABASE ARCHIVELOG is the correct SQL command to enable ARCHIVELOG mode. This requires the database to be mounted but not open, and is typically followed by a backup.

Multiple choice technology databases

Which statement adds a member /logs/redo22.log to redo log file group 2?

  1. ALTER DATABASE ADD LOGFILE ‘/logs/redo22.log’ TO GROUP 2;

  2. ALTER DATABASE ADD LOGFILE MEMBER ‘/logs/redo22.log’ TO GROUP 2;

  3. ALTER DATABASE ADD MEMBER ‘/logs/redo22.log’ TO GROUP 2;

  4. ALTER DATABASE ADD LOGFILE ‘/logs/redo22.log’;
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The ADD LOGFILE MEMBER clause adds a redo log member to an existing group. The syntax requires both LOGFILE MEMBER keywords, not just MEMBER.

Multiple choice technology packaged enterprise solutions

PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?

  1. SYSRELEASE

  2. SYSOBJECTS

  3. PSRELEASE

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

PSRELEASE is the PeopleTools system table that tracks object changes, versions, and release information. It maintains the history of object modifications in the PeopleSoft system. The other options (SYSRELEASE, SYSOBJECTS, PSOBJECTS) are not the correct system tables for tracking object changes.

Multiple choice technology packaged enterprise solutions

Where are the definitions that make up a PeopleSoft Application stored?

  1. SYSTEM CATALOG

  2. PEOPLETOOLS TABLES

  3. APPLICATION TABLES

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

PeopleSoft Application definitions (records, pages, menus, etc.) are stored in PeopleTools tables, which are system tables that store metadata about application objects. Application Tables store actual business data, and System Catalog is a database-specific concept.

Multiple choice technology packaged enterprise solutions

Where is the Application Data Cached?

  1. Application server

  2. Web server

  3. Batch server

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

Application data is cached on the Application server to improve performance. This cache reduces database hits by storing frequently accessed data in memory. Web servers handle HTTP requests, and Batch servers process background jobs.

Multiple choice technology packaged enterprise solutions

PeopleSoft has its own naming convention for system and non-system tables. In the list below, RECORDNAME refers to the name of any table or record. Referring to the above information, which one of the following identifies the naming convention PeopleSoft uses for system tables?

  1. PS_RECORDNAME

  2. SYSRECORDNAME
  3. PS$RECORDNAME

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

PeopleSoft uses the prefix 'PS' followed directly by the record name (e.g., PSRECORDNAME) for its internal system tables, distinguishing them from application tables which use 'PS_'.