Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Maximo 7.6 > Database Configuration > Flashcards

Database Configuration Flashcards

1
Q 
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%
A

Pump%

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q 
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
A

Structural Change to the Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Does creating a new relationship require a Database Configuration?

A

No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

It allows specific fields to require re-authentication

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

By adding an E-Signature Filter

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q 
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
A

U

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q 
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}
A

{1}

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q 
In which application are database attributes created?
Select one:
a. Attribute Designer
b. SQL Query Editor
c. Database Configuration 
d. Application Designer
A

Database Configuration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q 
In which application in Maximo are custom error messages created?
Select one:
a. Application Designer
b. Database Configuration
c. Domains 
d. System Properties
A

Database Configuration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q 
In which application in Maximo is auditing enabled?
Select one:
a. Domains
b. System Properties 
c. Database Configuration
d. Application Designer
A

Database Configuration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

Security Groups, Users

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q 
New Maximo relationships can be created on which Objects?
Select one:
a. Main Object
b. Persistent Objects 
c. All Objects
d. Custom Objects
A

All Objects

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q 
Autnumber Seeds and Prefixes are configured in which Maximo application?
Select one:
a. Organizations
b. Domains 
c. Database Configuration
d. Application designer
A

Organizations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q 
Relationships are created in which application?
Select one:
a. Application designer
b. Domains
c. Relationships
d. Database Configuration
A

Database Configuration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q 
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
A

Login Tracking

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q 
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
A

To store temporary data in the session memory

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q 
What are the three Message Suffix Descriptions?
Select one or more:
a. Error 
b. Information 
c. Warning
d. Alert 
e. Fatal
A

Information, Warning, Error

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

A

Indexes improve the efficiency of queries

20
Q

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

A

Provides field level validation

21
Q 
What is the maximum number of Tax Types available in Maximo?
Select one:
a. 256 
b. 5
c. 12
d. 27
A

27

22
Q 
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
A

CFG

23
Q

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

A

Optimizes queries in the database

24
Q

When applying a default to the appropriate Maximo database table using SQL, and application server restart is required?
Select one:
a. True
b. False

A

True

25
Q 
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
A

Child Object

26
Q 
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
A

CONFIGURING

27
Q 
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
A

Main Object

28
Q

Which Message ID Prefix is recommended for Custom Error Messages?

Select one:

a. BMXXX
b. BMXCZ
c. BMXZZ
d. BMXCUS

A

BMXZZ

29
Q 
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
A

Command Line

30
Q

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

A

Sequencing of columns in an index should be based on the analysis of queries using that index

31
Q 
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
A

EXACT, WILDCARD

32
Q

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

A Persistent attribute

33
Q 
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
A

Partial Live

34
Q 
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
A

relationship.attribute

35
Q 
Which of the following search types cannot be used with Numeric Attributes?
Select one:
a. EXACT
b. ALN
c. TEXT 
d. WILDCARD
A

TEXT

36
Q

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

A

The data is stored in the Database

37
Q 
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%
A

&AUTOKEY&

38
Q 
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
A

Clustered

39
Q 
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
A

Non-persistent

40
Q 
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
A

Adding a Tax Type

41
Q

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

A

ORGID, SITEID

42
Q

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

A

Using the Delete Backup Tables action, Running the Apply Configuration Changes action

43
Q 
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
A

Adding a New Object, Adding a New Domain, Attaching a Domain to an Attribute

44
Q 
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
A

Structural Changes

45
Q 
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
A

ALN

46
Q 
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
A

Persistent Objects

Maximo 7.6 (9 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions