Teradata Database Administration Test

Topics Covered

Logical Data Modelling

iMocha’s Teradata fundamentals 12 test helps recruiters and hiring managers to evaluate candidate’s understanding about logical data model which shows data in detail without being implemented to physical database

Teradata Database Administration

This test assesses a candidate’s understanding about Teradata studio which creates and administers the database objects

Teradata Physical Administration

Our test helps in evaluation of candidate’s knowledge about controlling physical access to database

Sample Questions

Choose from our 100,000+ question library or add your own questions to make powerful custom tests

Question types:

Multiple Option

Topic:

-

Difficulty:

Easy

Q 1. A table has been partitioned using the RANGE_N function and includes the NO RANGE and UNKNOWN partitions. There are gaps in the ranges and the designer needs to add new partitions to fill the gaps. The data in the NO RANGE partitions must be checked against the new partitions. Which procedure should be used?

Create another table with the new partition definition, then submit an INSERT SELECT statement to populate the new table.

Create another table with the new partition definition, then extract the data from the NO RANGE and UNKNOWN partitions and import the data into the new table.

Submit an ALTER TABLE statement to add the new partitions, extract the data from the NO RANGE and UNKNOWN partitions, and import the data into the existing table.

Submit an ALTER TABLE statement to add the new partitions, then data from the NO RANGE and UNKNOWN partitions will automatically be checked against the added partitions.

Question types:

Multiple Option

Topic:

-

Difficulty:

Easy

Q 2. Which action will help conserve disk space?

Set permanent space limits for each table that is created.

Specify a limit on spool space for users in their profile.

Use a low number for the cylinders saved for PERM setting.

Use the DBQL.LogSQL table instead of the DBQL.LogSummary table.

Question types:

Multiple Option

Topic:

-

Difficulty:

Easy

Q 3. What is a benefit of extrapolated and propagated statistics?

No statistics need to be collected.

Statistics only need to be collected once.

There is less need for frequent statistics collection.

Statistics are automatically collected as a background process.

You can customize this test by

Setting difficulty level of test

Choose easy, medium or hard questions from our skill libraries to assess candidates of different experience levels.

Combining multiple skills into one test

Add multiple skills in a single test to create an effective assessment. Assess multiple skills together.

Adding your own questions to the test

Add, edit or bulk upload your own coding questions, MCQ, whiteboarding questions & more.

Requesting a tailor-made test

Get a tailored assessment created with the help of our subject matter experts to ensure effective screening.

Trusted By

Pedro Furtado, Capacity Manager, Altran-Portugal

“Finding quality talent is a challenge more so when you consider the sheer number of resumes we get each year. To top this, the time we spent on our recruitment process was humongous. iMocha helped us to cut down on our candidate filtration time by 40 %, making it our preferred assessment tool.”

Teradata Database Administration 12 Test

10234+

120+

About Teradata Database Administration 12 Test

Test Summary

Useful for hiring

Topics Covered

Logical Data Modelling

Teradata Database Administration

Teradata Physical Administration

Sample Questions

Sample Report

Hire job-fit candidates using this test now

You can customize this test by

Setting difficulty level of test

Combining multiple skills into one test

Adding your own questions to the test

Requesting a tailor-made test

Related Skills

Trusted By

Pedro Furtado, Capacity Manager, Altran-Portugal

Start hiring job-fit candidates using this assessment