Teradata Testing Questions and Answers


Teradata Testing | Mock Test

 

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

Answer : Fastload

2
__________  applies a read lock
a. Alter
b. Rename
c. Create
d. Joining

Answer : Create

3
__________  is always a one AMP operation
a. Unique primary index
b. Non unique primary index
c. Both the Above
d. Work Space

Answer : Both the Above

4
_________  parallelism is available in Terradata
a. Data
b. Record
c. Multi-Step
d. Data driven storage management

Answer : Multi-Step

5
_________  space is maximum amount of work space available for requests
a. Perm space
b. Spool space
c. Temp space
d. Four

Answer : Spool space

6
The role of primary indexes are
a. Data redundancy
b. Fastest way to retrieve data
c. Ensuring the isolation
d. Four

Answer : Fastest way to retrieve data

7
There are ________ BYNETs per system
a. One
b. Two
c. Three
d. 514 SMP Nodes

Answer : Two

8
There are _________ type of locks
a. One
b. Two
c. Three
d. Multiple dimension creation for data representation

Answer : Multiple dimension creation for data representation

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

Answer : 512 SMP Nodes

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

Answer : Dimensional Data Modeling comprises of one or more dimension tables and fact tables

Have any Question or Comment?

Leave a Reply

Exciting Offers

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 90 other subscribers

Exciting Offers

Exciting Offers

Exciting Offers

Close
%d bloggers like this: