Test 000-512 is a certification associated to DB2 udb v7.1 family fundamentals
We provide some 000-512 material for you to practice.
6.Given the following table definition: STAFF id INTEGER name CHAR(20) dept INTEGER job
CHAR(20) years INTEGER salary DECIMAL(10,2) comm DECIMAL(10,2) The job column contains
these job types: manager, clerk, and salesperson. Which of the following statements will return
the data with all managers together, all clerks together and all salespeople together in the output?
A.SELECT * FROM staff ORDER BY job
B.SELECT job, name FROM staff GROUP BY name, job
C.SELECT * FROM staff GROUP BY name, job, id, dept, years, salary, comm
D.SELECT * FROM staff ORDER BY name, job, id, dept, years, salary, comm
Correct:A
7.Which of the following occurs if an application ends abnormally during an active unit of work?
A.Current unit of work is committed
B.Current unit of work is rolled back
C.Current unit of work remains active
D.Current unit of work moves to pending state
Correct:B
8.User2 has DBADM authority on database DB1. This allows the user to do which of the following?
A.Drop database DB1
B.Backup database DB1
C.Create tables in any database
D.Create tables in database DB1
Correct:D
Test 000-512, also known as DB2 udb v7.1 family fundamentals, is a IBM certification
We provide the latest and most effective 000-512 exam study materials. With the complete collection of questions and answers, our has assembled to take you through 110 Q&As to your 000-512 exam preparation.
We designed the exam preparation materials provide you with everything you need to know the main points of the exam.
Regularly updated products to ensure that it is up to date.
Like actual certification exams our product is in multiple-choice questions (MCQs).
All real exam Q&A are included in package.
All questions are updated on regular basis from Real Exam.
PDF format, Portable anywhere.
No authorization code required to open exam.
Testving offers free demo for Solutions Expert 000-512 exam (DB2 udb v7.1 family fundamentals). You can check out the interface, question quality and usability of our practice exams before you decide to buy it.
