Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
CWNP exams CWNP
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
GIAC exams GIAC
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
ISEB exams ISEB
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

IBM 000-M87 Exam - Cheat-Test.com

Free 000-M87 Sample Questions:

Q: 1
With workload management, an Administrator can set aside _________ S-Blades to be used exclusively with a given database?
A. 1
B. 2
C. all
D. 0
Answer: D

Q: 2
Which of the following is TRUE about the GROOM TABLE command?
A. You must first run the nzstop command as the nz user from the host command line.
B. GROOM can materialize the results of previous ALTER TABLE ADD/DROP column commands.
C. The table being groomed will be locked exclusively during the groom operation.
D. GROOM is an administrative command that must be run by a DBA.
Answer: B

Q: 3
Which of the following statements about Netezza privileges is NOT true?
A. Privileges are additiveou cannot remove a privilege from a user who has been granted that privilege as a member of a group.
B. Object owners automatically have full access to their objects.
C. Users with privileges on an object can pass that object to others by default.
D. By default, newly created objects have no privileges associated with them.
Answer: C

Q: 4
Which of the following statements can be used to create a temporary table?
A. SELECT INTO #TEMPTABLE col1, col2 FROM MYTABLE;
B. CREATE TEMP TABLE AS TEMPTABLE SELECT col1, col2 FROM MYTABLE;
C. CREATE TEMPORARY TABLE MYTABLE SAMEAS MYOTHERTABLE;
D. None of the above.
Answer: B

Q: 5
Is it CORRECT that if a table is distributed randomly, ZoneMaps are not used?
A. ZoneMaps are not used at all.
B. ZoneMaps are used in the exact same way as in any other distribution.
C. ZoneMaps are used only when statistics are not up to date.
D. None of the above.
Answer: B


© 2014 Cheat-Test.com, All Rights Reserved