What can an alias reference?

When does the Content Server resolve an alias on a sysobject?

What is a benefit of permission set templates?

Which query will list the object IDs and names of all documents (current version only) in a
repository that a user has permission to access?

Annotations on a document are represented using dm_relation objects. On the dm_relation object,
both parent_id and child_id point to a dm_sysobject. The object pointed to by the parent_id is the
document and the object pointed to by the child_id is the annotation. The annotation object is
owned by the person who commented on the document.
Which query will return all documents owned by ‘John Smith’ that have annotations along with the
name of the user that commented on the document?

A user wants a list of documents with keywords that contain the words “interface,” “class” or both
“interface” and “class.”
How can the user complete the following query to accomplish this?

select object_name from dm_document _____

A user wants to write a DQL query that can be run on a daily basis to determine which documents
were modified on the previous day.
How can the user complete the following query to accomplish this?
select object_name from dm_document _____

A user wants to determine how many documents they own. Which query will do this?

Which DQL statement is correct for changing the title property of a document, named “Arch
Diagram”, to “Figure 1”?

A user wants a list of all folders and subfolders within the Resources cabinet in a repository.
How should the user complete the following query to accomplish this?
select object_name from dm_folder _____