Teradata Testing | Mock Test

 
1
__________  Supports multiple tables
a. Fastload
b. Multiload
c. SamsLoad
d. Unique constraints
Show Answer

2
__________  applies a read lock
a. Alter
b. Rename
c. Create
d. Joining
Show Answer
3
__________  is always a one AMP operation
a. Unique primary index
b. Non unique primary index
c. Both the Above
d. Work Space
Show Answer
4
_________  parallelism is available in Terradata
a. Data
b. Record
c. Multi-Step
d. Data driven storage management
Show Answer
5
_________  space is maximum amount of work space available for requests
a. Perm space
b. Spool space
c. Temp space
d. Four
Show Answer
6
The role of primary indexes are
a. Data redundancy
b. Fastest way to retrieve data
c. Ensuring the isolation
d. Four
Show Answer
7
There are ________ BYNETs per system
a. One
b. Two
c. Three
d. 514 SMP Nodes
Show Answer
8
There are _________ type of locks
a. One
b. Two
c. Three
d. Multiple dimension creation for data representation
Show Answer
9
Total Number of nodes suppport by BYNET are
a. 510 SMP Nodes
b. 512 SMP Nodes
c. 513 SMP Nodes
d. 514 SMP Nodes
Show Answer
10
What is dimensional modeling?
a. Dimensional Data Modeling comprises of dimension tables and no fact tables
b. Dimensional Data Modeling comprises of only fact tables and dimension table
c. Dimensional Data Modeling comprises of one or more dimension tables and fact tables
d. Multiple dimension creation for data representation
Show Answer