Netezza

3. A user cannot explicitly lock tables (write either Truee or False)
4. A predefined super user in Netezza
6. Snippet Processing Unit between the hosts
7. Each Data Slice (SPU) has Unique.
10. Default distribution method
11. Groups, users, and _________ names must be unique
13. A another name of IBM Netezza 1000 series appliance
15. data modifications on the primary disk partition to the corresponding mirror partition
20. Optimizer relies on ____ to determine the most efficient way to execute a query
24. a series of discrete steps against each dataslice
25. DBOS file which displays fully qualified table names
26. Netezza Server Name
27. Default Operating system of NPS
29. Widely used to change the distribution method of a table without reloading the data

1. A purpose built analytics engine
2. is a block device driver that mirrors the content of block devices (hard disks, partitions, logical volumes, and so on)
5. High Performance Bulk Loader CLI utility
6. Intelligent processing nodes make up the turbocharged MPP engine
8. Who is cost-based
9. A predefined group in Netezza
12. Implements transaction isolation which provides the highest possible level of consistency
14. when a disk fails to respond, automatically switching to the mirrored copy of the data
16. Dedicated drive connected with Snippet processor
17. High-volume computations like filtering and compression are pushed down to.
18. New Physical Database Design Tool
19. To start Netezza database
21. shows estimated cost of SQL prior to execution
22. A unit of work to be performed by all S-Blades
23. IBM Netezza is which type of parallel processing
28. transaction ids are called as _____ and are sequential in nature.