RelationalDBDesign
SiteMap
Advanced SQL
Essential SQL
Interview Questions
Relational Databases
«Prev
Next»
SQL Introduction
Course Prerequisites
SQL Fundamentals
What is SQL
Sample SQL Statement
SQL 92 (History)
SQL Dialect Variations
Database Selection
Database Setup
SQL Module Review
Relational Databases
Relational vs Flatfile
Different Storage Formats
Relational DB Analogy
Database Normalization
Data Table Example
Normalization Example Table
Table Normalization - Exercise
Three Normalization Levels
Relational Flatfile DB
SQL Columns Rows
SQL Foundations
Database Elements
Database Parts - Quiz
Table Structure SQL
Create Table
Table Index
Create Index Column
Database Index Engine
Database Foundations - Quiz
SQL Insert
SQL Select Statement
Querying XML
Tables Rows Database
Table Querying
SQL Conclusion
INTO Statement
Order By Clause
SQL Into Statement
Filtering Select
Where Clause
Like Statement
into Statement
Sorting Data
Order by Clause
Sort Select
Ascending Descending Order
Select Statement
More SQL
Filtering Select Statement
Joining Tables
Join Where Clause
SQL Joins Explained
Where Clause Join
inner-outer-joins
left-right-full-joins
left-right-joins
SQL Union Operator
SQL Join Conclusion
Database FlatFile - Quiz
This quiz tests your understanding of the differences between database and flatfile approaches.
Each question is worth one point. Select the best answer for each question.
1.
What does "flat file" refer to?
Please select the best answer.
A.
A type of database storage method where all of the data elements are stored on top of each other
B.
A fully-relational database system like Microsoft's SQL Server or Oracle's database systems
C.
Non-relational systems that typically store each table and index in separate files and often do not support the SQL language
D.
None of the above
2.
Which of the following statements is true?
Please select the best answer.
A.
Flat file database systems pay more attention to retrieving data and making it accessible to the user, whereas relational databases spend more energy updating indexes and data pointers.
B.
Relational database systems are the main thrust behind SQL since it provides the language elements needed to tie together the information in the database.
C.
Relational systems pay more attention to retrieving data and making it accessible to the user.
D.
Both B and C
3.
Which statement best contrasts a relational database with flat file storage?
Please select the best answer.
A.
Flat file storage is designed to enforce relationships between multiple tables, while relational databases usually store all data in one file.
B.
Relational databases can organize data into related tables and support SQL-based queries, whereas flat file storage usually keeps data in isolated files without built-in relationships.
C.
Relational databases do not use rows and columns, while flat file systems always require SQL for access.
D.
There is no meaningful difference because both systems manage data the same way.
4.
What distinguishes a relational database from a flat-file database?
Please select the best answer.
A.
Relational databases store data in a single table, whereas flat-file databases store data across multiple related tables.
B.
Relational databases cannot support complex queries and relationships, unlike flat-file databases.
C.
Relational databases organize data into tables with rows and columns, with the ability to establish relationships between tables, unlike flat-file databases which typically consist of a single table.
D.
Flat-file databases require structured query language (SQL) for data manipulation, whereas relational databases do not.
Submit