Certification Questions

Q:

Count function in SQL returns the number of

A) groups B) values or rows
C) columns D) distinct values
 
Answer & Explanation Answer: B) values or rows

Explanation:

Count function in SQL returns the number of values or rows.

Report Error

View Answer Report Error Discuss

3 3206
Q:

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an
application. You use the ADO.NET Entity Framework to model entities. You write the following code segment. (Line numbers are included for reference only.)


01AdventureWorksEntities context = New AdventureWorksEntities
02
03var q = from c in context.Customers
04where c.City == "London"
05orderby c.CompanyName
06select c;


You need to ensure that the application meets the following requirements: "Compares the current values of unmodified properties with values returned from the data source". Marks the property as modified when the properties are not the same. Which code segment should you insert at line 02?

A) context.MergeOption = MergeOption.AppendOnly; B) context.MergeOption = MergeOption.PreserveChanges;
C) context.MergeOption = MergeOption.OverwriteChanges; D) context.MergeOption = MergeOption.NoTracking;
 
Answer & Explanation Answer: B) context.MergeOption = MergeOption.PreserveChanges;

Explanation:
Report Error

View Answer Report Error Discuss

0 3197
Q:

What is frame tagging?

Answer

Frame identification (frame tagging) uniquely assigns a user-defined ID to each frame. This is sometimes reffered to as a VLAN ID or color.

Report Error

View answer Workspace Report Error Discuss

Subject: CCNA

0 3192
Q:

 In 1:n assignments, the operational charts of accounts in all assigned company codes and in the controlling area must be the same.

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

The charts of accounts must be the same.

Report Error

View Answer Workspace Report Error Discuss

Subject: SAP CO

2 3180
Q:

Suppose an installed z/OS customer also has Power6 Servers. They are investigating consolidation of both types of servers to z/OS.Which of the following will establish the capacity for a new z/OS server?

A) AD Tools B) CP3000
C) Estimate the AIX load and add to CP3000 results. D) Run AIX in a z/OS LPAR to establish the loadWArialTimes New RomanZ
 
Answer & Explanation Answer: C) Estimate the AIX load and add to CP3000 results.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

4 3165
Q:

What is the primary purpose of having multi-dimensional data models?

A. To deliver structured information that the business user can easily navigate by using any possible combination of business terms to show the KPIs.

B. To make it easier for developers to build applications, that will be helpful for the business users.

C. To make it easier to store data in the database and avoid redundancy.

D. All the above

Answer

Answer : A


 


Explanation :  The primary purpose of multi-dimensional modeling is to present the business users in a way that corresponds their normal understanding of their business. They also provide a basis for easy access of data which is OLAP engine.

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW

2 3155
Q:

Subject to which prerequisites can a source of supply be assigned as early as during the MRP run?

A. The 'MRP-relevant' indicator must have been set in a contract item.

B. The source determination facility must be activated at the start of the MRP run.

C. A quota arrangement must exist and the quota arrangement usage indicator must allow use of the quota arrangement in materials planning.

D. An info record must exist for the relevant material and the vendor must have been flagged in the source list as the single/sole source of supply for the purposes of materials planning.

Answer

Answer : C , D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP MM

4 3149
Q:

You are a project manager for the redevelopment of the Hoover Dam. Your team has been provided with the scope statement, but it lacks many description details. Your team is concerned because the project is in the initiation phase and it wants to postpone it until it has more information. As the project manager, you recommend that

A) The team should go forward, but be caution about the lack of details and the impact upon the timeline for the project B) The project should not go forward until the stakeholders agree about the scope and purpose of the project
C) The team should verify the scope and realize that more details will be available as more project characteristics are progressively elaborated. D) The team should review the project selection criteria for the Hoover Dam project
 
Answer & Explanation Answer: C) The team should verify the scope and realize that more details will be available as more project characteristics are progressively elaborated.

Explanation:

The project details and description will usually have less detail at the beginning of the project and will increase as the characteristics are progressively elaborated. Answer A is incorrect because the team should confirm that they understand the esence of the scope of the project, even if the details might be ambiguous at the beginning of the project. Answer B is incorrect because the project should go forward; however, the team should request further clarification of what the project scope entails. Answer D is incorrect because the project selection criteria should be established before the project begins.

Report Error

View Answer Report Error Discuss

Filed Under: PMP Certification

0 3147