EMC EMC Certification E10-110 Questions & Answers

• Question 81:

  A user wants to write a DQL query that can be run on a daily basis to determine which documents were modified since the start of the previous day.

  How should the following query be completed to achieve this result? selectobject_name from dm_document _____

  A. where r_modify_date>= date(yesterday)

  B. where r_modify_date>date(yesterday)

  C. where r_change_date>date(yesterday)

  D. where r_change_date>= date(yesterday)

  Correct Answer: A

• Question 82:

  A user wants to determine how many folders and cabinets are linked to a document named "testdoc". Which query will do this?

  A. select count(*) from dm_document where object_name = 'testdoc'

  B. select count(r_link_cnt) from dm_document where object_name = 'testdoc'

  C. select count(i_reference_cnt) from dm_document where object_name = 'testdoc'

  D. select count(i_folder_id) from dm_document where object_name = 'testdoc'

  Correct Answer: D

• Question 83:

  A user needs to change the subject property of a document named "Blueprint" to "Office Building". Which DQL statement will achieve this result?

  A. update dm_document object set subject = 'Office Building' where object_name = 'Blueprint'

  B. update dm_document set subject = 'Office Building' where object_name = 'Blueprint'

  C. modify dm_document object set subject = 'Office Building' where object_name = 'Blueprint'

  D. modify dm_document set subject = 'Office Building' where object_name = 'Blueprint'

  Correct Answer: A

• Question 84:

  A user wants to search for a document whose subject is set to "server" or "Server". Which DQL query will do this?

  A. select object_name from dm_document where lower(subject) = 'server'

  B. select object_name from dm_document where subject like '%erver'

  C. select object_name from dm_document where subject like '?erver'

  D. select object_name from dm_document where lower(subject) = 'Server'

  Correct Answer: A

• Question 85:

  Which DQL statement will show the object ID of the previous version of a document named "document1"?

  A. Select i_chronicle_id from dm_document where object_name = 'document1'

  B. Select i_antecedent_id from dm_document where object_name = 'document1'

  C. Select i_prev_version_id from dm_document where object_name = 'document1'

  D. Select i_latest_id from dm_document where object_name = 'document1'

  Correct Answer: B

• Question 86:

  Which properties of the dm_document objects are returned by the following DQL query? Select * from dm_document, the *

  A. All read/write single-valued properties, r_object_id, r_object_type, r_creation_date, r_modify_date, and a_content_type

  B. All read/write single and repeating-valued properties

  C. All read/write single-valued properties only

  D. All read/write single and repeating-valued properties, r_object_id, r_object_type, r_creation_date, r_modify_date, and a_content_type

  Correct Answer: A

• Question 87:

  Which character precedes an alias value?

  A. !

  B. @

  C. %

  D. *

  Correct Answer: C

• Question 88:

  What can be referenced as an alias?

  A. An accessor in a permission set

  B. An object_id

  C. A dm_note object

  D. A repository owner

  Correct Answer: A

• Question 89:

  A user needs to list the names and version labels of all versions of documents in the repository to which they have permission to access. The user also wants the information about each version grouped together.

  Which DQL query will yield this result?

  A. select object_name and r_version_label from dm_document (all)

  B. select r_object_id, r_version_label, r_object_id from dm_document (all) group by r_version_label

  C. select r_version_label, object_name from dm_document (all) order by r_version_label

  D. select r_object_id, object_name, r_version_label from dm_document (all)

  Correct Answer: D

• Question 90:

  What does a Template ACL contain?

  A. Aliases

  B. Templates

  C. Custom Permission Sets

  D. Accessors

  Correct Answer: A