Recent questions and answers in Netezza

0 votes

What feature in Netezza you do not like?

answered Feb 21 in Netezza by Robindeniel (19.7k points)

0 votes

What data type works best for zone maps?

answered Feb 21 in Netezza by Robindeniel (19.7k points)

0 votes

Can we update all columns in a Netezza table?

answered Feb 21 in Netezza by Robindeniel (19.7k points)

0 votes

When no distribution clause is used while creating a table, what distribution is used by Netezza?

answered Feb 21 in Netezza by Robindeniel (19.7k points)

0 votes

Why do you prefer to truncate instead of drop table command?

answered Feb 21 in Netezza by Robindeniel (19.7k points)

0 votes

Create Table AS (CTAS), does it distribute data randomly or based on the table on which it received data?

answered Feb 21 in Netezza by Robindeniel (19.7k points)

0 votes

Why NOT NULL specification is better in Netezza?

answered Feb 21 in Netezza by Robindeniel (19.7k points)

0 votes

What constraints on a table are enforced?

answered Feb 21 in Netezza by Robindeniel (19.7k points)

0 votes

Do we need to drop all tables and objects in that database, before dropping a database?

answered Feb 21 in Netezza by Robindeniel (19.7k points)

0 votes

What permission will you give to connect to a database?

answered Feb 21 in Netezza by Robindeniel (19.7k points)

0 votes

How can we give global permission to user joe so that he can create a table in any database?

answered Feb 21 in Netezza by Robindeniel (19.7k points)

0 votes

Can a group become a member of another group in Netezza user administration. Can we use the same group name for databases?

answered Feb 21 in Netezza by Robindeniel (19.7k points)

0 votes

What happens to records that are loaded during nzload process, but were not committed?

answered Feb 21 in Netezza by Robindeniel (19.7k points)

0 votes

How Netezza updates records. Give an idea of how transactions are maintained and how to read consistency is maintained?

answered Feb 21 in Netezza by Robindeniel (19.7k points)

0 votes

Does Netezza support the concurrent update of the same record?

answered Feb 21 in Netezza by kamalkhandelwal29 (219 points)

0 votes

What are 4 environment variables that are required. What are the different states on Netezza?

answered Feb 20 in Netezza by rajeshsharma (23.1k points)

0 votes

Explain how data gets stored in Netezza and how does SPU failover takes place?

answered Feb 20 in Netezza by rajeshsharma (23.1k points)

+1 vote

When are we likely to receive incorrect (aggregate) results?

answered Feb 20 in Netezza by rajeshsharma (23.1k points)

0 votes

How is load achieved in Netezza and why is that quick/fast?

answered Feb 20 in Netezza by rajeshsharma (23.1k points)

0 votes

What is the best data appliance?

answered Feb 20 in Netezza by rajeshsharma (23.1k points)

0 votes

Does everything get cached in Netezza (or any other data appliance)?

answered Feb 20 in Netezza by rajeshsharma (23.1k points)

0 votes

What are different ways to load?

answered Feb 20 in Netezza by rajeshsharma (23.1k points)

0 votes

How do you deal with historical data, with respect to zone maps?

answered Feb 20 in Netezza by rajeshsharma (23.1k points)

+1 vote

What is a zone map?

answered Feb 20 in Netezza by rajeshsharma (23.1k points)

+1 vote

Explain FPGA and how is it useful for query performance?

answered Feb 20 in Netezza by rajeshsharma (23.1k points)

+1 vote

Which system table could be used to find an object id for any table/view or object in a database?

answered Feb 20 in Netezza by rajeshsharma (23.1k points)

+1 vote

Which one of the following pieces of information is maintained in the zone map table to assist the performance of a query?

answered Feb 20 in Netezza by rajeshsharma (23.1k points)

0 votes

Which one of the following pieces of information is maintained by Statistics on a table?

answered Feb 20 in Netezza by rajeshsharma (23.1k points)

0 votes

Which log file captures SQL submitted to the NPS system?

answered Feb 20 in Netezza by rajeshsharma (23.1k points)

0 votes

What is the command to display/monitor the status of a reclaim?

answered Feb 20 in Netezza by rajeshsharma (23.1k points)

To see more, click for all the questions in this category.

...