0

databases Online Quiz - 77

Description: databases Online Quiz - 77
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. GRANT INDEX ON employee TO db2user WITH GRANT OPTION

  2. GRANT UPDATE (salary, bonus) ON employee TO PUBLIC WITH GRANT

  3. GRANT CONTROL ON employee TO PUBLIC WITH GRANT OPTION

  4. GRANT ALTERIN, CREATEIN, DROPIN ON schema1 TO db2user WITH GRANT


Correct Option: C
  1. System Catalog

  2. Client Applications

  3. Client Operating Systems

  4. Application Server


Correct Option: C,D

What is the teradata utility that load data into empty tables?

  1. Fastexp

  2. Fastload

  3. Multiload

  4. Bteq


Correct Option: B

Which of the following tables could be used for a user who wants to create a small Temporary table with Spool Space?

  1. Derived Table

  2. Volatile Table

  3. Global Temporary Table

  4. None


Correct Option: A,B

Teradata runs on which architecture ?

  1. shared memory

  2. shared nothing

  3. shared everything

  4. shared all


Correct Option: B
  1. Teradata Manager

  2. DBQM

  3. Queryman

  4. Teradata Warehouse builder


Correct Option: A

What does the ‘Help Table’ display?

  1. Column names, data type, Comments

  2. Column names, Indexes, data types, Comments

  3. Displays the table id, Column names, data types, Comments

  4. Tell the session number of the user


Correct Option: A

Which operator will be evaluated first in the following SELECT statement?

  1. +

  2. *

  3. -

  4. /


Correct Option: B
- Hide questions