Free Test SQL History & Standards – SQL

Q1: Who developed SQL originally?

A. IBM B. Oracle C. Microsoft D. Google

Q2: Who developed the original version of SQL?

A. IBM B. Oracle C. Microsoft D. Sun Microsystems

Q3: Which project led to the development of SQL?

A. System R B. Project X C. Oracle Lab D. Turing Machine

Q4: When did SQL become a standard of ANSI?

A. 1986 B. 1990 C. 1980 D. 1996

Q5: What does ANSI stand for in SQL standards?

A. American National Standards Institute B. Association of National SQL Institutions C. Advanced SQL Network Institute D. American Network of SQL Integration

Q6: Which organization standardizes SQL internationally?

A. ISO B. IEEE C. W3C D. IETF

Q7: What was the original name of SQL?

A. SEQUEL B. SQUARE C. SQL-86 D. SQL-PROTO

Q8: Why was SEQUEL renamed to SQL?

A. Trademark issues B. Too long C. Did not support standardization D. IBM changed direction

Q9: Which version of SQL standard was released in 1999?

A. SQL:1999 B. SQL2 C. SQL 3.0 D. SQL ISO V2

Q10: Which version of SQL introduced XML support?

A. SQL:2003 B. SQL:1999 C. SQL:2011 D. SQL:2008

Q11: Which SQL standard introduced JSON support?

A. SQL:2016 B. SQL:2008 C. SQL:1999 D. SQL:2020

Q12: What is the purpose of SQL standards?

A. Ensure compatibility across databases B. Prevent hacking C. Enable Java support D. Reduce storage space

Q13: Which of the following databases was among the first to implement SQL?

A. Oracle B. MySQL C. PostgreSQL D. SQLite

Q14: What year did Oracle first release its SQL-based product?

A. 1979 B. 1986 C. 1991 D. 1972

Q15: Which SQL standard introduced window functions?

A. SQL:2003 B. SQL:2016 C. SQL:1999 D. SQL:2020

Q16: Which SQL standard emphasized support for temporal data?

A. SQL:2011 B. SQL:2008 C. SQL:2003 D. SQL:1992

Q17: What does the SQL standard SQL:2008 focus on?

A. MERGE statements and INSTEAD OF triggers B. Machine learning C. Embedded Java support D. Blockchain

Q18: What type of language is SQL considered to be?

A. Declarative B. Procedural C. Object-Oriented D. Imperative

Q19: Which is not a part of SQL standard?

A. Machine Learning models B. Data Definition Language (DDL) C. Data Manipulation Language (DML) D. Transaction Control Language (TCL)

Q20: Which database uses its own variant called T-SQL?

A. Microsoft SQL Server B. Oracle C. MySQL D. MongoDB

Q21: What does the SQL standard define?

A. Syntax and behavior of SQL features B. Server architecture C. Database engine implementation D. RAM size

Quiz for SQL History & Standards