ADB Certification Test Questions and Answers

ADB Certification Test Questions and
Answers



SQL DDL (Data Definition Language) - 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 - Answer-Describes the system and object privileges available for
analytic views, attribute dimensions, and hierarchies



Create Analytic View - Answer-Create an analytic view in the grantee's schema



Create ANY Analytic View - Answer-Create analytic views in any schema except SYS



Create Attribute Dimension - Answer-Create an attribute dimension in the grantee's schema



Create ANY Attribute Dimension - Answer-Create attribute dimensions in any schema except SYS



Create Hierarchy - Answer-Create a hierarchy in the grantee's schema.



Create ANY Hierarchy - Answer-Create hierarchies in any schema except SYS

, Alter ANY Analytic View - Answer-Rename analytic views in any schema except SYS



Alter ANY Attribute Dimension - Answer-Rename attribute dimensions in any schema except SYS



Alter ANY Hierarchy - Answer-Rename hierarchies in any schema except SYS



Drop ANY Analytic View - Answer-Drop analytic views in any schema except SYS



Drop ANY Attribute Dimension - Answer-Drop attribute dimensions in any schema except SYS



Select ANY table - Answer-Query or view any analytic view or hierarchy in any schema



Alter - Answer-Rename the analytic view, attribute dimension, or hierarchy



Read - Answer-Query the object with the SELECT statement



Select - Answer-Query the object with the SELECT statement



Validate Analytic View/Hierarchy Object Procedures - Answer-Use the DBMS-HIERARCHY package

*CREATE_VALIDATE_LOG_TABLE

*VALIDATE_ANALYTIC_VIEW

*VALIDATE_CHECK_SUCCESS

*VALIDATE_HIERARCHY