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

1 917
Q:

How do we decide on the Characteristics to be included in a Dimension?

A. When the fields (InfoObjects) have 1: m relationship.

B. When the fields (InfoObjects) have m: 1 relationship.

C. When the fields (InfoObjects) have m: n relationship.

Answer

Answer : C

Report Error

View answer Workspace Report Error Discuss

0 911
Q:

Both Joyel and Susy share a Windows 10 tablet with different user accounts. Joyel needs to access some files in Susy’s Documents folder. How can he do this ?

A) Joyel can access the files only if he has administrative rights B) Susy must choose to make the Documents folder Public for Joyel to see them
C) Joyel can, by default, see and access the files in any Documents folder on this computer D) Joyel cannot access those files without Susy moving them to another folder
 
Answer & Explanation Answer: A) Joyel can access the files only if he has administrative rights

Explanation:
Report Error

View Answer Report Error Discuss

5 808
Q:

Availability management is responsible for availability of

A) IT infrastructure B) Tools
C) Processes D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

ITIL Availability Management aims to define, analyze, plan, measure and improve all aspects of the availability of IT services. It is is responsible for ensuring that all IT infrastructure, processes, tools, roles etc are appropriate for the agreed availability targets.

Report Error

View Answer Report Error Discuss

1 801
Q:

Programs from the same developer, sold bundled together, that provide better integration and share common features, toolbars and menus are known as_________ ?

A) integrated software packages B) personal information managers
C) software processing packages D) software suites
 
Answer & Explanation Answer: D) software suites

Explanation:
Report Error

View Answer Report Error Discuss

5 770
Q:

What do you mean by APM ?

Answer

APM is abbreviated as Advanced Power Management, which was developed by Microsoft and Intel as an API. This API is mainly utilised for power management, and is very useful especially to those using Windows on their laptops or desktops.

Report Error

View answer Workspace Report Error Discuss

5 717
Q:

Why that you cannot overload the scope resolution operator (::) ?

Answer

The main reason why the (::) cannot be overloaded is that only operators that take in values as parameters can be overloaded. The scope resolution operator does not take a value as parameter.

Report Error

View answer Workspace Report Error Discuss

5 499
Q:

What is plug and play ?

Answer

Plug and Play is a technology wherein hardware components that are installed on PC's using Microsoft operating system are immediately recognized and made usable. This means that the drivers necessary to make it work are already available in the operating system package.

Report Error

View answer Workspace Report Error Discuss

5 435