Database Configuration Flashcards
A User is querying a field in the database that is configured for EXACT search type. They wish to only return records beginning with the string ‘Pump’. Which of the following values should they use in the search field? Select one: a. pump% b. %Pump c. =Pump d. &Pump% e. Pump%
Pump%
Before which of the following tasks is it recommended you backup the database? Select one: a. Structural Change to the Database b. Creating new Organizations c. Full-Live Data configuration d. Configuring a Domain
Structural Change to the Database
Does creating a new relationship require a Database Configuration?
No
Electronic Signature allows you to configure which of the following features in Maximo?
Select one:
a. It allows log in to Maximo using a smart card
b. It encrypts data at the field level
c. It enables the login screen for local authentication
d. It allows specific fields to require re-authentication
It allows specific fields to require re-authentication
How can E-Signature be limited in scope based on an expression?
Select one:
a. By creating a conditional expression
b. By adding a condition to the Database attribute
c. By adding an E-Signature Filter
d. By configuring the maximo.esig.condition property
By adding an E-Signature Filter
If a default control is applied to a field using application designer, this value will be applied to all new records, including those loaded through the Maximo Integration Framework.
Select one:
a. False
b. True
False
If you modify an attribute that has auditing enabled, what will be the EAUDITTYPE stored in the database? Select one: a. M b. U c. C d. I
U
If you wish to display a fields invalid entered data based on a domain in an error message, which syntax would you use?
Select one:
a. [0]
b. :attributename
c. {1}
d. {0}{1}
In which application are database attributes created? Select one: a. Attribute Designer b. SQL Query Editor c. Database Configuration d. Application Designer
Database Configuration
In which application in Maximo are custom error messages created? Select one: a. Application Designer b. Database Configuration c. Domains d. System Properties
Database Configuration
In which application in Maximo is auditing enabled? Select one: a. Domains b. System Properties c. Database Configuration d. Application Designer
Database Configuration
In which two of the following applications can Login Tracking be enabled?
Select one or more:
a. Users
b. Security Groups
c. Application Designer
d. Database Configurations
e. System Properties
Security Groups, Users
New Maximo relationships can be created on which Objects? Select one: a. Main Object b. Persistent Objects c. All Objects d. Custom Objects
All Objects
Autnumber Seeds and Prefixes are configured in which Maximo application? Select one: a. Organizations b. Domains c. Database Configuration d. Application designer
Organizations
Relationships are created in which application? Select one: a. Application designer b. Domains c. Relationships d. Database Configuration
Database Configuration
What additional feature must be enabled for E-Signature to function? Select one: a. Field level auditing b. Login Tracking c. Admin Mode d. Field level encryption
Login Tracking
hat are non-persistent Objects used for? Select one: a. To store Data in the Database schema b. To store temporary data in the session memory c. For configuring the Database d. For Workflow processes
To store temporary data in the session memory
What are the three Message Suffix Descriptions? Select one or more: a. Error b. Information c. Warning d. Alert e. Fatal
Information, Warning, Error
What function do indexes perform within a Maximo implementation?
Select one:
a. Indexes improve the efficiency of queries
b. Indexes allow applications to find the correct table in the Database
c. Indexes improve the data write speed
d. Indexes allow reports to choose the correct query to run
Indexes improve the efficiency of queries
What function does the Domain provide when attached to an Attribute in Maximo?
Select one:
a. Provides field level validation
b. Allows the system to set the Attribute value
c. Shows a magnifying glass next to the control
d. Defines the layout of the Lookup
Provides field level validation
What is the maximum number of Tax Types available in Maximo? Select one: a. 256 b. 5 c. 12 d. 27
27
What is the Suffix given to the Shadow Data Dictionary tables used by the Database Configuration Application? Select one: a. CXG b. CXX c. DB2 d. CFG
CFG
What task does the Update Statistics Action perform?
Select one:
a. Generates usage statistics of your Maximo system
b. Optimizes queries in the database
c. Synchronizes Views in the database with Maximo
d. Refreshes KPIs
Optimizes queries in the database
When applying a default to the appropriate Maximo database table using SQL, and application server restart is required?
Select one:
a. True
b. False
True
Which fields(s) do we use to define where the relationship is joining to? Select one: a. Join Object b. Master Object c. Child Object d. Parent Object
Child Object
Which flag in the MAXVARS table should be set to 0 in order to recover from configuration failure? Select one: a. DBLOCK b. CONFIGURING c. MAXADMIN d. MAXCONFIG
CONFIGURING
Which flag should you check if you wish the Object to be a candidate for a Workflow Process? Select one: a. Main Object b. System Object c. Internal d. Workflow Enabled
Main Object
Which Message ID Prefix is recommended for Custom Error Messages?
Select one:
a. BMXXX
b. BMXCZ
c. BMXZZ
d. BMXCUS
BMXZZ
Which method of configuration should you use if you wish data to be backed up? Select one: a. All of the above b. Full Live c. Command Line d. Partial Live
Command Line
Which of the flowing is true regarding the sequencing of columns in an index?
Select one:
a. Columns in an index should be ordered in terms of data quantity
b. Sequencing of columns in an index should be based on the analysis of queries using that index
c. You should always specify a column sequence in an index
d. The order of columns in an index makes no difference
Sequencing of columns in an index should be based on the analysis of queries using that index
Which of the following Attribute Search Types are case sensitive? (Choose all that apply) Select one or more: a. WILDCARD b. ALN c. QUERY d. TEXT e. EXACT
EXACT, WILDCARD
Which of the following attributes could have auditing enabled?
Select one:
a. A Non-persistent attribute in a Non-persistent object
b. A Persistent attribute in a Non-persistent object
c. A Non-persistent attribute in a Persistent object
d. A Persistent attribute
A Persistent attribute
Which of the following Configuration methods requires Admin Mode to be enabled? Select one: a. Command Line b. Full Live c. Partial Live d. All of the above
Partial Live
Which of the following is the correct syntax for a related attribute referenced in application designer? Select one: a. attribute.relationship b. relationship.attribute c. relationship.tablename d. objectname.attribute
relationship.attribute
Which of the following search types cannot be used with Numeric Attributes? Select one: a. EXACT b. ALN c. TEXT d. WILDCARD
TEXT
Which of the following statements is true regarding persistent objects?
Select one:
a. The data is temporary stored in the session memory
b. They cannot contain non-persistent attributes
c. Can only be accessed from the session memory
d. The data is stored in the Database
The data is stored in the Database
Which of the following substitution values would apply the next autonumber seed to the attribute? Select one: a. &AUTOSEED& b. &AUTONUMBER& c. &AUTOKEY& d. %AUTONUMBER%
&AUTOKEY&
Which of the following types of Index would cause the physical data in a SQL Server database table to become sequenced? Select one: a. Compound b. Clustered c. Unique d. Non-Unique
Clustered
Which of the following types of Maximo Attributes are not stored in the Database? Select one: a. Numeric b. ALN c. BLOB d. Non-persistent
Non-persistent
Which of the following would create backup tables in the Maximo Database? Select one: a. Any Structural Change b. Any Non-Structural Change c. Creating an Extension table d. Adding a Tax Type
Adding a Tax Type
Which two attributes should be created if you’re creating a new object at the SITE level? (Choose Two)
Select one or more:
a. SITEID
b. ATTRIBUTEID
c. ORGID
d. SYSTEMID
e. SETID
ORGID, SITEID
Which two of the following are supported ways in which you can delete backup tables in the Maximo Database?
Select one or more:
a. Using the Drop Backup Tables action
b. Dropping the tables directly in the Database using a database utility
c. Running the Apply Configuration Changes action
d. Using the Delete Backup Tables action
e. Running the deletebackup.bat command
Using the Delete Backup Tables action, Running the Apply Configuration Changes action
Which of the following require you to perform a Database Configuration in order for changes to be applied?(Choose all that apply) Select one or more: a. Changing an application design b. Adding a New Relationship c. Attaching a Domain to an Attribute d. Adding a New Domain e. Adding a New Object
Adding a New Object, Adding a New Domain, Attaching a Domain to an Attribute
Which type of Database configurations require Admin Mode to be enabled? Select one: a. All Database Configuration Changes b. Off-line Changes c. Non-Structural Changes d. Structural Changes
Structural Changes
Which type of Domain should be used if you wish to validate against a static list of values? Select one: a. List b. ALN c. Crossover d. Table
ALN
Which type of Object will have a corresponding table in the database? Select one: a. Non-Persistent Object b. All Objects c. Main Object d. Persistent Objects
Persistent Objects
