Certification Questions

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 3189
Q:

You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers. You are also the administrator of an Oracle relational database management system (RDBMS) server. This server is used to store your company's financial information. The financial information is updated frequently throughout the day.You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.You want to create these reports on the SQL Server computer by using the minimum amount of disk space. What should you do?

A) Set up SQL Server replication to replicate the data from the Oracle server to the SQL Server computer. B) Set up the Oracle server as a linked server. Create a view that joins the service contract information and the financial information.
C) Set up a Microsoft ActiveX script that connects to the Oracle server and imports the financial information into a SQL Server temporary table. Create a view that joins the service contract information and the temporary table. D) Set up a Data Transformation Services (DTS) package that imports and transforms the data from the Oracle server to the SQL Server computer. Use SQL Server Agent to execute the DTS package throughout the day as needed.
 
Answer & Explanation Answer: B) Set up the Oracle server as a linked server. Create a view that joins the service contract information and the financial information.

Explanation:

SQL Server 2000 permits the creation of links to OLE DB data sources called linked servers. After linking to an OLE DB data source, it is possible to reference rowsets from the OLE DB data sources as tables in Transact-SQL statements and to pass commands to the OLE DB data sources and include the resulting rowsets as tables in Transact-SQL statements. Each distributed query can reference multiple linked servers and can perform either update or read operations against each individual linked server. A single distributed query can perform read operations against some linked servers and update operations against other linked servers. The Microsoft OLE DB Provider for Oracle allows distributed queries to query data in Oracle databases.

Report Error

View Answer Report Error Discuss

0 3178
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 3158
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 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 3142
Q:

What device must be on your wired network when running an enterprise EAP solution?

Answer

RADIUS Server

Report Error

View answer Workspace Report Error Discuss

Subject: CCNA

1 3137
Q:

An administrator issues the command

A. The PC host PC1 has connectivity with a local host
B. The PC host PC1 has connectivity with a Layer 3 device
C. The PC host PC1 has a default gateway correctly configured
D. The PC host PC1 has connectivity up to Layer 5 of the OSI model
E. The PC host PC1 has the TCP/IP protocol stack correctly installed

Answer

Answer : E


Explanation:


The “ping 127.0.0.1″ command is used to troubleshoot the local network card and the TCP/IP stack to make sure is working correctly. If an ICMP echo reply is received, that shows there are connectivity to a particular host in the network.


 

Report Error

View answer Workspace Report Error Discuss

Subject: CCNA

0 3135
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 3129