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

Which of the following statement will NOT allow db2user to grant the privileges specified in the statement to others?

  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

Assuming User1 has no privileges/Authorities , which of the following will only Allow USER1 to add data to table EMPLOYEE

  1. CONTROL

  2. UPDATE

  3. INSERT

  4. INSERT WITH GRANT OPTION


Correct Option: C
  1. System Catalog

  2. Client Applications

  3. Client Operating Systems

  4. Application Server


Correct Option: C,D
  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
  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
- Hide questions