What can be referenced as an alias?

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 user wants to search for a document whose subject is set to “server” or “Server”.
Which DQL query will do this?

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

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

A user wants a list of documents with keywords that contain the words ‘parent,’ ‘child’ or both
‘parent’ and ‘child.’
How should the following query be completed to achieve this result? selectobject_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 since the start of the previous day.
How should the following query be completed to achieve this result? selectobject_name from
dm_document _____

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

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

A folder named “inner” resides in the cabinet named “outer.”
How should a user complete the following query to list all objects directly inside the “inner”
folder?selectobject_name from dm_sysobject _____