Recent questions tagged Netezza

0 votes

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

asked Feb 21, 2023 in Netezza by Robindeniel

0 votes

Q: 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

Q: Why NOT NULL specification is better in Netezza?

asked Feb 21, 2023 in Netezza by Robindeniel

0 votes

Q: What constraints on a table are enforced?

asked Feb 21, 2023 in Netezza by Robindeniel

0 votes

Q: 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

Q: Does Netezza support the concurrent update of the same record?

asked Feb 21, 2023 in Netezza by kamalkhandelwal29

0 votes

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

asked Feb 20, 2023 in Netezza by rajeshsharma

+1 vote

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

asked Feb 20, 2023 in Netezza by rajeshsharma

0 votes

Q: What is the best data appliance?

asked Feb 20, 2023 in Netezza by rajeshsharma

0 votes

Q: What are different ways to load?

asked Feb 20, 2023 in Netezza by rajeshsharma

0 votes

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

asked Feb 20, 2023 in Netezza by rajeshsharma

+1 vote

Q: What is a zone map?

asked Feb 20, 2023 in Netezza by rajeshsharma

+1 vote

Q: Explain FPGA and how is it useful for query performance?

asked Feb 20, 2023 in Netezza by rajeshsharma

+1 vote

Q: 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

Q: 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

Q: Which log file captures SQL submitted to the NPS system?

asked Feb 20, 2023 in Netezza by rajeshsharma

+1 vote

Q: 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

Q: Which CREATE DATABASE attributes are required?

asked Feb 19, 2023 in Netezza by rajeshsharma

0 votes

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

asked Feb 19, 2023 in Netezza by rajeshsharma

+1 vote

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

asked Feb 19, 2023 in Netezza by rajeshsharma

Page:

...