Free TE0-122 Exam Braindumps (page: 16)

Page 15 of 38

Which statement will correctly remove all granted privileges except the SELECT privilege on Database1 from Role1?

  1. REVOKE ALL BUT SELECT FROM Role1 ON Database1;
  2. REVOKE ALL BUT SELECT ON Database1 FROM Role1;
  3. REVOKE EACH BUT SELECT FROM Role1 ON Database1;
  4. REVOKE EACH BUT SELECT ON Database1 FROM Role1;

Answer(s): D



Which DCL statement is written correctly to remove the UPDATE privilege?

  1. REVOKE UPDATE ON Database1 FROM Role1;
  2. REVOKE UPDATE FROM Role1 ON Database1;
  3. REVOKE UPDATE ON Database1 FROM Role1 WITH ADMIN OPTION;
  4. REVOKE UPDATE FROM Role1 ON Database1 WITH GRANT OPTION;

Answer(s): C



A manager walks by a Teradata workstation and sees someone has left for the day but did not log out of Teradata.
Which built-in function could be used to determine which login name is assigned to this session?

  1. USER
  2. SESSION
  3. ACCOUNT
  4. DATABASE

Answer(s): D



Given the following data (? indicates null):

Name FAX Line Cell Phone Work Phone
Hammer (301)457-9023 (301)640-9123 ?
Taylor ? (513)153-9346 (513)560-5481
Heidema (679)840-9277 ? (679)678-2351
Jones ? (451)546-9225 (451)678-0364

When run against the given data, which COALESCE function will produce an error message?

  1. COALESCE(FaxLine)
  2. COALESCE(NULL, NULL)
  3. COALESCE(NULL, Cellphone, WorkPhone)
  4. COALESCE(FaxLine, CellPhone, WorkPhone)

Answer(s): D






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

TE0-122 Discussions & Posts