Latest Teradata Interview Questions and Answers pdf
- Which statement is true about an OLTP environment?
- Which statement is true about partitioned primary indexes (ppl)?
- What are two benefits of not requiring rows to be stored in order in a table?
- Which statement is true about a primary index operation?
- What are two reasons for choosing different columns for the primary index than are defined for the primary key?
- Which statement is true concerning job responsibilities of the Teradata DBA?
- In a two clique Teradata system, data is hashed across all AMPs?/a>
- A database administrator has defined a user with no permanent space. Which objects can be found in this user?
- Which statement is true about temporary space?
- Which statement about the functions of the PE are true?
- Which component can be involved in a connection between Teradata and a mainframe host?
- You have a Teradata system with 100 GB of permanent space and you create user A with 30 GB permanent space. If user A creates user B with 20 GB permanent space will user A have?
- What is function of an AMP?
- Which feature is unique to teradata?
- What is main feature of the Teradata database?
- Due to linear scalability, which can Teradata provider?
- Which utility allows you to copy a table and restore it to another Teradata database?
- Which tool restricts queries based on set threshould?
- Which utility performs block level operating against populated tables?
- Which tool and utility is part of the Teradata Analyst suite?
- Which statement is true about Fallback?
- Which feature of transient journaling ensure data integrity?
- Which statement is true about RAID 5 protection?
- Which statement about vproc migration during a node failure is true?
- Which is the characteristic of Active Data Warehousing?
- Which stage in the data warehouse usage evolution lead to Active Data Warehousing?
- What type of processing is needed in decision support data warehouse environment?
- Which type of data is found in data mart?
- What is benefit of a centrally located logical architecture?
- How many AMP(s) are typically when using a unique secondary index?
- What happens when a full table scan occurs on Teradata?
- How does Teradata handle data access?
- What type of indexes available in the Teradata RDBMS?
- How is data distributed with a partitioned primary index?
- Which is reason for a unique primary index (UPI)?
- What is advantage of a Teradata relational database?
- According to relational concepts, which is a characteristic of a row?
- What is characteristics of a Teradata RDBMS?
- What is relational database concepts that govern how rows, columns and tables are created?
- Due to linear scalability, which can Teradata provide?
- Why would you have two physical LAN connections per node connected to the customer’s network?
- Which feature is not unique to Teradata?
- Teradata Has been called a ---------------- architecture
- What are attributes of the teradata database.
- What does linear Scalability provide?
- Which two Statements are true concerning the benefits of a business model?
- Whoose the attributes which best describe OLTP?
- An rdbms lets you view the data as a collections of:
- Which two statements are true?
- Indexes are unique values:
- What ensures even data distribution?
- In tera data ,a full-table scan is extermeley rare and performed only when a user specifically requests it.
- Which statement about archival utilities are true?
- Vprocs in tera data systems communicate over the:
- Which statement about hashing are true?
- Aclique is a group of nodes that share access to the same:
- Duplicate rows are not allowed in:
- Which statement about rad is true?
- A fall back cluster is a group of:
- Which of these are rules for foreign keys in realitional theory
- Which statement about transient journals are true?
- Primarey key value
- Which statement about indexes is true?
- In teredata ‘s paraell enviourment, response time is as fast as:
- The sum of maximum spool speace limits for all databases and users can exceed the disk speace capacity, but the actual disk speace consumed is limited by the disk space capacity
- The sum of all perm and spoll speace consumed at any point in time cannot exceed the sum of all disk speace avallible on the system.
- A Clique provides protections in the event of a:
- All systems have one and only one clique:
- Which of the following statement is true because of the scalability of teradata?
- What kind of lock allows other users to obtain concurrent read locks on data, but modify any data?
- A data base may own which of the the following in its object hierarchy?
- Macros is:
- Which activity is required of a tera data dba?
- The explain statement in sql shows you:
- A teradata node:
- Which tera data analyst pack tool uses a query capture database to store query plan?
