0

databases Online Quiz - 89

Description: databases Online Quiz - 89
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Drop trigger business_hour;

  2. delete trigger business_hour;

  3. remove trigger business_hour;

  4. delete from user_triggers where trigger_name=business_hour;


Correct Option: A

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

  1. Index

  2. Cluster

  3. Package

  4. DB links

  5. Function


Correct Option: A,C,E
  1. Package

  2. Function

  3. Procedure

  4. Another DB trigger


Correct Option: C

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

  1. Trigger type

  2. Trigger body

  3. Trigger event

  4. Trigger timing


Correct Option: A

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

  1. Drop trigger business_hour;

  2. delete trigger business_hour;

  3. remove trigger business_hour;

  4. delete from user_triggers where trigger_name=business_hour;


Correct Option: A
  1. Maintained by RDBMS

  2. Partially maintained users

  3. Accessed via teradata supplied views

  4. Distributed across all AMPs


Correct Option: B

Request & response is controlled by

  1. TDP

  2. CLI

  3. ODBC

  4. MOSI


Correct Option: B
  1. AMP

  2. PE

  3. NODE

  4. Vdisk


Correct Option: C

In Teradata SMP stands for

  1. Scalar Module Processor

  2. Synchronous Module Processor

  3. Synchronous Multiple Processor

  4. Scalar Multiple Processor


Correct Option: B
  1. Joiner, Sorter

  2. Aggregator, Update Strategy

  3. Aggregator, Joiner

  4. All of above


Correct Option: C
  1. We cannot use joiner transformation when any input pipeline contains update strategy transformation

  2. We can connect sequence generator transformation directly before the joiner

  3. Both of above options

  4. None of the above


Correct Option: A

For Aggregator default cache directory is?

  1. $CachePMDir

  2. $PMCacheDir

  3. $PMDir

  4. None of the above


Correct Option: B

To maximize session performance by filter it should be?

  1. Near to source

  2. Near to target

  3. Can be placed anywhere

  4. Session performance is not affected


Correct Option: A
- Hide questions