1052-20May

Question 1

Enterprise Asset Management (EAM)

Answer 1

…the optimal life cycle management of the physical assets not an organization. It covers subjects including the design, construction, commissioning, operations, maintenance, and decommissioning/replacement of plant equipment and facilities.

Question 2

Enterprise

Answer 2

…refers to the scope of the assets across departments, locations, facilities, and, potentially, business units.

Question 3

PL/SQL

Answer 3

Procedural Language / Structured Query Language

Question 4

PL/SQL ?

Answer 4

Developed by Oracle Corp. in early 90s for seamless processing of SQL commands; one of 3 key programming languages (PL/SQL + SQL + Java) embedded in Oracle Database; used when writing code residing in database in 3 occasions: using database triggers, scripting w/speed & keeping code server-side.

Question 5

Detail 3 occasions when PL/SQL is used.

Answer 5

1 - when using a database trigger (an event within the DBMS that can cause code to be triggered automatically;
2 - scripting w/speed
3 - keeping code server-side

Question 6

Define trigger type: Table-level trigger

Answer 6

Initiates activity before INSERT, UPDATE, or DELETE event; most commonly used to track history information and database changes; keeps redundant data synchronized or to enhance security by preventing certain operations from occurring.

Question 7

Define trigger type: View level trigger

Answer 7

Considered very useful; a “view” is a stored SQL command statement that developers can query as if there were a database table itself. By placing INSTEAD OF triggers on a view, the INSERT, MODIFY, and DELETE commands can be applied to the view regardless of its complexity, because the INSTEAD OF trigger defines what can be done to the view.

Question 8

IBM Maximo Asset Management

Answer 8

Bridges Enterprise Management (Customer Relationship Management, Business Intelligence & KPIs, Regulatory Reporting, Financial Management, & Human Capital Management) and Operations Systems (Dispatching & Scheduling, Measurement Systems, Performance Monitoring Graphical Information Systems, Diagnostic Integration) = Work Management, Asset Management, Service Management, Contract Management, Procurement Management, & Inventory Management.

Question 9

Define trigger type: Database-level trigger

Answer 9

Can be activated at startup and shutdown. Example: when user logs on…you may want to test availability of other databases or Web services. Before a database shutdown, you may want to notify other databases and Web services that the database is going offline.