ADB Certification Exam UPDATED
ACTUAL QUESTIONS AND CORRECT
ANSWERS
SQL DDL (Data Definition Language) - CORRECT ANSWER Change the structure of
the database schema in some way. Typically by creating, deleting, or modifying schema
objects such as databases, tables, and views. Most DDL statements start with CREATE,
DROP, or ALTER. Statements for the Creation and Management of Analytic Views.
24.2 Privileges for Analytic Views - CORRECT ANSWER Describes the system and
object privileges available for analytic views, attribute dimensions, and hierarchies
Create Analytic View - CORRECT ANSWER Create an analytic view in the grantee's
schema
Create ANY Analytic View - CORRECT ANSWER Create analytic views in any
schema except SYS
Create Attribute Dimension - CORRECT ANSWER Create an attribute dimension in
the grantee's schema
Create ANY Attribute Dimension - CORRECT ANSWER Create attribute dimensions
in any schema except SYS
Create Hierarchy - CORRECT ANSWER Create a hierarchy in the grantee's schema.
Create ANY Hierarchy - CORRECT ANSWER Create hierarchies in any schema
except SYS
Alter ANY Analytic View - CORRECT ANSWER Rename analytic views in any
schema except SYS
, Alter ANY Attribute Dimension - CORRECT ANSWER Rename attribute dimensions
in any schema except SYS
Alter ANY Hierarchy - CORRECT ANSWER Rename hierarchies in any schema
except SYS
Drop ANY Analytic View - CORRECT ANSWER Drop analytic views in any schema
except SYS
Drop ANY Attribute Dimension - CORRECT ANSWER Drop attribute dimensions in
any schema except SYS
Select ANY table - CORRECT ANSWER Query or view any analytic view or
hierarchy in any schema
Alter - CORRECT ANSWER Rename the analytic view, attribute dimension, or
hierarchy
Read - CORRECT ANSWER Query the object with the SELECT statement
Select - CORRECT ANSWER Query the object with the SELECT statement
Validate Analytic View/Hierarchy Object Procedures - CORRECT ANSWER Use the
DBMS-HIERARCHY package
*CREATE_VALIDATE_LOG_TABLE
*VALIDATE_ANALYTIC_VIEW
*VALIDATE_CHECK_SUCCESS
*VALIDATE_HIERARCHY
ACTUAL QUESTIONS AND CORRECT
ANSWERS
SQL DDL (Data Definition Language) - CORRECT ANSWER Change the structure of
the database schema in some way. Typically by creating, deleting, or modifying schema
objects such as databases, tables, and views. Most DDL statements start with CREATE,
DROP, or ALTER. Statements for the Creation and Management of Analytic Views.
24.2 Privileges for Analytic Views - CORRECT ANSWER Describes the system and
object privileges available for analytic views, attribute dimensions, and hierarchies
Create Analytic View - CORRECT ANSWER Create an analytic view in the grantee's
schema
Create ANY Analytic View - CORRECT ANSWER Create analytic views in any
schema except SYS
Create Attribute Dimension - CORRECT ANSWER Create an attribute dimension in
the grantee's schema
Create ANY Attribute Dimension - CORRECT ANSWER Create attribute dimensions
in any schema except SYS
Create Hierarchy - CORRECT ANSWER Create a hierarchy in the grantee's schema.
Create ANY Hierarchy - CORRECT ANSWER Create hierarchies in any schema
except SYS
Alter ANY Analytic View - CORRECT ANSWER Rename analytic views in any
schema except SYS
, Alter ANY Attribute Dimension - CORRECT ANSWER Rename attribute dimensions
in any schema except SYS
Alter ANY Hierarchy - CORRECT ANSWER Rename hierarchies in any schema
except SYS
Drop ANY Analytic View - CORRECT ANSWER Drop analytic views in any schema
except SYS
Drop ANY Attribute Dimension - CORRECT ANSWER Drop attribute dimensions in
any schema except SYS
Select ANY table - CORRECT ANSWER Query or view any analytic view or
hierarchy in any schema
Alter - CORRECT ANSWER Rename the analytic view, attribute dimension, or
hierarchy
Read - CORRECT ANSWER Query the object with the SELECT statement
Select - CORRECT ANSWER Query the object with the SELECT statement
Validate Analytic View/Hierarchy Object Procedures - CORRECT ANSWER Use the
DBMS-HIERARCHY package
*CREATE_VALIDATE_LOG_TABLE
*VALIDATE_ANALYTIC_VIEW
*VALIDATE_CHECK_SUCCESS
*VALIDATE_HIERARCHY
