Tag: databases
Questions Related to databases
-
Tpump
-
BulKLoad
-
FastLoad
-
MultiLoad
-
All data rows are copied into temporary space
-
Each data block for a table is read
-
Each data row is accessed only one
-
A random set of data blocks for a table is read
-
When choosing a primary index you should pick a column with a severely limited value set
-
If distribution is skewed an all-AMP operation will take longer than if all AMPs were evenly utilized
-
Selecting a NUPI for storing data provides for maximum efficiency and makes the best use of the parallel features of Teradata
-
The degree of uniqueness is not critical ot efficiency.
-
Mature optimizer
-
Industry standard access language(SQL)
-
Concurrent users
-
Parallel architecture
-
Teradata Manager
-
BTEQ
-
Teradata SQL Assistant
-
TDQM
-
It is based on the Secondary Index
-
It is based on the primary key of the table
-
It is on the partitioning column
-
It is based on the Primary Index of the table
-
It is the Primary Key of the table, which guarantees uniqueness
-
It allows instantaneous dropping of old data and rapid addition of new data
-
It avoids full table scans without the overhead of a secondary index.
-
It places all data in a specific range on the same AMP.
-
creating a report to show a comparison of sales from this week to last week
-
creating a report show how much credit can be extended to a customer
-
creating a report that shows the top ten selling items across all stores for one year
-
updating a checking account to reflect a deposit