Database Configuration Flashcards by sebastian barry

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%

How well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

Does creating a new relationship require a Database Configuration?

How well did you know this?

Not at all

Perfectly

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 well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

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}

How well did you know this?

Not at all

Perfectly

In which application are database attributes created?
Select one:
a. Attribute Designer
b. SQL Query Editor
c. Database Configuration 
d. Application Designer

Database Configuration

How well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

In which application in Maximo is auditing enabled?
Select one:
a. Domains
b. System Properties 
c. Database Configuration
d. Application Designer

Database Configuration

How well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

Autnumber Seeds and Prefixes are configured in which Maximo application?
Select one:
a. Organizations
b. Domains 
c. Database Configuration
d. Application designer

Organizations

How well did you know this?

Not at all

Perfectly

Relationships are created in which application?
Select one:
a. Application designer
b. Domains
c. Relationships
d. Database Configuration

Database Configuration

How well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

What are the three Message Suffix Descriptions?
Select one or more:
a. Error 
b. Information 
c. Warning
d. Alert 
e. Fatal

Information, Warning, Error

How well did you know this?

Not at all

Perfectly

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

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