Database Links & Distributed Operations MCQs

11 MCQs — Oracle: Modifying Data & Multiple Databases MCQs (Page 1 of 2)

Practice Database Links & Distributed Operations MCQs with correct answers and explanations. These questions are from the Oracle: Modifying Data & Multiple Databases MCQs section.

Attempt Database Links & Distributed Operations Quiz

Oracle: Modifying Data & Multiple Databases Subcategories

Advanced DML & Data Movement	Common Errors & Integrity During DML
Database Links & Distributed Operations	Database Links & Replication
DML & Transactions	DML Statements & Locking
Moving & Loading Data

What is a database link in Oracle?

A foreign key between two columns
A schema object that lets you access objects in another database
A backup file
A type of index

Read more about this MCQ

Which statement creates a database link?

CREATE LINK remote_db TO 'orcl2';
ALTER DATABASE ADD LINK remote_db;
CONNECT DATABASE remote_db;
CREATE DATABASE LINK remote_db CONNECT TO hr IDENTIFIED BY pwd USING 'orcl2';

Read more about this MCQ

How do you query the EMP table on a remote database using the link REMOTE_DB?

SELECT * FROM emp@remote_db;
SELECT * FROM remote_db.emp#;
SELECT * FROM emp->remote_db;
SELECT * FROM remote_db::emp;

Read more about this MCQ

What is the difference between a PUBLIC and a private database link?

A PUBLIC link is encrypted; a private link is not
A PUBLIC link works only locally
A PUBLIC link can be used by all users; a private link only by its owner
There is no difference

Read more about this MCQ

What is a distributed transaction?

A transaction that runs very long
A transaction that modifies data on two or more databases
A transaction using multiple tables on one database
A transaction without COMMIT

Read more about this MCQ

Which protocol ensures a distributed transaction commits or rolls back at all sites?

Two-phase commit (2PC)
Two-factor commit
Single-phase commit
Redo shipping

Read more about this MCQ

Which data dictionary view shows the database links owned by the current user?

USER_LINKS
USER_DB_LINKS
ALL_REMOTE_DB
USER_NETWORKS

Read more about this MCQ

Which file is typically used on the client to resolve a net service name such as 'orcl2'?

listener.log
init.ora only
alert.log
tnsnames.ora

Read more about this MCQ

Which view lists distributed transactions that are in doubt after a failure?

DBA_2PC_PENDING
DBA_TRANSACTIONS
V$LOGFILE
DBA_LOCKS_ONLY