DS0-001 · Question #68
Which of the following is used to write SQL queries in various programming languages?
The correct answer is B. Object-relational mapping. Object-relational mapping (ORM) is the technique that allows developers to write database queries using their preferred programming language (Python, Java, C#, etc.) instead of raw SQL - frameworks like SQLAlchemy, Hibernate, and Entity Framework translate object-oriented code in
Question
Which of the following is used to write SQL queries in various programming languages?
Options
- AIndexing
- BObject-relational mapping
- CExcel
- DNormalization
How the community answered
(38 responses)- A5% (2)
- B92% (35)
- C3% (1)
Explanation
Object-relational mapping (ORM) is the technique that allows developers to write database queries using their preferred programming language (Python, Java, C#, etc.) instead of raw SQL - frameworks like SQLAlchemy, Hibernate, and Entity Framework translate object-oriented code into SQL behind the scenes. Indexing (A) is a database optimization technique that speeds up query lookups, not a way to write queries. Excel (C) is a spreadsheet application with no role in programmatic SQL query generation. Normalization (D) is a database design process for organizing tables to reduce redundancy, unrelated to how queries are written in code.
Memory tip: Think of ORM as a translator - it maps your objects (in code) to relational tables (in the database), so you never have to leave your programming language to talk to SQL.
Topics
Community Discussion
No community discussion yet for this question.