Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question.

Asked: November 13, 2017 - 6:31 pm UTC

Last updated: November 15, 2017 - 2:01 am UTC

Version: mysql 6.3

Viewed 1000+ times

You Asked

I am not able to understand this question. What are they asking in the question? Thank You!:

"Starting at the client invocation describe the mechanics of the DBMS through a SQL SELECT all the way through the response to the client. Name all facilities of the DBMS and their functions."

and Connor said...

Sounds like an interview question to gauge knowledge on the database. I can't speak for MySQL but for Oracle it would be something like:

- select statement passed to database engine
- checked for syntax validity (eg "from" spelt as fmro" etc)
- checked for semantic validity (tables exist, privileges, synonyms etc)
- optimization ("how" to run the query)
- execution (locate extents on disk)

etc etc etc

Each of course could go into further and further details....like heading down a rabbit hole :-)

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Stages of SQL Processing

Rajeshwaran Jeyabal, November 14, 2017 - 7:06 am UTC

In addition to the above the Stage of SQL Processing is nicely summarized in the concepts guide.
https://docs.oracle.com/database/122/CNCPT/sql.htm#CNCPT1741
Connor McDonald
November 15, 2017 - 2:01 am UTC

Might not apply to MySQL though :-)

Double whammy...

Alex, November 14, 2017 - 9:15 pm UTC

An interview question AND mysql...

The next version of AskTom they really need to give you guys a delete button.
Connor McDonald
November 15, 2017 - 1:57 am UTC

oh yeah :-)

More to Explore

Performance

Get all the information about database performance in the Database Performance guide.