Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
What is the maximum number of columns you can choose as organizing keys for a clustered base table?
Home
Netezza
What is the maximum number of columns you can choose as organizing keys for a clustered base table?
+1
vote
asked
Feb 19, 2023
in
Netezza
by
rajeshsharma
What is the maximum number of columns you can choose as organizing keys for a clustered base table?
A. 1
B. 2
C. 4
D. 8
netezza
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Feb 19, 2023
by
rajeshsharma
C. 4
The answer is C.
Your comment on this answer:
Email me at this address if a comment is added after mine:
Email me if a comment is added after mine
Privacy: Your email address will only be used for sending these notifications.
Related questions
+1
vote
Q: Can you update the columns used in the distribution clause?
asked
Feb 18, 2023
in
Netezza
by
rajeshsharma
netezza
0
votes
Q: If you did not specify any distribution clause, how the Create Table AS (CTAS) will distribute the rows?
asked
Feb 19, 2023
in
Netezza
by
rajeshsharma
netezza
ctas
+1
vote
Q: What data types are most suited for the columns specified in the distribution clause?
asked
Feb 18, 2023
in
Netezza
by
rajeshsharma
netezza
distribution-clause
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
netezza
ctas
+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
netezza
+1
vote
Q: How do you check the rows in a table are equally distributed in all SPU’s or not?
asked
Feb 19, 2023
in
Netezza
by
rajeshsharma
spu
netezza
+1
vote
Q: How do you redistribute a table?
asked
Feb 19, 2023
in
Netezza
by
rajeshsharma
netezza
0
votes
Q: Why do you prefer to truncate instead of drop table command?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
netezza
0
votes
Q: Which two characteristics describe the materialized view?(Choose two.)
asked
Feb 19, 2023
in
Netezza
by
rajeshsharma
netezza
materialized-view
0
votes
Q: What constraints on a table are enforced?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
netezza
...