Teradata Testing | Mock Test

 
1
__________  Supports multiple tables
a. Fastload
b. Multiload
c. SamsLoad
d. Unique constraints
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Fastload [/bg_collapse]
2
__________  applies a read lock
a. Alter
b. Rename
c. Create
d. Joining
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Create [/bg_collapse]
3
__________  is always a one AMP operation
a. Unique primary index
b. Non unique primary index
c. Both the Above
d. Work Space
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Both the Above [/bg_collapse]
4
_________  parallelism is available in Terradata
a. Data
b. Record
c. Multi-Step
d. Data driven storage management
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Multi-Step[/bg_collapse]
5
_________  space is maximum amount of work space available for requests
a. Perm space
b. Spool space
c. Temp space
d. Four
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Spool space [/bg_collapse]
6
The role of primary indexes are
a. Data redundancy
b. Fastest way to retrieve data
c. Ensuring the isolation
d. Four
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Fastest way to retrieve data [/bg_collapse]
7
There are ________ BYNETs per system
a. One
b. Two
c. Three
d. 514 SMP Nodes
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Two [/bg_collapse]
8
There are _________ type of locks
a. One
b. Two
c. Three
d. Multiple dimension creation for data representation
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Multiple dimension creation for data representation [/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : 512 SMP Nodes [/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Dimensional Data Modeling comprises of one or more dimension tables and fact tables [/bg_collapse]