Db2 Practice 1
.
- 1.If the following command is executed: CREATE DATABASE test What is the page size (inkilobytes) of the database?
- A.
4
- B.
8
- C.
16
- D.
32
- 2.Which DB2 object can be used to improve the execution performance of qualified SELECTstatements?
- A.
Materialized Query Table
- B.
Sequence Object
- C.
SQL Procedure
- D.
Trigger
- 3.When is it appropriate to use a sequence?
- A.
When you want to control the order in which triggers are fired.
- B.
When you want to control the order in which stored procedures can be invoked.
- C.
When you want to automatically generate a numeric value that is not tied to any specific column or table.
- D.
When you want to automatically generate a numeric value for each row that is added to a specific table.
- 4.Which clause should be included in a ALTER TABLE statement to update a table definition with anew column?
- A.
ADD COLUMN
- B.
ALTER COLUMN
- C.
APPEND COLUMN
- D.
RENAME COLUMN
- 5.Which object is a stored procedure defined into?
- A.
Table
- B.
Schema
- C.
Package
- D.
Database
- 6.Which action needs to be performed in order to complete the definition of an application-periodtemporal table?
- A.
A transaction-start-id column must be defined for the table.
- B.
A BUSINESS_TIME period must be specified in a CREATE or ALTER of the table.
- C.
A history table must be defined and associated with the base table.
- D.
A unique index must be created that prevents overlapping of the BUSINESS_TIME period of the table.
- 7.What functionality allows users to perform a UNION operation between a DB2 table and an Oracleview?
- A.
Oracle connect
- B.
Trusted context
- C.
Oracle federation
- D.
Distributed request
- 8.You have a business need to query DB2 10 and DB2 9 databases and you want to write anapplication that can run on most platforms unchanged. Which interface would you use to achieveyour goal?
- A.
CLI
- B.
JDBC
- C.
XML
- D.
RUBY
- 9.Which DB2 object is used to provide a logical grouping of other database objects?
- A.
Alias
- B.
Index
- C.
Schema
- D.
Collection
- 10.What are two valid objects that can be created in DB2?
- A.
Tree
- B.
Node
- C.
Trigger
- D.
Contexts
- E.
Sequence
- F.
Table
- 11.Which type of temporal table can be used to store only time-sensitive data?
- A.
Bitemporal
- B.
Time-period
- C.
System-period
- D.
Application-period
- 12.When an index is created for a table, where is the metadata for that index stored?
- A.
In the table definition.
- B.
In the system catalog.
- C.
In the schema that the index resides in.
- D.
In the metadata of the table the index was created for.
- 13.Which product is used to customize execution environments for the purpose of controlling systemresources so that one department or service class does not overwhelm the system?
- A.
PureScale
- B.
Data partitioning feature
- C.
Workload manager
- D.
Self-tuning memory manager
- 14.What type of mechanism is a simple token value that is used to refer to a much bigger large object(LOB)?
- A.
Reference
- B.
Address
- C.
Pointer
- D.
Locator
- 15.What type of large object (LOB) is used to store LOB data together with the formatted rows ondata pages, instead of in a separate LOB storage object?
- A.
Inline
- B.
Binary
- C.
Internal
- D.
Partitioned
- 16.What is the purpose of the Query Tuner?
- A.
To automatically capture and stop rogue queries.
- B.
To provide recommendations and analysis for tuning a single query.
- C.
To provide recommendations and analysis for tuning up to 100 queries.
- D.
To recommend indexes and to guide DBAs through the process of creating new indexes.
- 17.Which tool allows users to connect to a DB2 database using a wizard?
- A.
Control Center
- B.
Universal Connection Expert
- C.
DB2 Connection Pool Manager
- D.
IBM Data Studio
- 18.Which two activities indicate the need for a data warehouse?
- A.
Confirm product inventory.
- B.
Monitor product availability.
- C.
Summarize sales by region.
- D.
Identify patterns for products sold in the last five years.
- E.
Associate one or more products with a purchase order.
- 19.What is the primary function of an Online Transaction Processing (OLTP) workload?
- A.
To combine data from multiple sources.
- B.
To discover hidden relationships in data.
- C.
To analyze large amounts of data to find patterns.
- D.
To make changes to a small number of records within a single transaction.
- 20.Which isolation level offers the greatest protection of data but provides the least amount of concurrency?
- A.
Read Stability (RS)
- B.
Cursor Stability (CS)
- C.
Repeatable Read (RR)
- D.
Uncommitted Read (UR)
- 21.What factor influences lock escalation?
- A.
Table size
- B.
Buffer space
- C.
Number of locks
- D.
Available real storage
- 22.Which type of lock allows the lock owner and all concurrent applications to read, but not update,the locked data?
- A.
Share (S)
- B.
Update (U)
- C.
Exclusive (X)
- D.
Intent Exclusive (IX)
- 23.Application APP_A is performing updates to table TAB1 using the cursor stability (CS) isolationlevel. If application APP_B wants to retrieve all rows from table TAB1 without waiting forapplication APP_A to finish making updates, what isolation level must application APP_B use?
- A.
Read Stability (RS)
- B.
Repeatable Read (RR)
- C.
Uncommitted Read (UR)
- D.
Cursor Stability (CS)
- 24.Which statement will prevent concurrent application processes from performing anything otherthan read-only operations against a table named TAB1?
- A.
LOCK TABLE tab1 IN READ MODE
- B.
LOCK TABLE tab1 IN SHARE MODE
- C.
LOCK TABLE tab1 IN EXCLUSIVE MODE
- D.
LOCK TABLE tab1 IN READ-ONLY MODE
- 25.When is an INTENT EXCLUSIVE (IX) lock required?
- A.
When a transaction intends to read or change data.
- B.
When a transaction intends to change but not read data.
- C.
When a transaction intends to read but not change data.
- D.
When a transaction intends to change the system catalog.
Questions: 111 | Attempts: 102528 | Last updated: Mar 21, 2022
-
Sample QuestionBy default, how is the initial library list established for a submitted job?
Questions: 8 | Attempts: 50487 | Last updated: Mar 20, 2022
-
Sample QuestionWhat are different parts of the UNIX system?
Questions: 10 | Attempts: 7731 | Last updated: Mar 22, 2022
-
Sample QuestionWhat are the rules of the Zachman Framework?
Back to top