OMIS 452 – 28 SQL Questions on Queries, Joins, Functions & Access Syntax

This document offers 28 exam-style questions and answers from Chapter 3 of the OMIS 452 course, emphasizing SQL query formulation and execution. It comprehensively addresses key SQL concepts such as SELECT statements, WHERE conditions, JOIN operations, GROUP BY, ORDER BY, and subqueries. The questions also explore the use of SQL functions (AVG, SUM, COUNT, etc.), wildcards, sorting, constraints like ON DELETE CASCADE, and correct syntax for creating tables in SQL and Microsoft Access. Students will also encounter distinctions between standard SQL and Access SQL, and practical details like using the DISTINCT, NOT LIKE, BETWEEN, and IN operators. This document is a valuable resource for students in OMIS, MIS, Information Systems, Business Analytics, IT, or Computer Science courses. It is particularly helpful for mid-level undergraduates who are learning database querying, data manipulation, and relational schema operations using SQL and Microsoft Access. The content supports both conceptual understanding and practical SQL syntax proficiency for academic exams and real-world data tasks. Keywords: OMIS 452, SQL queries, SELECT statements, WHERE clause, JOIN, GROUP BY, ORDER BY, DISTINCT, NOT LIKE, IN operator, BETWEEN, subqueries, SQL functions, Microsoft Access SQL, ON DELETE CASCADE, referential integrity, data types, table creation, Access query window