Recent questions tagged netezza

0 votes

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

asked Feb 21, 2023 in Netezza by Robindeniel

0 votes

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

asked Feb 21, 2023 in Netezza by Robindeniel

0 votes

Why NOT NULL specification is better in Netezza?

asked Feb 21, 2023 in Netezza by Robindeniel

0 votes

What constraints on a table are enforced?

asked Feb 21, 2023 in Netezza by Robindeniel

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, 2023 in Netezza by Robindeniel

0 votes

Does Netezza support the concurrent update of the same record?

asked Feb 21, 2023 in Netezza by kamalkhandelwal29

0 votes

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

asked Feb 20, 2023 in Netezza by rajeshsharma

+1 vote

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

asked Feb 20, 2023 in Netezza by rajeshsharma

0 votes

What is the best data appliance?

asked Feb 20, 2023 in Netezza by rajeshsharma

0 votes

What are different ways to load?

asked Feb 20, 2023 in Netezza by rajeshsharma

0 votes

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

asked Feb 20, 2023 in Netezza by rajeshsharma

+1 vote

What is a zone map?

asked Feb 20, 2023 in Netezza by rajeshsharma

+1 vote

Explain FPGA and how is it useful for query performance?

asked Feb 20, 2023 in Netezza by rajeshsharma

+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, 2023 in Netezza by rajeshsharma

+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, 2023 in Netezza by rajeshsharma

0 votes

Which log file captures SQL submitted to the NPS system?

asked Feb 20, 2023 in Netezza by rajeshsharma

+1 vote

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

asked Feb 19, 2023 in Netezza by rajeshsharma

0 votes

Which CREATE DATABASE attributes are required?

asked Feb 19, 2023 in Netezza by rajeshsharma

0 votes

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

asked Feb 19, 2023 in Netezza by rajeshsharma

+1 vote

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

asked Feb 19, 2023 in Netezza by rajeshsharma

Page:

...