NR0-012 Teradata Physical Implementation V2R5 Practice Exam Set 3

When defining an instance of Referential integrity on a Teradata table, which three of the following rules are relevant? (Choose three)


Options are :

  • References may be specified with a NO CHECK option (Correct)
  • There is a limit of 16 columns in a single foreign key. (Correct)
  • The foreign key may reference columns in a global temporary table.
  • The same column may appear more than once in the foreign key
  • If no columns are specified for the referenced table then that table must have a single column primary key or a single column specified with the unique constraint. (Correct)

Answer : References may be specified with a NO CHECK option There is a limit of 16 columns in a single foreign key. If no columns are specified for the referenced table then that table must have a single column primary key or a single column specified with the unique constraint.

The implementation of Referential Integrity constraints can be justified by which two reasons? (Choose two)


Options are :

  • provides the Optimizer with a means for devising better query plans (Correct)
  • allows referencing values to exist without a corresponding referenced value
  • requires more application programming to enforce constraints
  • Ensure data integrity and consistency between Primary and Foreign key columns (Correct)

Answer : provides the Optimizer with a means for devising better query plans Ensure data integrity and consistency between Primary and Foreign key columns

All AMPs are required by which three of the following join methods? (Choose three)


Options are :

  • Merge Joins (Correct)
  • Product Joins (Correct)
  • Nested Joins
  • Hash Joins (Correct)

Answer : Merge Joins Product Joins Hash Joins

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 5

Of the following, which are three features of a global temporary table? (Choose three)


Options are :

  • Temporary space is used to materialize the table. (Correct)
  • Spool space is used to materialize the table
  • Rows are lost following a system restart.
  • Definitions are stored in the data directory (Correct)
  • Rows are deleted at session end. (Correct)

Answer : Temporary space is used to materialize the table. Definitions are stored in the data directory Rows are deleted at session end.

Merge Joins are best described by which two requirements? (Choose two)


Options are :

  • A complete copy of the smaller table must be duplicated on every AMP.
  • There is a join constraint of either EQUAL (=) or NOT EQUAL( < > ) (Correct)
  • Join condition values are not required to eliminate hash collisions
  • Both tables are sorted by row hash or byrowkey (Correct)

Answer : There is a join constraint of either EQUAL (=) or NOT EQUAL( < > ) Both tables are sorted by row hash or byrowkey

With reference to identity columns, which of the following are two accurate statements?(Choose two)


Options are :

  • Only one can be specified per table. (Correct)
  • They need not be a primary index column. (Correct)
  • They can be primary index of a table with atomicupsert operations
  • They can be part a composite primary index.

Answer : Only one can be specified per table. They need not be a primary index column.

TE0-121 Teradata Basics Practice Test Set 2

Which index type is a Partitioned Primary Index a substitute for?


Options are :

  • VALUE-ORDERED SECONDARY INDEX (Correct)
  • NON-UNIQUE PRIMARY INDEX
  • MULTI-TABLE JOIN INDEX
  • UNIQU PRIMARY INDEX

Answer : VALUE-ORDERED SECONDARY INDEX

When is NUSI bit mapping used, if you assume that the necessary statistics have been collected?


Options are :

  • when the query ANDs two more indexes with the bit mapping option
  • when two or more weakly selective indexed conditions areORed and the combination is strongly selective
  • when at least one of the NUSI is NULL
  • when two or more weakly selective indexed conditions areANDed and the combination is strongly selective (Correct)

Answer : when two or more weakly selective indexed conditions areANDed and the combination is strongly selective

What are two characteristics of derived tables? (Choose two)


Options are :

  • Rows are maintained following a system restart.
  • Temporary space is used to materialize table
  • Definitions are stored in the data dictionary
  • Spool space is used to materialize table (Correct)
  • Rows are deleted when the query ends. (Correct)

Answer : Spool space is used to materialize table Rows are deleted when the query ends.

TE0-121 Teradata Basics Practice Test Set 4

What benefit does a covered query have?


Options are :

  • All columns required by the query have appropriate access rights for this user.
  • All columns required by the query are contained in a single table
  • All columns required by the query exist in the specified tables.
  • All columns required by the query are available via a join index (Correct)

Answer : All columns required by the query are available via a join index

Which LOCKING modifier should you employ to avoid waiting on conflicting locks?


Options are :

  • OVERRIDE CURRENT LOCK
  • LOCKING ROW NOWAIT (Correct)
  • LOCKING ROW FOR EXCLUSIVE
  • UNLOCK ROW

Answer : LOCKING ROW NOWAIT

Which conditions does the following term refer to in the join step of an EXPLAIN? "residual condition"


Options are :

  • conditions that reside in cache
  • conditions that do not need to be applied to joined rows
  • conditions that must be applied after one or more JOIN conditions have been applied (Correct)
  • Conditions that are applied according to the WHER conditions ofUNIONed Select statements

Answer : conditions that must be applied after one or more JOIN conditions have been applied

TE0-141 14 Teradata Basics Certified Practice Test Set 4

What is indicated by BMSMS (Bit Map Set Manipulation Step) in the EXPLAIN output?


Options are :

  • The rows in the spool file are manipulated by hash code using a uniqueness sort to eliminate duplicate rows.
  • The data row associated with the rowed is accessed only if the associated bit is turned on in the static bit map.
  • Two or more NUSIs are intersected byANDing them to form one large bit map. (Correct)
  • Rows are selected based on manipulating the unique secondary index bit map.

Answer : Two or more NUSIs are intersected byANDing them to form one large bit map.

Which of the following two options will allow the user to avoid waiting for a write lock currently on a table? (Choose two)


Options are :

  • LOCKING table 1 FOR SHARE
  • LOCKING table 1 FOR READ
  • LOCKING table 1 FOR ACCESS (Correct)
  • LOCKING ROW FOR ACCESS (Correct)
  • LOCKING ROW FOR WRITE

Answer : LOCKING table 1 FOR ACCESS LOCKING ROW FOR ACCESS

For which two types of tables are Partitioned Primary Indexes best suited? (Choose two)


Options are :

  • large, tables that are frequently accessed using restrictive conditions (Correct)
  • large tables that are frequently accessed for Referential Integrity checks
  • large, tables that are not referenced using range constraints
  • large tables that are maintained by deleting and adding ranges of rows (Correct)

Answer : large, tables that are frequently accessed using restrictive conditions large tables that are maintained by deleting and adding ranges of rows

TE0-141 14 Teradata Basics Certified Practice Test Set 1

Which of the following best describes the lifespan of a transaction lock?


Options are :

  • four minutes after the lock is initiated
  • four hours after the lock is installed
  • until the user release the lock (Correct)
  • based on time out setting
  • two minutes after another user requests the resource

Answer : until the user release the lock

Which two of the following statements are true if an EXPLAIN output contains the following phrase? (Choose two)"with high confidence"


Options are :

  • One input relation has high confidence and the other has high or index join confidence (Correct)
  • Restricting conditions exist on an index or column that has collected statistics. (Correct)
  • Restricting conditions exist on an index that has collected statistics but isORed with another column having collected statistics.
  • One input relation has high confidence and the other has low confidence

Answer : One input relation has high confidence and the other has high or index join confidence Restricting conditions exist on an index or column that has collected statistics.

NR0-016 NCR Teradata Application Development V2R5 Exam Set 2

Which three statements are true if an EXPLAIN output contains one of the following phrases? (Choose three)"a single partition of" or "#partitions of"


Options are :

  • The query has a range constraint on the partitioning columns. (Correct)
  • Indicates that the table is being accessed using a sparse index
  • The query has an equality constraint on the partitioning column. (Correct)
  • Indicates AMPs will only access a single partition or #partitions of a table. (Correct)

Answer : The query has a range constraint on the partitioning columns. The query has an equality constraint on the partitioning column. Indicates AMPs will only access a single partition or #partitions of a table.

Which two of the following statements regarding nested views are true at query execution time? (Choose two)


Options are :

  • Nested views are not updatable
  • Teradata validates nested view privileges of the executing user at execution time. (Correct)
  • Maximum size of the fully expanded text is 2 MB (Correct)
  • If the view contains WITH CHECK OPTION, the WHERE clause used in defining the view is ignored.

Answer : Teradata validates nested view privileges of the executing user at execution time. Maximum size of the fully expanded text is 2 MB

When you compress multiple values for a column, where is it stored?


Options are :

  • in the column header
  • in the row header
  • in the table header (Correct)
  • in the presence bytes

Answer : in the table header

TE0-121 Teradata Basics Practice Test Set 4

While a user holds a READ lock on a Table, a second user requires a WRITE lock on the same table and is waiting for the first user to finish. What will happen if a third user requests an ACCESS lock on the same table?


Options are :

  • The third user's request is queued behind the WRITE lock request.
  • A READ lock is granted and the request proceeds.
  • An ACCESS lock is granted and the request proceeds. (Correct)
  • A SHARE lock is granted and the request proceeds.

Answer : An ACCESS lock is granted and the request proceeds.

What curtails row redistributions when a table has a multi-column (composite) primary key?


Options are :

  • Avoiding creating secondary indexes on any column other than the columns included in the primary key.
  • Using an identify column to ensure that the rows are evenly distributed
  • Defining a UPI over the primary key columns to get better row distribution
  • defining a NUPI over the columns most frequently joined. (Correct)

Answer : defining a NUPI over the columns most frequently joined.

Which is a true statement regarding join indexes?


Options are :

  • They can be assigned a different primary index from the base table (Correct)
  • They can be used on a table with triggers and Referential integrity constraint
  • They can be processed usingMultiload
  • They can be used to define Full Outer Joins

Answer : They can be assigned a different primary index from the base table

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 3

The same hash result is generated by which data types? (Choose two)


Options are :

  • INTEGER and DATE (Correct)
  • BYTE and NUMERIC
  • DATE and CHAR
  • CHAR and VARBYTE
  • CHAR and VARCHAR (Correct)

Answer : INTEGER and DATE CHAR and VARCHAR

Of the following, which is the type of join that locates a single row using a unique value, then uses the join condition value from the acquired row to access another table using an index?


Options are :

  • Nested Join (Correct)
  • Hash Join
  • Merge Join
  • Indexed Join
  • Product Join

Answer : Nested Join

Which two factors is the Optimizer allowed to predict because of collected statistics on a Teradata table? (Choose two)


Options are :

  • the size of spool files (Correct)
  • the AMP to send data to
  • the number of occurrences of a value (Correct)
  • the PE that will be assigned to the process

Answer : the size of spool files the number of occurrences of a value

TE0-121 12 Teradata Basics Certification Practical Exam Set 5

When you create a primary index, which three of the following options should be taken into consideration? (Choose three)


Options are :

  • If third normal form you must use a primary key E. Duplicate values are not stored in the same block
  • Columns frequently used for row selection are good candidates (Correct)
  • Primary index values should not be subject to change (Correct)
  • Very non-unique values can cause premature "database full" conditions. (Correct)

Answer : Columns frequently used for row selection are good candidates Primary index values should not be subject to change Very non-unique values can cause premature "database full" conditions.

Which three of the following statements pertaining to multi-value compression are correct?(Choose three)


Options are :

  • NULLs must be the first value in amultivalue list.
  • Maximum number of distinct constant values in the list is 255 plus nulls. (Correct)
  • Values can appear in any order. (Correct)
  • NULL cannot appear in the list if the column is declared NOT NULL (Correct)
  • A value list may contain duplicates.

Answer : Maximum number of distinct constant values in the list is 255 plus nulls. Values can appear in any order. NULL cannot appear in the list if the column is declared NOT NULL

Of the following, which three statements pertaining to COLLECT STATISTICS are true? (Choose three)


Options are :

  • Statistics can be collected on a maximum of 512 columns und indexes per table. (Correct)
  • Statistics can be calculated using a sample of the table data. (Correct)
  • Statistics can be collected on a maximum of 40 columns and indexes per table.
  • Statistics can be useful in determining which AMPs will be accessed for query processing.
  • Multi-column collection can be done at the column level without creating an index. (Correct)

Answer : Statistics can be collected on a maximum of 512 columns und indexes per table. Statistics can be calculated using a sample of the table data. Multi-column collection can be done at the column level without creating an index.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 1

To avoid data conversion, what should you do?


Options are :

  • Administer data type assignments at the domain level (Correct)
  • Use byte data types whenever possible
  • Use secondary indexes to provide another path to the data type
  • Use character data types as often as possible to allow for ease of conversion when necessary

Answer : Administer data type assignments at the domain level

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions