C9050-548 Dumps
C9050-548 Braindumps C9050-548 Real Questions C9050-548 Practice Test C9050-548 Actual Questions
killexams.com
IBM IMS DBA
https://killexams.com/pass4sure/exam-detail/C9050-548
The SQL SELECT statement allows the DBA to create table structures and pre- populate those table structures with database metadata.
The SQL SELECT statement is used to return rows of data from your database table or tables.
The SQL SELECT statement is used to return the status of the health of the database in the health DB2 health center application.
The SQL SELECT statement is not used in DB2 because DB2 is a hierarchical database.
When configuring an Optim Directory, which of the following DBMS types are supported?
DB2, Oracle, Sybase ASE, SQL Server, and IDMS
DB2, Oracle, Sybase ASE, SQL Server, and Informix
DB2, Oracle, SQL Server, IMS and IDMS
Only DB2 and Oracle
What is the DB2 journal?
The DB2 journal is a free newsletter that is published monthly to subscribers and that has articles of interest to DBAs.
The DB2 journal is a feature that allows for commands in a transaction to be rolled back. All commands that have been executed in a particular transaction can be undone using the DB2journal.
The DB2 journal is a GUI that displays historical information about tasks, database actions and operations, control center actions, messages, and alerts in your DB2 database.
DB2 does not have a journal.
What are private buffer pools are used for?
KSDSs
DEDBs
HALDBs
OSAM datasets
Reorganization of which two database implementations will require that the associated secondary index be rebuilt? (Choose two.)
HDAM with a secondary index that uses Direct pointers.
HIDAM with a secondary index that uses Direct pointers.
PHDAM with a secondary index that uses Direct pointers.
HDAM with a secondary index that uses Symbolic pointers.
HIDAM with a secondary index that uses Symbolic pointers.
Which one of the following options is FALSE about DB2's Multi-Temperature Data Storage capability?
You can use storage groups to implement multi-temperature data management in DB2.
Multi-temperature data management reduces the total cost of ownership by allowing efficient deployment of storage hardware with minimal administrative overhead.
Multi-temperature data management integrates with DB2's Workload Manager feature to let you prioritize your workloads based on the data being accessed.
Multi-temperature data management best practices recommend that cold data should be stored in faster devices in order to maximize overall system performance.
What are DB2 access plans?
An access plan is the result of the planning phase for the installation of the DB2 product. It takes into account who will access the database and which permissions they will have.
An access plan is part of the security audit that is performed by the DBA, with assistance from the network administrator, to list who will have access to database from the point of view of the operating system.
An access plan is a plan that is created for each table, describing which users or queries will have access to the data that is contained in that particular table.
An access plan is one that specifies an order of operations for accessing data in a SQL query. It lets you view statistics for selected tables, indexes, or columns; properties for operators; global information, such as table space and function statistics; and configuration parameters relevant to optimization.
Which DB2 licensing type is based on the number of users allowed to access the data server?
PVU (Processor Value Unit) licensing
Sub-capacity licensing
Authorized User (AU) licensing
Per Server licensing
What happens when an unqualified GN call is issued after a GB status code (end of database) is received?
The GB status code is repeated.
The first segment in the database is retrieved.
A GE status code (segment not found) is returned.
The last segment successfully retrieved is returned in the IOArea.