PrepAway - Latest Free Exam Questions & Answers

where is the actual data stored?

With SQL Relational databases where is the actual data stored?

PrepAway - Latest Free Exam Questions & Answers

A.
Views

B.
Tables

C.
Schemas and sub-schemas

D.
Index-sequential tables

Explanation:
SQL is a relational database Query language. SQL stands for structured query language.Schemas describe how the tables and views are structured – careful design is required so that the SQL
database runs in an efficient manner. Tables are made up of rows and columns and contain the actual data.
Views represent how you want to look at the data. They are not concerned with where the data is, but rather
what data you want to view and how you want to see it. You can even join more than one table together.
However, the less efficient the views, the longer it takes to retrieve your report. Sub- schemas may be used to
establish user privileges to see data.


Leave a Reply