Bp02 - Best Practices For SQL Usage In Mc

8 Questions | By Mconnect | Last updated: Oct 20, 2017 | Total Attempts: 217

Questions

Settings

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

Related Quizzes

Best Practices For Course Development

Introduction L3Harris created six key components for successfully developing a high-quality and effective instructor-led or online training course that meets training objectives. Course developers should consider these...

Questions: 15 | Attempts: 12 | Last updated: Jun 22, 2020