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 databases

Stored procedures are compiled the first time they’re run but are not stored in a system table of the current database.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The statement is false because stored procedures ARE stored in system tables of the current database after compilation. When first executed, a stored procedure is compiled and its execution plan is cached in system tables (like syscomments in some systems) for reuse. This caching improves performance on subsequent executions.

Multiple choice technology programming languages

The database administrator is taking the cbgb tablespace offline, due to erroneous datafiles in the tablespace. Which offline tablespace option should be chosen?

  1. NORMAL

  2. TEMPORARY

  3. IMMEDIATE

  4. FOR RECOVER
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When a tablespace has erroneous or corrupted datafiles, the TEMPORARY offline option is appropriate because it brings the tablespace offline without performing a checkpoint on the datafiles. NORMAL requires a checkpoint and clean datafiles, IMMEDIATE is used for emergency situations when NORMAL fails, and FOR RECOVER is used when the tablespace needs media recovery before being brought online.

Multiple choice technology programming languages

Which of the following are valid predefined roles that can be used with Oracle databases?

  1. DBA

  2. RESOURCE

  3. CONNECT

  4. EXP_FULL_DATABASE

  5. IMP_FULL_DATABASE

  6. All the above
Reveal answer Fill a bubble to check yourself
F Correct answer
Explanation

Oracle provides several predefined roles to simplify privilege management. DBA grants all system privileges, RESOURCE allows users to create objects, CONNECT allows basic database connection, EXP_FULL_DATABASE grants full export privileges, and IMP_FULL_DATABASE grants full import privileges. All of these are valid predefined roles in Oracle.

Multiple choice technology programming languages

A database administrator needs to create a tablespace for an Oracle database. He formulates the following statement: CREATE TABLESPACE frgr DATAFILE ‘/g01/oracle/data/sasa01.dbf’ SIZE 100M EXTENT MANAGEMENT DICTIONARY AUTOALLOCATE DEFAULT STORAGE ( INITIAL 100K NEXT 100K MINEXTENTS 5 MAXEXTENTS 25 PCTINCREASE 0); LOGGING TEMPORARY

  1. By default, tables within the tablespace will not have all its changes written to redo.

  2. It is a locally managed tablespace.

  3. A temporary tablespace has been created.

  4. An error will be produced; the AUTOALLOCATE parameter should be removed
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In Oracle, the AUTOALLOCATE clause is only valid with EXTENT MANAGEMENT LOCAL. Specifying EXTENT MANAGEMENT DICTIONARY along with AUTOALLOCATE will result in a syntax error, so the statement fails and produces an error.

Multiple choice technology mainframe

An ADABAS database can be mapped with more than one DDM

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

ADABAS allows multiple DDMs (Data Definition Modules) to be mapped to the same physical database, providing different logical views of the data. This is a standard feature for accessing the same database with different field selections and naming conventions. The statement is true.

Multiple choice technology mainframe

Assume an adabas database has been mapped with DDMS. viz IDENTIFICATION-TABLE & IDENTIFICATION-TABLE-EXP The difference between two DDMS is IDENTIFICATION-TABLE-EXP created with IDENT-NAME as (A6) whereas IDENTIFICATION-TABLE with (A4). A batch program is updating the database with IDENTIFICATION-TABLE-EXP. Values are as below. IDENT-ID IDENT-NAME IDENT-AGE ----------------------------- 1234 AAAAbb 23 2345 ACDBCD 13 3456 ADSBbb 25 4567 DADSbb 15 5678 EDSCbb 20 READ IDENTIFICATION-TABLE BY SUPER-ID-NAME-AGE STARTING FROM '1234' DISPLAY IDENT-ID IDENT-NAME IDENT-AGE LOOP How many records will be displayed in the output? * small case b stands for space

  1. 5

  2. 4

  3. 3

  4. 1

  5. Program will terminate abnormally
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

When a record layout or DDM length mismatch occurs where the database contains data longer than the program's DDM definition (A4 vs A6), updating or reading may lead to mismatch behavior, but in Adabas/Natural, changing field length specifications or updating with mismatch formats can cause runtime errors (such as NAT3009 or type conflicts) during execution, leading to abnormal termination.

Multiple choice technology mainframe

Assume an adabas database has been mapped with DDMS. viz IDENTIFICATION-TABLE & IDENTIFICATION-TABLE-EXP The difference between two DDMS is IDENTIFICATION-TABLE-EXP created with IDENT-NAME as (A6) whereas IDENTIFICATION-TABLE with (A4). A batch program is updating the database with IDENTIFICATION-TABLE-EXP. Values are as below. IDENT-ID IDENT-NAME IDENT-AGE ----------------------------- 1234 AAAAbb 23 2345 ACDBCD 13 3456 ADSBbb 25 4567 DADSbb 15 5678 EDSCbb 20 READ IDENTIFICATION-TABLE BY SUPER-ID-NAME-AGE STARTING FROM '1234' DISPLAY IDENT-ID IDENT-NAME IDENT-AGE LOOP How many records will be displayed in the output? * small letter b stands for space

  1. 5

  2. 4

  3. 3

  4. 1

  5. Program will terminate abnormally
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

The data was stored using IDENTIFICATION-TABLE-EXP with IDENT-NAME as A6 (6 bytes), but the READ uses IDENTIFICATION-TABLE where IDENT-NAME is defined as A4 (4 bytes). This field length mismatch causes a runtime error because the READ operation cannot properly interpret the 6-byte data using a 4-byte field definition, resulting in abnormal program termination.

Multiple choice technology databases

___is the language used to put data into the database, retrieve data from the database, control transactions, and administer your database

  1. PL/SQL

  2. SQL

  3. SQL*PLUS

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

SQL (Structured Query Language) is the standard language for relational database operations including data manipulation (INSERT, SELECT, UPDATE, DELETE), data definition (CREATE, ALTER, DROP), transaction control (COMMIT, ROLLBACK), and database administration.

Multiple choice technology testing

What is the first thing that must be defined in a Recovery Scenario?

  1. A. Trigger

  2. B. Recovery Operation

  3. C. Recovery Scenario Name

  4. D. The Function used in the scenario
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

When creating a Recovery Scenario in QTP/UFT, the Recovery Scenario Wizard first requires you to define the Trigger Event that interrupts the test run (e.g., a pop-up window or application crash). Recovery operations and scenario names are defined in subsequent steps.

Multiple choice technology testing

What does the source property of a database checkpoint object represent?

  1. A. The SQL query

  2. B. The identification number of the database

  3. C. The number of rows returned from the query

  4. D. The connectionstring used to connect to the database
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The source property of a database checkpoint object in QTP represents the SQL query that retrieves data from the database. This query is used to fetch the result set that will be compared against expected values. The source is NOT the connection string (that's stored separately), not an identification number, and not the row count (though it may return rows).

Multiple choice technology testing

what are the two most commonly used ADO objects?

  1. A. Fields

  2. B. Execute

  3. C. Connection, RecordSet

  4. D. Open, ConnectionString
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The Connection object establishes the link to the data source, while the RecordSet object holds the data returned from a query. These are the two fundamental ADO objects used in almost all database operations. Fields is a property collection within RecordSet, Execute is a method, and Open/ConnectionString are related to connection establishment but are not objects themselves.

Multiple choice technology

PS Query definition is stored in whihc server?

  1. DB Server

  2. Application server

  3. Web server

  4. DB Server & Application Server
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

PS Query definitions are stored in the PeopleSoft Application Server, not the database server. This allows for centralized query management and security. The query metadata resides in PeopleTools tables on the application server, even though the query execution hits the database.

Multiple choice technology

If you want to log in to Daamover in Bootstrap mode, you would login as...

  1. Database Superuser

  2. PeopleSoft Superuser

  3. Data mover superuser

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

In PeopleSoft Data Mover, bootstrap mode requires database-level access to initialize the system. A Database Superuser has the necessary privileges to perform bootstrap operations, while other roles like PeopleSoft Superuser or Security Administrator operate at the application level and do not have direct database access for bootstrap.