Free TE0-122 Exam Braindumps (page: 9)

Page 8 of 38

Which DCL statement is written correctly?

  1. GRANT ALL ON Database1 TO User1 WITH GRANT;
  2. GRANT ALL ON Database1 TO User1 WITH ADMIN;
  3. GRANT ALL ON Database1 TO User1 WITH ADMIN OPTION;
  4. GRANT ALL ON Database1 TO User1 WITH GRANT OPTION;

Answer(s): C



Which attribute function will return information about how a named expression will display?

  1. TYPE
  2. FORMAT
  3. DISPLAY
  4. DEFAULT

Answer(s): D



An SQL developer is asked to develop a set of performance monitoring reports. The development team has decided to code the reports using derived tables to aggregate the system performance reports.
Which three are benefits of using a derived table in the report coding process? (Choose three.)

  1. Data distribution will be controlled by defining the primary index.
  2. The derived tables will be defined in the Data Dictionary for reuse.
  3. SQL coding will take fewer steps than using temporary table solutions.
  4. The temporary data will be available after the SQL request has completed.
  5. Column data types will be automatically defined except for casting requirements.
  6. The derived tables will not require the use of temporary space for materialization.

Answer(s): B,C,F



Which statement is true regarding session transaction mode in Teradata?

  1. ANSI mode can be set after logon.
  2. The same query might return different results in each mode.
  3. All ANSI features work inTeradata mode but not all Teradata features work in ANSI mode.
  4. AllTeradata features work in ANSI mode but not all ANSI features work in Teradata mode.

Answer(s): D






Post your Comments and Discuss TeraData TE0-122 exam with other Community members:

TE0-122 Discussions & Posts