Question

Cross reference table can be achieved by which key

Answer 1

In a relational database management system, a table can have an xref as prefix or suffix to indicate it is a cross-reference table that joins two or more tables together via primary key.

Answer 2

cross-reference table that joins two or more tables together via primary key.

Explanation:

• The cross-reference table is an information structure that replaces a run-time query calculation with a lot less complex query activity.
• The increase in handling rate can be huge in light of the fact that recovering a worth from memory is a lot quicker than playing out an information base or other connector query.

• Cross-reference table queries are most frequently acted in map capacities (under the Query classification) yet can likewise be utilized as boundary values in all cycle steps that utilization boundaries, like connectors (counting the Beginning shape), Choice, Set Properties, Message, Program Order, and Exemption shape.