RelationalDBDesign
SiteMap
Advanced SQL
Essential SQL
Interview Questions
SQL Foundations
«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 Elements - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Which portion of a database system contains the actual data elements, such as the name, address, or a phone number for a particular person?
Please select the best answer.
A.
Tables
B.
Columns
C.
Rows
D.
Databases
2.
Which of the following statements is false?
Please select the best answer.
A.
Tables contain one or more rows.
B.
Rows contain one or more databases of information.
C.
Columns contain the detailed information stored in the system.
D.
Databases contain one or more tables.
3.
Which SQL statement is used to extract data from a database?
A.
Get
B.
Extract
C.
Open
D.
Select
Correct answers:
Your Score: 0
Submit
Quiz Explanation