RelationalDBDesign
Technology
Search
SiteMap
RedhatLinuxSys
Seomining
Advanced Oracle Tuning
Advanced SQL
Backup Recovery Options
Basic SQL
DB Admin Features
DB Creation Architecture
Extended DB Features
Managing DB Objects
Managing Connectivity
Network Configuration
Oracle BU Features
Oracle DB Recovery
Network Administration
Oracle Network Topology
Oracle SQL Extensions
Oracle SQL Tuning
8i PL/SQL Programming
Performance Tuning
PL/SQL Stored Objects
PL/SQL Programming
Relational DB Analysis
Relational DB Design
Tech Interview Questions
Tuning Oracle Instance
SQL Introduction
SQL Select Statement
Relational Databases
Foundations of SQL
SQL Table Querying
Database FlatFile - Quiz
What are the differences between database 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
Score =
Correct answers:
Quiz Explanation
