• databases Online Quiz - 89
Back
0

databases Online Quiz - 89

Description: databases Online Quiz - 89
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
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?

technology databases

  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;

Show answer
Correct Option: A

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

technology databases

  1. Index

  2. Cluster

  3. Package

  4. DB links

  5. Function

Show answer
Correct Option: A,C,E

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

technology databases

  1. Package

  2. Function

  3. Procedure

  4. Another DB trigger

Show answer
Correct Option: C

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

technology databases

  1. Trigger type

  2. Trigger body

  3. Trigger event

  4. Trigger timing

Show answer
Correct Option: A

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

technology databases

  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;

Show answer
Correct Option: A

Which component of teradata DB transfers messages

technology databases

  1. AMP

  2. MPL

  3. PE

  4. VDisk

Show answer
Correct Option: B

What is false about Teradata DD

technology databases

  1. Maintained by RDBMS

  2. Partially maintained users

  3. Accessed via teradata supplied views

  4. Distributed across all AMPs

Show answer
Correct Option: B

Which of following can be hardware too

technology databases

  1. AMP

  2. PDE

  3. PE

  4. BYNET

Show answer
Correct Option: D

MTDP is required for client attached system

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Request & response is controlled by

technology databases

  1. TDP

  2. CLI

  3. ODBC

  4. MOSI

Show answer
Correct Option: B

Clique is a collection of

technology databases

  1. AMP

  2. PE

  3. NODE

  4. Vdisk

Show answer
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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

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

technology databases

  1. PE

  2. AMP

  3. BYNET

  4. PDE

Show answer
Correct Option: C

Actual request processing is done by which component
technology databases

  1. PE

  2. AMP

  3. Vdisk

  4. TDP

Show answer
Correct Option: B

In Teradata SMP stands for

technology databases

  1. Scalar Module Processor

  2. Synchronous Module Processor

  3. Synchronous Multiple Processor

  4. Scalar Multiple Processor

Show answer
Correct Option: B

Which transformation has sorted input option available in the properties?

technology databases

  1. Joiner, Sorter

  2. Aggregator, Update Strategy

  3. Aggregator, Joiner

  4. All of above

Show answer
Correct Option: C

Which is true regarding joiner transformation?

technology databases

  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

Show answer
Correct Option: A

For Aggregator default cache directory is?

technology databases

  1. $CachePMDir

  2. $PMCacheDir

  3. $PMDir

  4. None of the above

Show answer
Correct Option: B

To maximize session performance by filter it should be?

technology databases

  1. Near to source

  2. Near to target

  3. Can be placed anywhere

  4. Session performance is not affected

Show answer
Correct Option: A

Which of the following transformation is passive and connected?

technology databases

  1. Aggregator

  2. Expression

  3. Joiner

  4. Filter

Show answer
Correct Option: B
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions