Question 1

You need to remove BUSINESS_HOUR DB trigger.WHich command in SQL*PLUS environmet is used to delete it?

technology databases

Drop trigger business_hour;
delete trigger business_hour;
remove trigger business_hour;
delete from user_triggers where trigger_name=business_hour;

Answer

Correct Option: A

Question 2

Creation of which DB objects will cause a DDL trigger to fire?

technology databases

Index
Cluster
Package
DB links
Function

Answer

Correct Option: A,C,E

Question 3

A call statement inside the trigger body enables you to call:

technology databases

Package
Function
Procedure
Another DB trigger

Answer

Correct Option: C

Question 4

What part of a DB trigger determines the number of times a trigger body executes?

technology databases

Trigger type
Trigger body
Trigger event
Trigger timing

Answer

Correct Option: A

Question 5

You need to remove BUSINESS_HOUR DB trigger.WHich command in SQL*PLUS environmet is used to delete it?

technology databases

Drop trigger business_hour;
delete trigger business_hour;
remove trigger business_hour;
delete from user_triggers where trigger_name=business_hour;

Answer

Correct Option: A

Question 6

Which component of teradata DB transfers messages

technology databases

AMP
MPL
PE
VDisk

Answer

Correct Option: B

Question 7

What is false about Teradata DD

technology databases

Maintained by RDBMS
Partially maintained users
Accessed via teradata supplied views
Distributed across all AMPs

Answer

Correct Option: B

Question 8

Which of following can be hardware too

technology databases

AMP
PDE
PE
BYNET

Answer

Correct Option: D

Question 9

MTDP is required for client attached system

technology databases

True
False

Answer

Correct Option: B

Question 10

Request & response is controlled by

technology databases

TDP
CLI
ODBC
MOSI

Answer

Correct Option: B

Question 11

Clique is a collection of

technology databases

AMP
PE
NODE
Vdisk

Answer

Correct Option: C

Question 12

Teradata can be expanded linearly

technology databases

True
False

Answer

Correct Option: B

Question 13

In Teradata v2r5 onwards, which component can be software and hardware both

technology databases

PE
AMP
BYNET
PDE

Answer

Correct Option: C

Question 14

Actual request processing is done by which component

technology databases

PE
AMP
Vdisk
TDP

Answer

Correct Option: B

Question 15

In Teradata SMP stands for

technology databases

Scalar Module Processor
Synchronous Module Processor
Synchronous Multiple Processor
Scalar Multiple Processor

Answer

Correct Option: B

Question 16

Which transformation has sorted input option available in the properties?

technology databases

Joiner, Sorter
Aggregator, Update Strategy
Aggregator, Joiner
All of above

Answer

Correct Option: C

Question 17

Which is true regarding joiner transformation?

technology databases

We cannot use joiner transformation when any input pipeline contains update strategy transformation
We can connect sequence generator transformation directly before the joiner
Both of above options
None of the above

Answer

Correct Option: A

Question 18

For Aggregator default cache directory is?

technology databases

$CachePMDir
$PMCacheDir
$PMDir
None of the above

Answer

Correct Option: B

Question 19

To maximize session performance by filter it should be?

technology databases

Near to source
Near to target
Can be placed anywhere
Session performance is not affected

Answer

Correct Option: A

Question 20

Which of the following transformation is passive and connected?

technology databases

Aggregator
Expression
Joiner
Filter

Answer

Correct Option: B

Description: databases Online Quiz - 89
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 89

Find more quizzes from top tags