Certification Questions

Q:

Difference between Union and Union all?

Answer

The difference between Union and Union all is that Union all will not eliminate duplicate rows, instead it just pulls all rows from all tables fitting your query specifics and combines them into a table. A UNION statement effectively does a SELECT DISTINCT on the results set.

Report Error

View answer Workspace Report Error Discuss

10 2086
Q:

You would like to use the command line to end an application that a Terminal Services client is running. What command can you use?

A) Tscon B) Tsprof
C) Tsend D) Tskill
 
Answer & Explanation Answer: D) Tskill

Explanation:

Tskill ends a process. Since you want to stop an application, this is the command you would use.

Report Error

View Answer Report Error Discuss

0 2084
Q:

A large CRM project took place last year included hundreds of meetings between the various key users. All of the conversations were save in a single Word 2010 document. You need to find all instances of the following words 'bleed' and 'bled'. Which of the following wildcard searches would be best?

A) ble{2}d B) ble{1,}d
C) ble{e2}d D) ble[e2]d
 
Answer & Explanation Answer: B) ble{1,}d

Explanation:
Report Error

View Answer Report Error Discuss

2 2082
Q:

Project Communications Management - Processes

Describe the Inputs, Tools and Techniques , Outputs included in the Performance Reporting?

Answer

I. Inputs



  • Work performance information

  • Performance measurements

  • Forecasted completion

  • Quality control measurements

  • Project management plan


                - Performance measurement baseline



  • Approved change requests

  • Deliverables


II. Tools and Techniques



  • Information presentation tools

  • Performance information gathering and compilation

  • Status review meetings

  • Time reporting systems

  • Cost reporting systems


III. Outputs



  • Performance reports

  • Forecasts

  • Requested changes

  • Recommended corrective actions

  • Organizational process assets (updates)

Report Error

View answer Workspace Report Error Discuss

0 2079
Q:

Project Time Management - Processes

Describe the Inputs, Tools and Techniques, Outputs of Activity Resource Estimating ?

Answer

I. Inputs



  • Enterprise environmental factors

  • Organizational process assets

  • Activity list

  • Activity attributes

  • Resource availability

  • Project management plan


II. Tools and Techniques



  • Expert Judgment

  • Alternatives analysis

  • Published estimating data

  • Project management software

  • Bottom-up estimating


III. Outputs



  • Activity resource requirements

  • Activity atributes (updates)

  • Resource breakdown structure

  • Resource calendars (updates)

  • Requested changes

Report Error

View answer Workspace Report Error Discuss

0 2079
Q:

Project Integration Management - Processes

Describe the Inputs, Tools and Techniques, Outputs of Develop project management plan phase?

Answer

I. Inputs



  • Preliminary project scope statement

  • Project management processes

  • Enterprise environmental factors

  • Organizational process assets


II. Tools and Techniques



  • Project management methodology

  • Project management information system

  • Expert Judgment


III. Outputs



  • Project management plan

Report Error

View answer Workspace Report Error Discuss

0 2074
Q:

Project Cost Management - Processes

Describe the Inputs, Tools and Techniques , Outputs included in the Cost Budgeting ?

Answer

I. Inputs



  • Project scope statement

  • Work breakdown structure

  • WBS dictionary

  • Activity cost estimates

  • Activity cost estimate supporting detail

  • Project schedule 

  • Resource calendars 

  • Contract

  • Cost management plan


II. Tools and Techniques



  • Cost aggregation

  • Reserve analysis

  • Parametric estimating 

  • Funding limit reconciliation


III. Outputs



  • Cost baseline 

  • Project funding requirements 

  • Cost management plan (updates)

  • Requested changes

Report Error

View answer Workspace Report Error Discuss

0 2073
Q:

The status bar of Word 2010 provides useful information about the current document you are working on. You can customize the status bar to add or remove options to suit your needs. By default, which of these options is NOT present on the status bar?

A) Line Number B) Page Number
C) Word Count D) Language
 
Answer & Explanation Answer: A) Line Number

Explanation:
Report Error

View Answer Report Error Discuss

1 2069