Study Guides and Actual Real Exam Questions For Oracle OCP, MCSE, MCSA, CCNA, CompTIA


Advertise

Submit Braindumps

Forum

Tell A Friend

    Contact Us

 Home

 Search

Latest Brain Dumps

 BrainDump List

 Certifications Dumps

 Microsoft

 CompTIA

 Oracle

  Cisco
  CIW
  Novell
  Linux
  Sun
  Certs Notes
  How-Tos & Practices 
  Free Online Demos
  Free Online Quizzes
  Free Study Guides
  Free Online Sims
  Material Submission
  Test Vouchers
  Users Submissions
  Site Links
  Submit Site

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Online Training Demos and Learning Tutorials for Windows XP, 2000, 2003.

 

 

 

 





Braindumps for "NR0-017" Exam

Teradata Masters Update V2R5

 Question 1.
Which two attributes are copied for a CREATE TABLE from a subquery to the table being created? (Choose two.)

A. data types
B. FALLBACK option
C. column-level attributes
D. primary index
E. CHECK constraints

Answer: A, C

Question 2.
Which three features are associated with join indexes? (Choose three.)

A. a pre-aggregation of a single base table
B. the pre-join of multiple tables using INNER JOIN
C. the pre-join of multiple tables using FULL OUTER JOIN
D. a replicated subset of a single base table

Answer: A, B, D

Question 3.
You want to generate three mutually exclusive sample sets from a customer table.
SELECT customer_id, age, income, SAMPLEID
FROM customer_table

Which clause needs to be added to complete the task?

A. SAMPLE .6, .25, .10, .05 ;
B. SAMPLE .6, .25, .10, .05 WITH REPLACEMENT ;
C. SAMPLE .6, .25, .10 ;
D. SAMPLE .6, .25, .10 WITH REPLACEMENT ;

Answer: C

Question 4.
Consider the table t1 created as follows:
CREATE TABLE t1 (
a integer,
d date,
v varchar(100))
PRIMARY INDEX (a)
PARTITION BY RANGE_N(d BETWEEN
DATE '2001-01-01' AND DATE '2005-12-31'
EACH INTERVAL '7' DAY); and the query:
SELECT v FROM t1 WHERE d = DATE '2004-03-16';

Which plan does the Optimizer use to find qualifying rows?

A. full table scan on a single AMP
B. single partition scan on every AMP
C. value lookup on every AMP
D. hash lookup on each AMP
E. single partition scan on a single AMP

Answer: B

Question 5.
If neither RANGE_N nor CASE_N are used to define the number of partitions, how many partitions will the Optimizer assume?

A. 255
B. 0
C. 32767
D. 1
E. 65535

Answer: E

Question 6.
Which two statements are true concerning parameters within a stored procedure? (Choose two.)

A. Parameters and their attributes are always stored in the Data Dictionary.
B. Parameters can be used to build a dynamic SQL statement.
C. Parameters can be altered using the FORMAT clause.
D. Parameters can include status variables such as ACTIVITY_COUNT.

Answer: A, B

Question 7.
Which two tools can be used to alter database objects to improve workload performance? (Choose two.)

A. Teradata System Emulation Tool (TSET)
B. Teradata Visual Explain
C. Teradata Statistics Wizard
D. Teradata Index Wizard

Answer: C, D

Question 8.
Which three are attributes of an Active Data Warehouse? (Choose three.)

A. high availability
B. tactical queries
C. complex queries
D. expanding batch windows

Answer: A, B, C

Question 9.
Which join plan makes use of a primary index on each of two tables with matching partitioned primary indexes (PPIs)?

A. rowkey-based merge
B. nested
C. exclusion merge
D. rowhash merge

Answer: A

Question 10.
You are evaluating the possible use of a hash index on a multi-terabyte table. 

Which two factors complicate the implementation of a hash index on such a table? (Choose two.)

A. A partitioned primary index (PPI) is defined on the table.
B. A large number of users access the table.
C. Triggers are defined on the table.
D. The maintenance job for the table is MultiLoad.

Answer: C, D

Question 11.
What are two characteristics of the COMPRESS clause? (Choose two.)

A. It can be defined so a specific value is not stored in each row.
B. It compresses repeating 1s and 0s.
C. It can be used on character data types only.
D. It supports multiple values per column.

Answer: A, D



Google
 
Web www.certsbraindumps.com


Study Guides and Real Exam Questions For Oracle OCP, MCSE, MCSA, CCNA, CompTIA





              Privacy Policy                   Disclaimer                    Feedback                    Term & Conditions

www.helpline4IT.com

ITCertKeys.com

Copyright © 2004 CertsBraindumps.com Inc. All rights reserved.