Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
CWNP exams CWNP
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
GIAC exams GIAC
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
ISEB exams ISEB
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

Teradata TE0-123 Exam - Cheat-Test.com

Free TE0-123 Sample Questions:

Q: 1
Which type of Referential Integrity allows the Optimizer to utilize join elimination in the generated plan but does not enforce any restrictions when data is inserted, deleted, or updated?
A. Soft RI
B. Batch RI
C. Explicit RI
D. Standard RI
E. Application RI
Answer: C

Q: 2
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?
A. Create another table with the new partition definition, then submit an INSERT SELECT statement to populate the new table.
B. Create another table with the new partition definition, thenextract the data from the NO RANGE and UNKNOWN partitions and import the data into the new table.
C. 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.
D. 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.
Answer: C

Q: 3
Which method could be used to uncover embedded views when applications are running longer than agreed upon in Service Level Agreements (SLAs)?
A. Analyze Total CPU Time, Total I/O Count, and Elapsed Time in TDWM.
B. Read the EXPLAIN plan to find similar steps that repeat excessively.
C. Use the DBQL Summary table to identify individual queries and evaluate query performance.
D. UseTeradata Workload Analyzer to identify queries and calculate Service Level Goals (SLGs).
Answer: D

Q: 4
Which two statements are true about UPIs? (Choose two.)
A. They must be defined as NOT NULL.
B. The database can perform partial-value searches on them.
C. They may be a referenced column in a Referential Integrity constraint.
D. The Optimizer can derive demographical information even without collected statistics.
Answer: B, D

Q: 5
A database restore is being performed when a restart occurs. A user attempts to submit queries against one of the tables that was being restored, but the query fails. Why is the user's query unable to complete?
A. The RELEASE LOCK statement was not executed against the table.
B. The RELEASE LOCK statement was not executed against the database.
C. The rollback operation is not complete and the utility locks remain.
D. Therollforward operation is not complete and the utility locks remain.
Answer: A

Q: 6
Which action will help conserve disk space?
A. Set permanent space limits for each table that is created.
B. Specify a limit on spool space for users in their profile.
C. Use a low number for the Cylinders saved forPERM setting.
D. Use theDBQL.LogSQL table instead of the DBQL.LogSummary table.
Answer: C

Q: 7
An application is being ported to Teradata that stores and calculates metrics using a variety of large integers. Both 128-bit and 256-bit integers are required to capture the results of complex calculations. Which Teradata data type should be used for these large integers?
A. UDT
B. BIGINT
C. VARBYTE
D. INTEGER
Answer: D

Q: 8
In DBSControl, FreeSpacePercent=5, PermDBSize=254, and PermDBAllocUnit=1. FastLoad is used to load 100,000,000 rows into a data table and TPump is then used to add 25,000,000 rows to the same table. When creating this table, which option can be used to minimize the amount of space that this table will use after both loads have completed?
A. FREESPACE=0
B. FREESPACE=15
C. CHECKSUM=LOW
D. MINIMUM DATABLOCKSIZE
E. MAXIMUM DATABLOCKSIZE
Answer: A

Q: 9
The following repositories need to be created on a system: - a repository holding the retail data - a repository holding the inventory data - a repository holding views for each - a repository holding stored procedures (includes some dynamic SQL procedures) Which one must be implemented as a User with space allocated?
A. views
B. retail data
C. inventory data
D. stored procedures
Answer: A


© 2014 Cheat-Test.com, All Rights Reserved