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
  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
  1. Trigger type

  2. Trigger body

  3. Trigger event

  4. Trigger timing


Correct Option: A
  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
  1. $CachePMDir

  2. $PMCacheDir

  3. $PMDir

  4. None of the above


Correct Option: B
  1. Near to source

  2. Near to target

  3. Can be placed anywhere

  4. Session performance is not affected


Correct Option: A
- Hide questions