Core OOP Principles

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Core OOP Principles. Start with the requirements and the two tables on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

You need to log in / sign up to run or submit.

Problem

What are the four main principles of object-oriented programming?

Use the supplied relational data to return the four principles and their examples. The result should include one row per core principle and preserve the standard instructional order.

Output

Columns: principle_name, definition, and examples
Include only the four core principles, with examples combined into one field
Order by the instructional order stored in the data

Schema

oop_principles

Column	Type	Description
principle_idPK	INT	Unique principle identifier
principle_name	VARCHAR(100)	Name of the object-oriented programming concept
definition	TEXT	Concise definition of the concept
is_core	BOOLEAN	Whether the concept is one of the four requested principles
display_order	INT	Conventional instructional order

principle_examples

Column	Type	Description
example_idPK	INT	Unique example identifier
principle_id	INT	Referenced object-oriented principle
example_text	VARCHAR(255)	Illustrative example of the principle

Tablesoop_principlesprinciple_examples

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results