EMC Legato Cert E20-120 Questions & Answers

• Question 71:

  Which DQL statement is used to run server methods?

  A. REGISTER

  B. COMMIT

  C. EXECUTE

  D. BEGIN

  Correct Answer: C

• Question 72:

  What is a key feature of Composer Projects?

  A. enhanced user security

  B. portability between repositories

  C. convenient method of importing user accounts

  D. integration of workflows with virtual documents

  Correct Answer: B

• Question 73:

  Which statement is true about installing a Composer Project in a repository?

  A. Multiple Projects can co-exist in a single repository.

  B. Previously installed Projects must be uninstalled first.

  C. Previously installed Projects are automatically uninstalled.

  D. The Project cannot be installed in more than one repository managed by the same Content Server.

  Correct Answer: A

• Question 74:

  Which statement about the DQL WHERE clause is true?

  A. It narrows a search by specifying search conditions.

  B. It specifies which object properties should be retrieved.

  C. It specifies the order in which search results should be returned.

  D. It indicates which Documentum repository should be searched.

  Correct Answer: A

• Question 75:

  An external table has been registered using this DQL statement:

  REGISTER TABLE area_code_table (city STRING(256), area_code STRING(3))

  Which DQL statement will return the area_code for New York?

  A. SELECT area_code FROM dm_area_code_table WHERE city = 'New York'

  B. SELECT area_code FROM dm_dbo.area_code_table WHERE city = 'New York'

  C. SELECT area_code FROM area_code_table (ALL) WHERE area_code_table.city = 'New York'

  D. SELECT area_code_table FROM area_code WHERE city = 'New York'

  Correct Answer: B

• Question 76:

  Which statement about DQL is true?

  A. DQL can create, retrieve, update and delete objects in a Documentum repository.

  B. DQL can process and manipulate object content in a Documentum repository.

  C. DQL can retrieve and update objects in a Documentum repository, but cannot create or delete them.

  D. DQL can import documents into a Documentum repository from any JSR-170-compliant content management system.

  Correct Answer: A

• Question 77:

  What is returned by the following query?

  SELECT * FROM dm_document WHERE owner_name = 'dm_admin'

  A. zero or one property of dm_documents

  B. all properties of objects created by dm_admin

  C. all versions of dm_document objects owned by user dm_admin

  D. a predefined list of properties from dm_document objects owned by dm_admin

  Correct Answer: D

• Question 78:

  Which forms of the FROM clause will search all objects of the SOP type?

  A. SOP (*)

  B. ALL (SOP)

  C. SOP (ALL)

  D. SOP *

  Correct Answer: C

• Question 79:

  A repository has a custom object type, my_report, which descends from dm_document. A user wants to

  find all versions of dm_document and my_report objects checked out by them.

  How can the user complete the following query to accomplish this?

  select * from _____ where r_lock_owner=user

  A. dm_document

  B. dm_document (all)

  C. dm_document descend

  D. dm_document or my_report

  Correct Answer: B

• Question 80:

  Which DQL statement returns the number of documents of type SOP that are CURRENT versions?

  A. SELECT COUNT(r_object_id) FROM SOP(CURRENT)

  B. SELECT COUNT(r_object_id) FROM SOP

  C. SELECT MAX(r_object_id) FROM SOP

  D. SELECT SUM(r_object_id) FROM SOP

  Correct Answer: B