Top 100+ questions in Netezza

0 votes

Q: What feature in Netezza you do not like?

asked Feb 21 in Netezza by Robindeniel

0 votes

Q: What data type works best for zone maps?

asked Feb 21 in Netezza by Robindeniel

0 votes

Q: Can we update all columns in a Netezza table?

asked Feb 21 in Netezza by Robindeniel

0 votes

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

asked Feb 21 in Netezza by Robindeniel

0 votes

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

asked Feb 21 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 in Netezza by Robindeniel

0 votes

Q: Why NOT NULL specification is better in Netezza?

asked Feb 21 in Netezza by Robindeniel

0 votes

Q: What constraints on a table are enforced?

asked Feb 21 in Netezza by Robindeniel

0 votes

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

asked Feb 21 in Netezza by Robindeniel

0 votes

Q: What permission will you give to connect to a database?

asked Feb 21 in Netezza by Robindeniel

0 votes

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

asked Feb 21 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 in Netezza by Robindeniel

0 votes

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

asked Feb 21 in Netezza by Robindeniel

0 votes

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

asked Feb 21 in Netezza by kamalkhandelwal29

0 votes

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

asked Feb 21 in Netezza by kamalkhandelwal29

0 votes

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

asked Feb 20 in Netezza by rajeshsharma

0 votes

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

asked Feb 20 in Netezza by rajeshsharma

+1 vote

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

asked Feb 20 in Netezza by rajeshsharma

0 votes

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

asked Feb 20 in Netezza by rajeshsharma

0 votes

Q: What is the best data appliance?

asked Feb 20 in Netezza by rajeshsharma

0 votes

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

asked Feb 20 in Netezza by rajeshsharma

0 votes

Q: What are different ways to load?

asked Feb 20 in Netezza by rajeshsharma

0 votes

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

asked Feb 20 in Netezza by rajeshsharma

+1 vote

Q: What is a zone map?

asked Feb 20 in Netezza by rajeshsharma

+1 vote

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

asked Feb 20 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 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 in Netezza by rajeshsharma

0 votes

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

asked Feb 20 in Netezza by rajeshsharma

0 votes

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

asked Feb 20 in Netezza by rajeshsharma

0 votes

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

asked Feb 20 in Netezza by rajeshsharma

Page:

1
2
3
next »

...