RelationalDBDesign
SiteMap
Advanced SQL
Essential SQL
Interview Questions
Select Statement
«Prev
Next»
SQL Introduction
Course Prerequisites
Select Statement
What is SQL
Sample SQL Statement
Client/Server Request
SQL 92 (History)
SQL Dialect Variations
Database Selection
Database Setup
MS-SQL Server
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 Spreadsheets
Database Parts - Quiz
Table Structure SQL
Create Table
Databases Column Types
Table Index
Create Index Column
Database Index Engine
Database Foundations - Quiz
SQL Insert
SQL Select Statement
Selecting Information
Tables Rows Dsatabase
Querying XML
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
SQL Approaches and Dialects- Quiz
Each question is worth one point. Select the best answer for each question.
1.
What is a dialect?
Please select the best answer.
A.
A dialect refers to the origin of SQL and is generally geographically oriented.
B.
A dialect results when a particular database engine chooses to ignore the standards and create its own version of the SQL-92 standard.
C.
A dialect refers to statements that make up exceptions and/or additions to the SQL-92 standard and are relative to a particular database engine.
D.
All of the above.
2.
What type of language is SQL?
Please select the best answer.
A.
Instructional
B.
English-like
C.
ANSI-standard
D.
Declarative
3.
Which explanation most closely matches a definition of client/server approaches to applications?
Please select the best answer.
A.
Client/server refers to how the application is developed, with the client providing the software specification for use on the server.
B.
Client/server refers to the fact that the application uses a central file and print server.
C.
Client/server lets you split functionality between the workstation and the server, allowing each do what it does best for the application.
D.
Client/server is a term for an Internet-enabled application.
Correct answers:
Your Score: 0
Submit
Quiz Explanation