Free TE0-122 Exam Braindumps (page: 19)

Page 18 of 38

What is an appropriate use of a macro?

  1. drop databases
  2. insert new rows
  3. start load utilities
  4. create multiple users

Answer(s): A



Which data type is supported for Multi-Value Compression (MVC)?

  1. TIME
  2. FLOAT
  3. VARCHAR
  4. INTERVAL

Answer(s): A



Which function is needed when converting a character string to another server character set?

  1. CAST
  2. CONVERT
  3. INTERPRET
  4. TRANSLATE

Answer(s): A



Which statement will reduce the price of books by 10% for all books published by any division of the Blackwell group?

  1. UPDATE Books
    SET Book_list_price = Book_list_price * .90
    WHERE Books.Publisher_Id = Publisher.Publisher_Id
    AND Publisher_name = Blackwell;
  2. UPDATE Books
    SET Book_list_price = Book_list_price * .90
    WHERE Books.Publisher_Id = Publisher.Publisher_Id
    AND WHERE Publisher_name LIKE 'Blackwell%';
  3. UPDATE Books
    SET Book_list_price = Book_list_price * .90
    WHERE Publisher_Id IN
    (SELECT Publisher_Id
    FROM Publisher
    WHERE Publisher_name = Blackwell);
  4. UPDATE Books
    SET Book_list_price = Book_list_price * .90
    WHERE Publisher_Id IN
    (SELECT Publisher_Id
    FROM Publisher
    WHERE Publisher_name LIKE 'Blackwell%');

Answer(s): B






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

TE0-122 Discussions & Posts