60:00
0/30 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

FPSC - Database Administrator Model Papers -2026 — Test 9

Page 1 of 3

Review Skipped Questions

0
Question 1
What does SQL%ROWCOUNT return in PL/SQL?
FPSC - Database Administrator Model Papers -2026
Question 2
Which error occurs when inserting a child row whose parent key does not exist?
FPSC - Database Administrator Model Papers -2026
Question 3
Which error occurs when deleting a parent row that still has child rows?
FPSC - Database Administrator Model Papers -2026
Question 4
Which error occurs when inserting NULL into a NOT NULL column?
FPSC - Database Administrator Model Papers -2026
Question 5
Which error indicates the net service name in a connect string cannot be resolved?
FPSC - Database Administrator Model Papers -2026
Question 6
Which query shows the global name of the current database?
FPSC - Database Administrator Model Papers -2026
Question 7
Which statement removes a database link?
FPSC - Database Administrator Model Papers -2026
Question 8
Is DML such as UPDATE allowed on a remote table through a database link?
FPSC - Database Administrator Model Papers -2026
Question 9
A database link created without a CONNECT TO clause is called a:
FPSC - Database Administrator Model Papers -2026
Question 10
Which Oracle product allows querying non-Oracle databases (such as SQL Server) through database links?
FPSC - Database Administrator Model Papers -2026