Database Management Systems

The DB2/SQL EXPLAIN statement inserts detailed information about the access path of the query being explained into a table named PLAN_TABLE. DSN_STATEMNT_TABLE contains cost estimates, while SYSPLAN and SYSPACKAGE are catalog tables storing plan and package metadata rather than explain output.

Quality Center allows importing defects data, test plan data (test cases), and requirements data to populate the repository. Test Instance data is not directly imported - instances are created when test cases are added to test sets. Option C describes test instances which are generated, not imported.

In Oracle 9i database, the OSDBA operating system group is mapped to the SYSDBA database privilege, allowing users within this group to authenticate via the operating system. OSOPER maps to the SYSOPER privilege. Other options like 9iDBA or OSADM are not standard Oracle-predefined OS groups for database administration privileges.

The SYSOPER administrative privilege in Oracle databases permits basic operations like STARTUP, SHUTDOWN, and MOUNT/OPEN/CLOSE of a database. However, database creation requires the more powerful SYSDBA privilege.

Oracle's recommended approach requires backing up the fully functional database before beginning any tuning activities. This ensures you have a recovery point if tuning changes cause issues. Installing software, planning, and implementing design are prerequisites but must complete before the database is fully functional and ready for backup.

Evaluating the database server hardware is Oracle's first recommended task before any software installation or database design. Hardware assessment ensures the server meets requirements for memory, CPU, storage, and I/O capacity. Software installation (A), planning (D), and implementation (C) all happen after hardware evaluation.

The oraenv script provides a central mechanism for switching between different Oracle database instances by updating environment variables like ORACLE_SID, ORACLE_HOME, and PATH for all user accounts. Option C correctly describes this central update function. Options A and B mention scanning functions which don't apply. Option D describes database switching, which is the result, not the function.

DB_BLOCK_SIZE is a fundamental storage parameter that can only be set when a database is first created. It determines the size of data blocks and cannot be changed by simply modifying parameters or restarting - the entire database must be recreated with the new block size.

Database connections in Oracle environments typically use the format hostname:port:sid. For example: 'myserver:1521:ORCL' where 1521 is the default Oracle port and ORCL is the SID.

Database connections in Oracle environments typically use the format hostname:port:sid. For example: 'myserver:1521:ORCL' where 1521 is the default Oracle port and ORCL is the SID.

Dimension attributes with TEXT data type are designed to store descriptive labels and names that appear directly in reports and UIs. Numeric types (DECIMAL, NUMBER) and DATE are used for filtering, sorting, and calculations rather than display. Reporting tools use TEXT attributes to show human-readable dimension member names and descriptions in rows, columns, and filters.

JDBC supports both two-tier and three-tier models. Two-tier has the application directly connected to the database, while three-tier introduces middleware between application and database for better management.

DBRM stands for Database Request Module, which is a compiled SQL program structure in IBM DB2. It contains the optimized access path for SQL statements and is created during the precompilation process. The DBRM is bound to a plan or package for execution in the DB2 environment.

RRDS (Relative Record Data Set) is a VSAM file type where records are accessed by their relative record number (position), allowing direct access without requiring a key field.

BFILE is a unique Oracle datatype that stores a file pointer to data located outside the database in the operating system filesystem. Unlike BLOB and CLOB types which store data within the database, BFILE only maintains a reference to external files. UROWID is for rowids, NCLOB stores character large objects within the database.