Bp02 - Best Practices For SQL Usage In Mc

8 Questions | Total Attempts: 217

SettingsSettingsSettings
Please wait...
Bp02 - Best Practices For SQL Usage In Mc

.


Questions and Answers
  • 1. 
    What are some great areas to apply SQL statements in Maintenance Connection? (select all that apply)
    • A. 

      Rules Manager

    • B. 

      Report Setup

    • C. 

      Documents Module

    • D. 

      Database Job Schedule

  • 2. 
    Maintenance Connection stores SQL statement information for customers to use in the the MCUC Library.
    • A. 

      True

    • B. 

      False

  • 3. 
    What two areas do you click on to enter a SQL script into a new Rule in the Rules Manager? (select two)
    • A. 

      Details Tab

    • B. 

      Actions Tab

    • C. 

      Run Database Script Checkbox

    • D. 

      Script Tab

  • 4. 
    SQL Statements can be used in Maintenance Connection to run Database Scripts.
    • A. 

      True

    • B. 

      False

  • 5. 
    Using SQL within KPIs allows you to join other fields and narrow down information to be specific.
    • A. 

      True

    • B. 

      False

  • 6. 
    What two tabs do you need to click on within the Report Setup to be able to get to the SQL area of a Report?
    • A. 

      Report Profile Tab

    • B. 

      Advanced Tab

    • C. 

      General Tab

    • D. 

      SQL Structure Tab

  • 7. 
    SQL statements used in the Database Job Scheduler can only be scheduled on a daily basis, not for any other time increments.
    • A. 

      True

    • B. 

      False

  • 8. 
    The Database Job Scheduler uses SQL statements to:
    • A. 

      Move Assets to a new software

    • B. 

      Add new Labor and Employees to the system

    • C. 

      Update Part and Part Locations

    • D. 

      Update Part Cost Rules

Back to Top Back to top