NR0-013 Teradata V2R5 in the SQL Certified Practice Exam

Sample Questions

Q) Which three statements are true representations of the definitions? (Choose three.)

a) You can create an index on the view.

b) You can use derived tables in the presentation

c) You can use the ORDER BY clause in the view. You can perform aggregation within a single species.

d) You can assign a new column names in one view.

Q) Which statement executes parameterized macro with the name ABC?

a) EXEC ABC (10, ‘ABC’);

b) EXEC ABC (10 ,: ‘ABC’);

c) EXEC ABC VALUES (10, ‘ABC’);

d) EXEC MACRO ABC (10, ‘ABC’);

e) None

Q) What three qualities of opinions? (Choose three.)

a) Presentation may include the item was.

b) Views can be used to update the table.

c) Visits need to change if the columns added to the table.

d) The views are not affected if the columns added to the table.

e) Views provide an additional level of security or authorization

Q) What are the three safety reasons, to use a macro? (Choose three.)

a) This limits the need to grant privileges on tables and views that are used in the macro.

b) An advantage of creating a macro can be limited to designated developers

c) Parameterized macro can be designed to use a parameter for the management table or view, to get the macro.

d) Parameterized macro can be designed to use a parameter to restrict the access to a subset of data for the table or view that is used in the macro.