Book Image

Documentum Content Management Foundations: EMC Proven Professional Certification Exam E20-120 Study Guide

By : Pawan Kumar
Book Image

Documentum Content Management Foundations: EMC Proven Professional Certification Exam E20-120 Study Guide

By: Pawan Kumar

Overview of this book

This is a complete study guide including study material and practice questions to prepare for the EMC Proven Professional certification Exam E20-120. It can also serve Documentum beginners and practitioners as a handy guide and quick reference to the technical fundamentals that is fully up to date for Documentum 5.3. Beginners are introduced to concepts in a logical manner while practitioners can use it as a reference to jump to relevant concepts directly.EMC Documentum is a leading enterprise content management technology platform that helps enterprises to streamline the capture, processing, and distribution of business information including documents, records, e-mails, web content, images, reports, and digital assets. It can also automate entire business processes in accordance with business rules. EMC Proven Professional is an exam-based certification program, which introduced a new EMC Proven Content Management Application Developer (EMCAD) track in early 2007. The first exam in this track is Content Management Foundations (CMF) Associate-level Exam, with exam code E20-120, which tests knowledge about technical fundamentals of Documentum. This book is a study guide to help you prepare for this exam with hundreds of practice questions and an efficient exam-preparation strategy.
Table of Contents (23 chapters)
Documentum Content Management Foundations
Credits
About the Author
Acknowledgement
About the Reviewers
Preface

Help—Some DQL Queries


Some helpful queries related to groups are described in this section. These queries are based on the information presented in this chapter.

The following query retrieves information about a group named interviewers:

SELECT group_name, group_address, owner_name, group_admin
FROM dm_group
WHERE group_name = 'interviewers'

The following query retrieves the names of the groups that a user named dmadmindev is a member of, directly or indirectly (through nested group memberships):

SELECT group_name
FROM dm_group
WHERE ANY i_all_users_names = 'dmadmindev'

The following query retrieves the names of the users and groups that are direct members of a group named admingroup:

SELECT users_names, groups_names
FROM dm_group
WHERE group_name = 'admingroup'

The following query retrieves the names of all the roles present in the repository:

SELECT group_name
FROM dm_group
WHERE group_class = 'role'