Vendor: IBM
Certifications: IBM Certified Advanced Database Administrator
Exam Name: Assessment: DB2 9.7 Advanced DBA for LUW - Assessment
Exam Code: A2090-544
Total Questions: 106 Q&As
Last Updated:
Note: Product instant download. Please sign in and click My account to download your product.
VCE
IBM A2090-544 Last Month Results
A2090-544 Q&A's Detail
Exam Code: | A2090-544 |
Total Questions: | 106 |
CertBus Has the Latest A2090-544 Exam Dumps in Both PDF and VCE Format
A2090-544 Online Practice Questions and Answers
What determines the degree of inter-partition parallelism used?
A. The number of database partitions and the definition of partition groups.
B. The number of database connections and the definition of partitions groups.
C. The value of the INTER_PARALLEL Database Manager configuration parameter.
D. The value of the DFT_DEGREE database configuration parameter.
A journaling application inserts data with continually increasing sequential keys while a clean up process randomly deletes erroneous rows. What can be done to maximize insert performance?
A. Issue a db2set DB2MAXFSCRSEARCH=1024 command.
B. Issue an ALTER TABLESPACE EXTEND statement.
C. Issue a db2set DB2SKIPDELETED=ON command.
D. Issue an ALTER TABLE APPEND ON statement.
If LOGSECOND=-1 then which of the following statements is true?
A. You still use LOGPRIMARY and LOGFILSIZ configuration parameters to specify how many log files the database manager should keep in the active log path.
B. You must configure the OVERFLOWLOGPATH configuration parameter if your active log path is not on a raw device.
C. The database will reserve active log space for transactions that may need to roll back and write log records.
D. An infinite number of overflow log files will be used with archival logging.
A database called PRODDB has a weekly full backup taken on Saturday, non-cumulative (delta) backups
taken daily, and a midweek cumulative backup that is taken on Wednesday. A database crash occurs on a
Saturday prior to the full backup being taken.
What is the fastest way to restore the database?
A. RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);
B. RESTORE DB proddb TAKEN AT (Saturday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Monday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Tuesday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Wednesday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Thursday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);
C. RESTORE DB proddb TAKEN AT (Friday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Saturday);
D. RESTORE DB proddb TAKEN AT (Saturday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);
Which series of items are required to establish a TCP/IP connection to a DB2 for z/OS database from a DB2 for Linux, UNIX, or Windows server?
A. hostname, logical unit (LU) name, target database name, local database name, node name
B. hostname, logical unit (LU) name, subsystem ID, local database name, node name
C. hostname, port number/protocol, subsystem ID, local database name, node name
D. hostname, port number/protocol, target database name, local database name, node name
Add Comments
the content update quickly, there are many new questions in this dumps. thanks very much.
Great dumps! I achieved high score with the help of this dumps, I will continue use this dumps and introduce it to others.
i cannot image that i would pass the exam with so high score, thanks for this dumps. Recommend.
i have passed today, All the questions are from their dumps, thanks for this dumps.
I have cleared that I passed the exam today. Thanks so much.
this dumps is useful and convenient, i think it will be your best choice. believe on it .
Recommend this A2090-544 exam dump to you strongly, really useful and convenient.
My good friend introduced this material to me. It really useful and convenient. I just prepared the exam by using this material and achieved high score than others. So I'm very happy. Thanks my friend and this material.
This dumps is very good, and i have passed the exam with the help of it recently.
Very useful study material, thanks the help of this dumps .