Free NR0-016 Exam Braindumps (page: 14)

Page 13 of 28

What are three characteristics of volatile tables? (Choose three.)

  1. They are materialized in spool space.
  2. Their table definitions are kept in cache.
  3. They are restricted to a single query statement.
  4. They require no Data Dictionary access or transaction locks.
  5. They do not have to be explicitly created in the current session with DDL.

Answer(s): A,B,D



What are three characteristics of Global Temporary tables? (Choose three.)

  1. They can be referenced from a macro.
  2. They can utilize permanent journaling.
  3. They can be created using the WITH DATA option.
  4. Their table definitions are stored in the Data Dictionary.
  5. They are materialized in the login user's temporary space.

Answer(s): A,D,E



A report of sales totals by day-of-week (i.e., Saturday sales, Sunday sales, etc.) is requested.
Which three techniques can be employed to design the query? (Choose three.)

  1. Use a minor entity table.
  2. Use the system calendar.
  3. Use the CASE statement.
  4. Use the SET SESSION DATEFORM statement.

Answer(s): A,B,C



You are creating an application to export some date values. You want to override the current default date form of INTEGERDATE with the statement SET SESSION DATEFORM=ANSIDATE; Which statement is true?

  1. Date values will be returned in CHAR(8) form.
  2. Date values will be returned in CHAR(10) form.
  3. The statement is syntactically incorrect as written.
  4. Date values will continue to be returned in INTEGER form.

Answer(s): B






Post your Comments and Discuss TeraData NR0-016 exam with other Community members:

NR0-016 Discussions & Posts