Question 1

What is the result of a full table scan occurring on Teradata? (Choose two)

technology databases

All data rows are copied into temporary space
Each data block for a table is read
Each data row is accessed only one
A random set of data blocks for a table is read

Answer

Correct Option: B,C

Question 2

Of the following which is a true statement with regard to a primary index operation?

technology databases

When choosing a primary index you should pick a column with a severely limited value set
If distribution is skewed an all-AMP operation will take longer than if all AMPs were evenly utilized
Selecting a NUPI for storing data provides for maximum efficiency and makes the best use of the parallel features of Teradata
The degree of uniqueness is not critical ot efficiency.

AI Explanation

AI 1

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) When choosing a primary index, you should pick a column with a severely limited value set.

This option is incorrect. When choosing a primary index, it is generally recommended to pick a column with a broad value set to evenly distribute data across AMPs and optimize performance.

Option B) If distribution is skewed, an all-AMP operation will take longer than if all AMPs were evenly utilized.

This option is correct. In Teradata, data distribution across AMPs plays a crucial role in achieving optimal performance. If the data distribution is skewed, meaning that some AMPs have significantly more data than others, an all-AMP operation will take longer as the workload is not evenly distributed.

Option C) Selecting a NUPI for storing data provides for maximum efficiency and makes the best use of the parallel features of Teradata.

This option is incorrect. While selecting a NUPI (Non-Unique Primary Index) can provide some benefits in certain scenarios, it does not necessarily guarantee maximum efficiency or the best use of parallel features. The choice of primary index depends on various factors such as data distribution, workload, and query patterns.

Option D) The degree of uniqueness is not critical to efficiency.

This option is incorrect. The degree of uniqueness in a primary index is critical to efficiency in Teradata. A highly unique primary index distributes the data evenly across AMPs, allowing for efficient parallel processing. On the other hand, a low degree of uniqueness can lead to skewed data distribution and inefficient query performance.

The correct answer is B) If distribution is skewed, an all-AMP operation will take longer than if all AMPs were evenly utilized. This option is correct because skewed data distribution can lead to imbalanced workloads and slower performance in Teradata.

Answer

Correct Option: B

Question 3

Which are two exclusive features of Teradata? (Choose two)

technology databases

Mature optimizer
Industry standard access language(SQL)
Concurrent users
Parallel architecture

Answer

Correct Option: A,D

Question 4

Queries based on set threshold are restricted by which tool?

technology databases

Teradata Manager
BTEQ
Teradata SQL Assistant
TDQM

Answer

Correct Option: D

Question 5

You are an administrator at CertKiller.com. CertKiller.com has a Teradata system with 100 GB of permanent space, of which 50 GB is reserved for spool space. The system currently has 30 GB of user data. What is the total available spool space for user queries?

technology databases

70 GB
50GB
30 GB
80 GB

Answer

Correct Option: A

Question 6

In which way is data distributed with a Partitioned Primary Index?

technology databases

It is based on the Secondary Index
It is based on the primary key of the table
It is on the partitioning column
It is based on the Primary Index of the table

Answer

Correct Option: D

Question 7

A Partitioned Primary Index should be used for what two reasons? (Choose two)

technology databases

It is the Primary Key of the table, which guarantees uniqueness
It allows instantaneous dropping of old data and rapid addition of new data
It avoids full table scans without the overhead of a secondary index.
It places all data in a specific range on the same AMP.

Answer

Correct Option: C,D

Question 8

An example of an OLTP environment is _____

technology databases

creating a report to show a comparison of sales from this week to last week
creating a report show how much credit can be extended to a customer
creating a report that shows the top ten selling items across all stores for one year
updating a checking account to reflect a deposit

Answer

Correct Option: D

Question 9

You are an administrator at CertKiller.com. CertKiller.com has a Teradata system with 100 GB of permanent space and creates User A with 30 GB permanent space. How much spaces will User A have, if User A creates User B with 20 GB permanent space?

technology databases

70GB
80GB
10GB
30GB

Answer

Correct Option: C

Question 10

When utilizing a unique secondary index, how may AMP (s) is usually accessed?

technology databases

All-AMP
One-AMP
Multi-AMP
Two-AMP

Answer

Correct Option: D

Question 11

How would you define a transaction?

technology databases

A logon, submittal of work, and logoff
A single sql statement
A logical unit or work
A single sql, statement and the unit of recovery

Answer

Correct Option: C

Question 12

Consider the emp table having columns empno, ename Which of the following SQL query fetches empno that occur more than twice in the emp table.

technology databases

select count() from emp group by empno having count() >2;
select empno, count() from emp having count() >2;
select empno, count() from emp where count() >2;
select empno, count() from emp group by empno having count() >2;

Answer

Correct Option: D

Question 13

In a database row is also called as

technology databases

Query
Attribute
Relation
Record

Answer

Correct Option: D

Question 14

which of the following denote single value function used in SQL

technology databases

AVG ( )
SQRT ( )
COUNT ( )
All the Above

Answer

Correct Option: B

Question 15

While creating tables the concept that is used to reduce redundancy in data is called

technology databases

Views
Aliases
Sequence
Normalization

Answer

Correct Option: D

Question 16

A table T1 having 100 rows is joined with a table T2 with 50 rows without specifying the joined column in the where clause then result will have

technology databases

100 rows
50 rows
150 rows
5000 rows

Answer

Correct Option: D

Question 17

Which isolation level doesn't exists

technology databases

Isolation level2
Isolation level3
Isolation level4
Isolation level1

Answer

Correct Option: C

Question 18

Which normal forms require that non-key columns be functionally dependent solely on the primary key?

technology databases

Second
Fifth
Third
None of above

Answer

Correct Option: C

Question 19

Which of the following options is FALSE about unchained mode in ASE

technology databases

A commit tran is always implied for every transaction.
Unchained mode is the default mode in ASE
The server does not issue the begin tran implicity
The value of @@tranchained is 0

Answer

Correct Option: A

Question 20

The modulos operator (%) CANNOT be used on the _____ datatype.

technology databases

Tinyint
Money
Float
Smallint

Answer

Correct Option: B

Description: databases Online Quiz - 62
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 62

AI Explanation

AI Explanation

Find more quizzes from top tags