• databases Online Quiz - 238
Back
0

databases Online Quiz - 238

Description: databases Online Quiz - 238
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

Each AMP is responsible for a subset of rows from each table.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

It is impossible to have skewed data when employing a Non-Unique Primary Index value?

technology databases

  1. True

  2. False

Show answer
Correct Option: B

How does Teradata handle data distribution when performing system configuration changes
technology databases

  1. Creates an output map to aid in redistributing data

  2. Data distribution is automatic

  3. Creates a reconfig map to help the DBA repartition data

  4. None of the above

Show answer
Correct Option: B

Which of the following statements about hashing are true?
technology databases

  1. The uniqueness value is a component of the row hash value.

  2. In a table that has a NUPI, all rows with the same NUPI value are distributed to the same AMP.

  3. Two Primary Index values that hash to the same row hash value are called hash synonyms.

  4. The output of the hashing algorithm is called the hash map

Show answer
Correct Option: B,C

What are the parts of PE?
technology databases

  1. AMP's

  2. Parser

  3. Dispatcher

  4. Bynet

  5. Optimiser

Show answer
Correct Option: B,C,E

Each AMP Corresponds to a particular Vdisk.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

NUPI Access is how many AMP Access?

technology databases

  1. Multiple

  2. One

  3. Two

  4. All of the above

Show answer
Correct Option: B

AI Explanation

To answer this question, we need to understand the relationship between NUPI Access and AMP Access.

NUPI Access refers to the Network User Part Identifier (NUPI), which is a unique identifier used in telecommunications networks. AMP Access, on the other hand, refers to the Access Method Part (AMP), which is a signaling protocol used for communication between network elements.

The given question asks how many AMP Access is equivalent to NUPI Access.

The correct answer is B. One.

This means that NUPI Access corresponds to a single instance of AMP Access.

Features of Primary Key are:
technology databases

  1. Unique

  2. Non Unique

  3. Null

  4. Not Null

  5. All of the above

Show answer
Correct Option: A,D

Which utilities can be used for both Export and Import?

technology databases

  1. Fastload

  2. Multiload

  3. BTEQ

  4. TPump

  5. Teradata warehouse builder

Show answer
Correct Option: B,C,E

Multiload can load data in populated tables.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Features of Fastload include:

technology databases

  1. Can populate Single table

  2. Can load populated tables

  3. Tables with SI and referential integrity can be loaded

  4. Very fast if target table is empty

  5. Table loaded can be accesed while fastload runs.

Show answer
Correct Option: A,D

A column of a table is declared as NUMBER(10,2).For which of the following values oracle returns an error during insertion
technology databases

  1. 5392845.324

  2. 871039453.1

  3. 97234512.123

  4. 1234567.12

Show answer
Correct Option: B

Error capturing is done by these utilities:

technology databases

  1. BTEQ

  2. FASTLOAD

  3. MULTILOAD

  4. FASTEXPORT

  5. TPUMP

Show answer
Correct Option: B,C,E

Multiload works in how many phases?

technology databases

  1. 2

  2. 3

  3. 5

  4. 1

Show answer
Correct Option: C

Sub query cannot have which clause defined for it
technology databases

  1. having clause

  2. where clause

  3. order by clause

  4. group by clause

Show answer
Correct Option: C

All DML's are supported by which utility?

technology databases

  1. Mload

  2. Fload

  3. Bteq

  4. Tpump

Show answer
Correct Option: C

Select length(-1) from dual What is the output of the above sql stmt

technology databases

  1. 0

  2. 1

  3. 2

  4. error

Show answer
Correct Option: C

conditional logic can be applied in which utilitiy?

technology databases

  1. BTEQ

  2. FASTLOAD

  3. MULTILOAD

  4. TPUMP

Show answer
Correct Option: A,C,D

If there are frequent updates in tables, then which utility to use?

technology databases

  1. BTEQ

  2. TPUMP

  3. FASTEXPORT

  4. MULTILOAD

Show answer
Correct Option: B

The standard EMP table contains 14 records corresponding to the employess of the corporation.One of those records has a NULL value stored in the MGR column.If Issue the following command on the table:select count(mgr) from emp;which of the following choice indentifies the result oracle will return
technology databases

  1. <14

  2. >14

  3. 14

  4. 0

Show answer
Correct Option: A
- 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