(No title)
Practice 2 – Question 10
Question : A clique is a group of nodes that share access to the same: Options : Network connections Disk arrays PEs Clique setting software Click HERE to check Answer Answer: Previous Next
Practice 2 – Question 12
Question : Which two statements about RAID is true? (Choose two) Options : RAID 1 uses mirroring to provide data protection. RAID 1 uses parity to provide data protection. RAID 5 uses mirroring to provide data protection. RAID 5 uses parity to provide data protection. Click HERE to check Answer Answer: Previous Next
Practice 2 – Question 13
Question : A fallback cluster is a group of: Options : AMPs Disk arrays Cliques Nodes Click HERE to check Answer Answer: Previous Next
Practice 2 – Question 14
Question : Which two of these are rules for foreign keys in relational theory? (Choose two) Options : A foreign key value may be non – unique. A foreign key always affects how relational data is distributed. A foreign key must exist as a primary key in a related table. A table must have one …
Practice 2 – Question 15
Question : Which two statements about transient journal are true? (Choose two) Options : Automatically maintains data integrity when in flight transactions are interrupted. Allows continued system operation while an AMP is down. Provide full table recovery to a specific point in time. Data is returned to its original state after a transaction failure. Click …
Practice 2 – Question 3
Question : An RDBMS let you view the data as a collection of: Options : Indexes Tables Rows Columns Click HERE to check Answer Answer: Previous Next
Practice 2 – Question 4
Question : According to the data model a column should contain: Options : Disparate data Tera data Atomic data Compound data Click HERE to check Answer Answer: Previous Next
Practice 2 – Question 5
Question : Which two statements are two? (Choose two) Options : In Teradata, a database must always contains tables A Teradata database must always have perm space allocated to it In the Teradata data structure, a user is similar to a database A user must always have a password Click HERE to check Answer Answer: …
Practice 2 – Question 6
Question : In a Teradata database a full scan is extremely rare and performed only when a user specifically requests it. Options : True False Click HERE to check Answer Answer: Previous Next
Practice 2 – Question 7
Question : Which three statements about archival utilities are true? (Choose three) Options : ARC is available on channel – attached mainframes and network attached clients. NetValut is available on Microsoft windows, and NetBackup is available on UNIX MP-RAS. ARC is used along with NetValut or NetBackup in network-attached client environments. Teradata database archival utilities …
Practice 2 – Question 8
Question : Vprocs in a Teradata database system communicate over the: Options : MTDP(Micro Teradata Director Program) Channel communication Vnet BYNET Click HERE to check Answer Answer: Previous Next
Practice 2 – Question 9
Question : Which two statements about hashing are true? (Choose two) Options : The uniqueness value is a component of the row hash value. Two primary index values that hash to the same row hash value are called hash synonyms. In a table that has a NUPI, all rows with the same NUPI value are …
Practice 2 – Question 1
Question : What ensures even data distribution? Options : Data that is correctly partitioned prior to loading. A primary index column with unique values. Many tables related to each other. Tables with an even number of rows. Click HERE to check Answer Answer: Home Next
Practice 2 – Question 11
Question : Duplicate rows are not allowed in Options : The Teradata database The ANSI standard Tables distributed across AMPs based on a NUPI The relational model Click HERE to check Answer Answer: Previous Next
Practice 2 – Question 2
Question : Primary index values cannot be NULL: Options : True False Click HERE to check Answer Answer: Previous Next
Sponsors of Teradata Tech
