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

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

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

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

  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

Which component of teradata DB transfers messages

  1. AMP

  2. MPL

  3. PE

  4. VDisk


Correct Option: B

What is false about Teradata DD

  1. Maintained by RDBMS

  2. Partially maintained users

  3. Accessed via teradata supplied views

  4. Distributed across all AMPs


Correct Option: B

Which of following can be hardware too

  1. AMP

  2. PDE

  3. PE

  4. BYNET


Correct Option: D

MTDP is required for client attached system

  1. True

  2. False


Correct Option: B

Clique is a collection of

  1. AMP

  2. PE

  3. NODE

  4. Vdisk


Correct Option: C

AI Explanation

To answer this question, we need to understand the concept of a "clique."

A clique is a collection of nodes in a graph, where every node is directly connected to every other node in the collection. In other words, in a clique, every pair of nodes is connected by an edge.

Let's go through each option to determine which one represents a collection of nodes:

Option A) AMP - AMP stands for Accelerated Mobile Pages. It is a web component framework developed by Google. However, it does not represent a collection of nodes in the context of a clique. Therefore, option A is incorrect.

Option B) PE - PE could refer to several things, such as Physical Education or Private Equity. However, neither of these options represents a collection of nodes in the context of a clique. Therefore, option B is incorrect.

Option C) NODE - NODE represents a collection of nodes in the context of a clique. In a graph, a clique is a collection of nodes where every node is directly connected to every other node. Therefore, option C is correct.

Option D) Vdisk - Vdisk does not represent a collection of nodes in the context of a clique. Therefore, option D is incorrect.

The correct answer is option C) NODE. This option is correct because a clique is indeed a collection of nodes in a graph.

Teradata can be expanded linearly

  1. True

  2. False


Correct Option: B

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

  1. PE

  2. AMP

  3. BYNET

  4. PDE


Correct Option: C

Actual request processing is done by which component

  1. PE

  2. AMP

  3. Vdisk

  4. TDP


Correct Option: B

In Teradata SMP stands for

  1. Scalar Module Processor

  2. Synchronous Module Processor

  3. Synchronous Multiple Processor

  4. Scalar Multiple Processor


Correct Option: B

Which transformation has sorted input option available in the properties?

  1. Joiner, Sorter

  2. Aggregator, Update Strategy

  3. Aggregator, Joiner

  4. All of above


Correct Option: C

Which is true regarding joiner transformation?

  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

Which of the following transformation is passive and connected?

  1. Aggregator

  2. Expression

  3. Joiner

  4. Filter


Correct Option: B
- Hide questions