NCR NR0-017 Tera data Masters Update V2R5 Practice Exam

Sample Questions

Q) Which two statements are true regarding the parameters within a stored procedure? (Pick one.)

a) The parameters and their attributes are always stored in the Data Dictionary.

b) Parameters can be used to create dynamic SQL statement.

c) The parameters can be modified using the FORMAT clause.

d) The parameters may include status as ACTIVITY_COUNT variables.

Q) What are the two tools can be used to alter the database objects to improve the performance of workloads? (Pick one.)

a) Teradata Tool emulation system (TSET)

b) . Teradata Visual Explain

c) Teradata Statistics Wizard

d) Teradata indices Guided

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

a) high availability

b) tactical queries

c) complex queries

d) expansion batch windows

Q) What brands combine floor controller of a primary index on each of the two tables with the correspondence partitioned primary indexes (PPI)?

a) Merge rowkey-based

b) nested

c) exclusion union

d) merge rowhash

Q) It is considering the possibility of using a hash index of a multi-terabyte table. What are the two factors that complicate the implementation of a hash index on a table that? (Pick one.)

a) A primary partitioned index (PPI) is defined in the table.

b) A large number of users access to the table

c) Triggers are defined in the table.

d) The maintenance work to the table is MultiLoad.