Multiple choice technology databases

Which symbol preceeds the path to the table in the remote database ?

  1. /

  2. #

  3. @

  4. \

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In distributed database queries, the @ symbol precedes database object names to identify them as remote objects. For example, in a query like SELECT * FROM @remote_server.database.schema.table, the @ indicates the table is located on a different/remote database server. This syntax varies by database system, but @ is commonly used for remote object references.

AI explanation

The @ symbol precedes a database link name that specifies the remote database in queries against tables on another database (as in Oracle's table_name@dblink syntax). This lets the query engine know the table reference resolves through a link to a remote system rather than the local one.