60:00
0/11 Attempted
Scoreboard
Attempted 0
Correct 0
Incorrect 0
Skipped 0
Total Score 0
Marks 0
Your Progress
Attempted 0
Correct 0
Incorrect 0
Skipped 0
Score 0
Marks 0

Database Links & Distributed Operations — Test 1

Page 1 of 2

Review Skipped Questions

0
Question 1
What is a database link in Oracle?
FPSC - Database Administrator Model Papers -2026
Question 2
Which statement creates a database link?
FPSC - Database Administrator Model Papers -2026
Question 3
How do you query the EMP table on a remote database using the link REMOTE_DB?
FPSC - Database Administrator Model Papers -2026
Question 4
What is the difference between a PUBLIC and a private database link?
FPSC - Database Administrator Model Papers -2026
Question 5
What is a distributed transaction?
FPSC - Database Administrator Model Papers -2026
Question 6
Which protocol ensures a distributed transaction commits or rolls back at all sites?
FPSC - Database Administrator Model Papers -2026
Question 7
Which data dictionary view shows the database links owned by the current user?
FPSC - Database Administrator Model Papers -2026
Question 8
Which file is typically used on the client to resolve a net service name such as 'orcl2'?
FPSC - Database Administrator Model Papers -2026
Question 9
Which view lists distributed transactions that are in doubt after a failure?
FPSC - Database Administrator Model Papers -2026
Question 10
Which object stores a local copy of remote table data that is refreshed periodically?
FPSC - Database Administrator Model Papers -2026