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
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.
Score =
Correct answers:
Explanation