Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology databases

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

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Queries based on set threshold are restricted by which tool?

Teradata Manager
BTEQ
Teradata SQL Assistant
TDQM

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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?

70 GB
50GB
30 GB
80 GB

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

In a COBOL source code the column range 8-11 indicates

Sequence Number Area
Indicator Area
Area A
Area B

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

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.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

An example of an OLTP environment is _____

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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?

70GB
80GB
10GB
30GB

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

How do I get contents of variables A, B displayed on the same output line using 2 DISPLAY statements

DISPLAY A,DISPLAY B
DISPLAY A DISPLAY B
DISPLAY A DISPLAY B WITH NO ADVANCING
DISPLAY A WITH NO ADVANCING DISPLAY B

Reveal answer Fill a bubble to check yourself

← Previous
1
2
…
2671
2672
2673
2674
2675
2676
2677
2678
2679
…
3670
3671
Next →