Recent questions tagged Netezza

0 votes

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

asked Feb 21 in Netezza by Robindeniel (19.8k points)

0 votes

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

asked Feb 21 in Netezza by Robindeniel (19.8k points)

0 votes

Why NOT NULL specification is better in Netezza?

asked Feb 21 in Netezza by Robindeniel (19.8k points)

0 votes

What constraints on a table are enforced?

asked Feb 21 in Netezza by Robindeniel (19.8k 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?

asked Feb 21 in Netezza by Robindeniel (19.8k points)

0 votes

Does Netezza support the concurrent update of the same record?

asked Feb 21 in Netezza by kamalkhandelwal29 (219 points)

0 votes

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

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

+1 vote

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

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

0 votes

What is the best data appliance?

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

0 votes

What are different ways to load?

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

0 votes

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

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

+1 vote

What is a zone map?

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

+1 vote

Explain FPGA and how is it useful for query performance?

asked 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?

asked 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?

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

0 votes

Which log file captures SQL submitted to the NPS system?

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

+1 vote

What is the maximum number of columns you can choose as organizing keys for a clustered base table?

asked Feb 19 in Netezza by rajeshsharma (23.1k points)

0 votes

Which CREATE DATABASE attributes are required?

asked Feb 19 in Netezza by rajeshsharma (23.1k points)

0 votes

Which two characteristics describe the materialized view?(Choose two.)

asked Feb 19 in Netezza by rajeshsharma (23.1k points)

+1 vote

What are the ways to load data from a table into a file?

asked Feb 19 in Netezza by rajeshsharma (23.1k points)

Page:

...