EMC EMC Certification E10-110 Questions & Answers

• Question 111:

  A repository has objects of dm_document type in a folder named "SOPNet". A user wants to find all dm_document in this folder AND all containing subfolders checked out by them.

  How can the user complete the following query to accomplish this?select * from dm_document where r_lock_owner=user _______________

  A. and folder(/SOPNet, descend)

  B. and folder(/SOPNet)

  C. and folder(/SOPNet, all)

  D. and folder(/SOPNet, *)

  Correct Answer: A

• Question 112:

  Which statement about the DQL WHERE clause is true?

  A. It specifies which object properties should be retrieved.

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

  C. It indicates which Documentum repository should be searched.

  D. It may contain logical operators such as AND, OR, or NOT.

  Correct Answer: D

• Question 113:

  Which form of the "FROM" clause will search only the current version of the "SOP" type?

  A. SOP (CURRENT)

  B. CURRENT SOP

  C. SOP

  D. SOP (ALL)

  Correct Answer: C

• Question 114:

  Which DQL statement is used to modify an object type?

  A. ALTER TYPE

  B. MODIFY TYPE

  C. MODIFY

  D. SET OBJECT

  Correct Answer: A

• Question 115:

  Which DQL statement will modify the character size of attribute "approver_name"?

  A. ALTER ("approver_name" char(32)) FROM "SOP"

  B. ALTER "SOP" MODIFY ("approver_name" char(32))

  C. UPDATE TYPE "SOP" MODIFY ("approver_name" char(32))

  D. ALTER TYPE "SOP" MODIFY ("approver_name" char(32))

  Correct Answer: D

• Question 116:

  Which DQL element is used to identify the object type and RDBMS tables to retrieve from a Documentum repository?

  A. FROM

  B. WHERE

  C. SELECT

  D. PROPERTIES

  Correct Answer: A

• Question 117:

  Which statement about DQL is true?

  A. DQL is a scripted language used to customize Documentum client user interfaces.

  B. DQL requires a user to have at least Browse permission to view property values for a repository object by DQL.

  C. DQL is a compiled language that executes faster than SQL on Oracle databases.

  D. DQL is a more precise language than SQL and therefore returns a more precise set of results.

  Correct Answer: B

• Question 118:

  What is returned by the following query?

  SELECT * FROM dm_document WHERE r_creation_date

  A. A predefined list of properties from dm_document objects created before April 1, 2013

  B. A predefined list of properties from dm_document objects created after April 1, 2013

  C. A predefined list of properties from dm_document objects modified or created before April 1,

  D. The creation date property from dm_document objects created before April 1, 2013

  Correct Answer: A

• Question 119:

  Which statement is true about DQL?

  A. DQL can be used to access registered tables.

  B. DQL queries can only be executed by the Installation Owner.

  C. A DQL query can be used to retrieve the content of a document.

  D. DQL contains extensions to override the ACLs created on documents and other objects.

  Correct Answer: A

• Question 120:

  Which statement about DQL is true?

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

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

  C. DQL can be used to migrate standard objects to lightweight objects.

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

  Correct Answer: C