Netezza

4. shows estimated cost of SQL prior to execution
7. An nzload operation is treated as a single transaction (write either Truee or False)
8. data modifications on the primary disk partition to the corresponding mirror partition
11. Who is cost-based
12. To start Netezza database
16. Implements transaction isolation which provides the highest possible level of consistency
18. Groups, users, and _________ names must be unique
19. IBM Netezza is which type of parallel processing
20. Default distribution method
24. A predefined group in Netezza
26. High Performance Bulk Loader CLI utility
27. Dedicated drive connected with Snippet processor
29. A user cannot explicitly lock tables (write either Truee or False)
30. transaction ids are called as _____ and are sequential in nature.
31. Default Operating system of NPS

1. DBOS file which displays fully qualified table names
2. Optimizer relies on ____ to determine the most efficient way to execute a query
3. Snippet Processing Unit between the hosts
5. Materialized view not allowed on.
6. a series of discrete steps against each dataslice
9. Each Data Slice (SPU) has Unique.
10. Netezza Server Name
13. Data is compressed based on identical columnar values (columnar compression) (write either Truee or False)
14. Tables are split across data slices (write either Truee or False)
15. Widely used to change the distribution method of a table without reloading the data
17. A predefined super user in Netezza
21. Intelligent processing nodes make up the turbocharged MPP engine
22. is a block device driver that mirrors the content of block devices (hard disks, partitions, logical volumes, and so on)
23. High-volume computations like filtering and compression are pushed down to.
25. A unit of work to be performed by all S-Blades
26. A purpose built analytics engine
28. An another name of IBM Netezza 1000 series appliance