Page: 1
/ 8
Total 108 questions
A database administrator needs to create a federated database and configure access to join data from 3 Oracle instances, 2 SQL Server instances, and 1 DB2 database. Which objects are needed to establish the specified connections?
- A. 3 Oracle servers, 1 Oracle wrapper, 2 SQL Server servers, 1 SQL Server wrapper, and nicknames for all databases.
- B. 3 Oracle servers, 3 Oracle wrappers, 2 SQL Server servers, 2 SQL Server wrappers, and nicknames for all databases.
- C. 3 Oracle servers, 1 Oracle wrapper, 2 SQL Server servers, 1 SQL Server wrapper, 1 DB2 server, 1 DB2 wrapper, and nicknames for all databases.
- D. 3 Oracle servers, 3 Oracle wrappers, 2 SQL Server servers, 2 SQL Server wrappers, 1 DB2 server, 1 DB2 wrapper, and nicknames for all databases.
Answer : C
Which is NOT a valid method for prefetching data?
- A. Smart data prefetching
- B. Read-ahead prefetching
- C. Consecutive prefetching
- D. Sequential detection prefetching
Answer : C
Which item is NOT eligible for adaptive compression?
- A. Indexes
- B. Base tables
- C. Temporary tables
- D. Inline LOB values
Answer : C
The following query is executed frequently against the EMPLOYEE table: SELECT empid, salary, bonus FROM employee ORDER BY bonus, salary; Which statement will create an index for optimal query performance?
- A. CREATE INDEX salary_bonus_idx ON employee (salary, bonus)
- B. CREATE INDEX bonus_salary_idx ON employee (bonus, salary)
- C. CREATE INDEX bonus_salary_idx ON employee (bonus, salary) CLUSTER
- D. CREATE INDEX salary_bonus_idx ON employee (salary, bonus) CLUSTER
Answer : C
A table named MYTAB was created as follows:
How many rows will be inserted into the MYTAB table?
- A. 4
- B. 8
- C. 11
- D. 12
Answer : B
Prior to migrating to DB2 10.1, a DBA executed the following command on a daily basis: db2_all "<<-1< db2 BACKUP DATABASE sales TO /mnt/backup" Which command can now be used to perform the same backup operation?
- A. BACKUP DATABASE sales ON DBPARTITIONNUM (1) TO /mnt/backup
- B. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS TO /mnt/backup
- C. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT CATPARTITION TO /mnt/backup
- D. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT DBPARTITIONNUM (1) TO /mnt/backup
Answer : D
The following query is executed frequently against the SALES table: SELECT sales_id, sales_date, sales_person FROM sales; If data in the SALES_ID column is unique, which statement will create an index for optimal query performance and ensure uniqueness of the
SALES_ID column?
- A. CREATE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)
- B. CREATE UNIQUE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)
- C. CREATE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)
- D. CREATE UNIQUE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)
Answer : D
If the following commands complete successfully for a single partition database: CREATE
DATABASE mydb; CREATE BUFFERPOOL mybp; Which statement is true?
- A. Self tuning is enabled for the MYBP buffer pool.
- B. The initial size for the MYBP buffer pool is zero pages.
- C. The database has to be restarted before the MYBP buffer pool will become active.
- D. The page size for the MYBP buffer pool can be changed using the ALTER BUFFERPOOL statement.
Answer : A
Which table function can be used to determine whether all of a particular table space data objects have been moved from one storage group toWhich table function can be used to determine whether all of a particular table space? data objects have been moved from one storage group to another?
- A. MON_GET_TABLESPACE
- B. ADMIN_GET_STOGROUP_INFO
- C. ADMIN_GET_STORAGE_PATHS
- D. MON_GET_REBALANCE_STATUS
Answer : D
Which statement about Range-Clustered Tables (RCTs) is correct?
- A. More logging is required compared to similarly-sized regular tables.
- B. More buffer pool memory is required to store the table's B+ index structure.
- C. Space is pre-allocated and reserved for use by the table even when records do not yet exist.
- D. More maintenance is required since indexes must be updated after every insert, update, or delete operation.
Answer : C
Which command will be executed successfully on every database partition if db2_all is used?
- A. CONNECT
- B. FORCE APPLICATION
- C. RESTART DATABASE
- D. ACTIVATE DATABASE
Answer : C
Given the following output:
Which Explain procedure can be used to find the most expensive SQL statement in terms of CPU cost over a period of time?
- A. EXPLAIN_FROM_DATA
- B. EXPLAIN_FROM_ACTIVITY
- C. EXPLAIN_FROM_SECTION
- D. EXPLAIN_FROM_CATALOG
Answer : B
With HADR, IBM Tivoli System Automation for Multiplatforms (SA MP) automated failover can be used with which database(s)?
- A. The primary database only.
- B. The auxiliary standby database only.
- C. The principal standby database only.
- D. The primary, auxiliary standby, and principal standby database.
Answer : C
A query against the system catalog revealed that data for a table named SALES in a partitioned database is distributed as follows:
What can be done to improve the performance of a query that joins SALES and DATE_DIM tables (where SALES is a fact table and DATE_DIM is a dimension table) using the
DATE_ID column?
- A. Reload table SALES and use only one partition with a collocated join to the DATE_DIM table using the primary key DATE_ID.
- B. Reload table DATE_DIM and use only one partition with a collocated join to the SALES table using the primary key DATE_ID.
- C. Create a replicated table REPL_SALES from the SALES table, refresh REPL_SALES table, create index on DATE_ID column in the REPL_SALES table, and collect statistics on REPL_SALES table.
- D. Create a replicated table REPL_DATE_DIM from the DATE_DIM table, refresh REPL_DATE_DIM table, create index on DATE_ID column in the REPL_DATE_DIM table, and collect statistics on REPL_DATE_DIM table.
Answer : D
30 days access 