Multiple choice technology databases

What is true about RDBMS? Choose all that apply

  1. A system consisting of tables and relation between the tables

  2. Writes efficient queries itself without user intervention to retrieve and manipulate the data stored

  3. Handles data retrieval and manipulation using a functional programming language called SQL (Structured Query Language)

  4. A system consisting of memory structures and background process

  5. Translates a SQL query into a series of operations that retrieve the actual data from the database
Reveal answer Fill a bubble to check yourself
A,C,E Correct answer
Explanation

RDBMS is a system of tables and relationships (A). It uses SQL for retrieval and manipulation (C), and translates SQL queries into data operations (E). RDBMS doesn't automatically write efficient queries - the user must write them (B is false). Memory structures and processes describe instance architecture, not the RDBMS concept (D is false).

Keep practicing — related questions