DS0-001 · Question #63
DS0-001 Question #63: Real Exam Question with Answer & Explanation
The correct answer is B: PL/SQL. PL/SQL (Oracle) and T-SQL (Microsoft SQL Server) are both procedural extensions of SQL, meaning they combine standard data manipulation (SELECT, INSERT, UPDATE, DELETE) with procedural constructs like variables, loops, conditionals, exception handling, and stored procedures - giv
Question
Which of the following have data manipulation and procedural scripting power? (Choose two.)
Options
- APQL
- BPL/SQL
- CAdvanced SQL
- DSQL
- ET-SQL
- FMySQL
Explanation
PL/SQL (Oracle) and T-SQL (Microsoft SQL Server) are both procedural extensions of SQL, meaning they combine standard data manipulation (SELECT, INSERT, UPDATE, DELETE) with procedural constructs like variables, loops, conditionals, exception handling, and stored procedures - giving them power beyond plain SQL.
Why the others are wrong:
- SQL (D) is declarative, not procedural - it can manipulate data but lacks native control-flow scripting constructs.
- MySQL (F) is a database system, not a language - it's a distractor playing on name recognition.
- Advanced SQL (C) is not a recognized language; it's a made-up term used as a distractor.
- PQL (A) is not a standard database language with both capabilities; it appears in niche contexts but has no broad procedural+DML identity.
Memory tip: Look for the prefix - PL/SQL stands for "Procedural Language/SQL" and T-SQL stands for "Transact-SQL," both explicitly signaling they extend SQL with procedural power. If the name just says "SQL" or is a vendor/system name rather than a language extension, it's likely not the answer.
Community Discussion
No community discussion yet for this question.