Certification Questions

Q:

Which of the following tools can be used to identify inefficient SQL statements without executing them?

A) QMF B) Task Center
C) Visual Explain D) Development Center
 
Answer & Explanation Answer: C) Visual Explain

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

1 2997
Q:

The SQL keyword BETWEEN is used:

A) for ranges B) as a wildcard
C) to limit the columns displayed D) All the above
 
Answer & Explanation Answer: A) for ranges

Explanation:

In SQL, BETWEEN Keyword is used for ranges like Number Ranges, Date Ranges, etc...

Report Error

View Answer Report Error Discuss

0 2996
Q:

You use Microsoft Visual Studio 2010 and Microsoft ADO.NET Framework 4 to create an application. The application connects to a Microsoft SQL Server 2008 database. You use the ADO.NET LINQ to SQL model to retrieve data from the database. You use stored procedures to return multiple result sets. You need to ensure that the result sets are returned as strongly typed values. What should you do?

A) Apply the FunctionAttribute and ResultTypeAttribute to the stored procedure function. Use the GetResult B) Apply the FunctionAttribute and ParameterAttribute to the stored procedure function and directly access the strongly typed object from the results collection.
C) Apply the ResultTypeAttribute to the stored procedure function and directly access the strongly typed object from the results collection. D) Apply the ParameterAttribute to the stored procedure function. Use the GetResult
 
Answer & Explanation Answer: A) Apply the FunctionAttribute and ResultTypeAttribute to the stored procedure function. Use the GetResult

Explanation:
Report Error

View Answer Report Error Discuss

17 2993
Q:

Which master role causes the domain controller that performs this role to be the only domain controller in the forest that can add a new domain to the forest?

A) PDC emulator B) Schema master
C) Relative ID master D) Domain naming master
 
Answer & Explanation Answer: D) Domain naming master

Explanation:

The domain naming master is the only domain controller that can add or remove domains to/form the forest

Report Error

View Answer Report Error Discuss

0 2990
Q:

A device on a network is ready to send a frame. What is the first thing that CSMA/CD logic does?

A) Sends a token out to instruct other devices not to send packets. B) Sends a jamming signal out to prevent other hosts from sending packets.
C) Sends a discovery message out to find out if the destination host is on the same subnet. D) Listens to see if the Ethernet is busy.
 
Answer & Explanation Answer: D) Listens to see if the Ethernet is busy.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: CCENT

0 2979
Q:

Which of the following is the best description of the operation of split horizon?

A) Information about a route should not be sent back in the direction from which the original update came B) It splits the traffic when you have a large bus (horizon) physical network
C) It holds the regular updates from broadcasting to a downed link D) It prevents regular update messages from reinstating a route that has gone down
 
Answer & Explanation Answer: A) Information about a route should not be sent back in the direction from which the original update came

Explanation:

A split horizon will not advertise a route back to the same router it learned the route from.

Report Error

View Answer Report Error Discuss

Filed Under: CCNA

0 2977
Q:

How can you describe an operational level agreement (OLA) ?

A) It is a legally binding contract outlining services delivered to an IT service provider that underpin a service that provider delivers to its customers. B) It is a written agreement between a supplier and the IT customer(s), defining the key service targets and responsibilities of both parties.
C) It contains targets that underpin those within an SLA to ensure that targets will not be breached by failure of the supporting activity. D) It is an agreement between a supplier and another part of the same organization that assists with the provision of services.
 
Answer & Explanation Answer: D) It is an agreement between a supplier and another part of the same organization that assists with the provision of services.

Explanation:

An agreement between an IT service provider and another part of the same organization. An OLA supports the IT service provider's delivery of services to customers. The OLA defines the goods or services to be provided and the responsibilities of both parties.

 

* For an example there be an OLA - between the IT service provider and a acquiring department to obtain hardware in discussed times - between the Service Desk and a support group to provide Incident resolution in accepted times.

Report Error

View Answer Report Error Discuss

7 2972
Q:

Partial deliveries are controlled by an indicator thet you set in the:

A. Sold to master record.

B. Delivery schedule line category.

C. Delivery document type.

D. Customer material information record.

Answer

Answer : A , D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP SD

0 2972