It is impossible to pass IBM C2090-614 exam without any help in the short term. Come to Actualtests soon and find the most advanced, correct and guaranteed IBM C2090-614 practice questions. You will get a surprising result by our Updated DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614) practice guides.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-614 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-614 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-614-exam-dumps.html
Q41. A database named TEST and a storage group named SG_1 were created with these statements: an error was produced.Why did the error occur?
A. The current default storage group cannot be dropped.
B. New storage paths cannot be added to existing storage groups.
C. The storage group IBMSTOGROUP cannot be dropped because it is a system-defined storage group.
D. The storage group SG_1 was not the current default storage group at the time a new storage path was being added to it.
Answer: A
Q42. Which statement about SMS table spaces is correct?
A. The system catalog cannot be stored in an SMS table space.
B. Tables, large objects (LOBs), and indexes can each reside in separate SMS table spaces.
C. SMS table spaces are recommended when you have small tables that are not likely to grow quickly.
D. Extents are more likely to be contiguous with SMS table spaces than they are with DMS table spaces.
Answer: C
Q43. Which command(s) should be used to drop database partition 10 from a database named MYDB?
A. STOP DBM DROP DBPARTITIONNUM 10; DROP DBPARTITIONNUM VERIFY;
B. DROP DBPARTITIONNUM VERIFY; STOP DBM DROP DBPARTITIONNUM 10;
C. CONNECT TO mydb; DROP DBPARTITIONNUM 10; CONNECT RESET;
D. CONNECT TO mydb; DROP DBPARTITIONNUM 10; ACTIVATE DB mydb;
Answer: B
Q44. A DBA wants to create a table named SALES that has the following characteristics: ?effective data clustering and management of space utilization ?rows in the table should be clustered based on when they are added to the table Which clause must be used with the CREATE TABLE statement to define this table?
A. ORGANIZE BY DIMENSIONS
B. ORGANIZE BY INSERT TIME
C. ORGANIZE BY TIME PERIOD
D. ORGANIZE BY KEY SEQUENCE
Answer: B
Q45. 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
Q46. What is the preferred method for reclaiming unused storage in a DMS table space?
A. Perform an ALTER TABLESPACE...REDUCE operation.
B. Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...REDUCE operation.
C. Perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation, and then an ALTER TABLESPACE...REDUCE operation.
D. Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation.
Answer: C
Q47. Which statement about data type mappings is true in a federated system?
A. The Oracle DOUBLE data type maps to the DB2 type FLOAT by default.
B. Data types can be mapped in both directions between a remote and local data type.
C. Cast functions can be pushed down to remote servers even if a counterpart function does not exist there.
D. For relational data sources, the degree to which you can override existing data type mappings or create mappings is limited.
Answer: B
Q48. 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 alldatabases.
D. 3 Oracle servers, 3 Oracle wrappers, 2 SQL Server servers, 2 SQL Server wrappers, 1 DB2 server, 1 DB2 wrapper, and nicknames for alldatabases.
Answer: C
Q49. Which diagnostic tool can be used to show high-watermark consumptions of Fast Communication Manager (FCM) buffers and channels?
A. db2pd
B. inspect
C. db2dart
D. db2mtrk
Answer: A
Q50. In which situation would you NOT use a redirected restore?
A. To redefine the paths of a defined storage group.
B. To move table space containers onto different physical devices.
C. To restore a backup image from one operating system to another.
D. To restore a backup image to a target machine that is different from the source machine.
Answer: C