OMIS 452 | 35 Quiz Questions on SQL Functions, Data Types, Transactions, Views, Subselects

This document includes 35 expertly answered quiz questions from Quiz 7 of OMIS 452 at Northern Illinois University, built around SQL training material from L (Chapter 7-based content). It provides clear answers and practical examples for understanding both foundational and intermediate-level SQL programming and MySQL usage. Topics covered include: SQL statements: SELECT, UPDATE, DELETE, DROP, CREATE, INSERT, ROLLBACK, COMMIT Subselects and nested queries SQL data types (DECIMAL, TINYINT, BOOLEAN) and operators (IN, LIKE, GROUP BY) Functions and constraints: LOCATE, AVG, COUNT, CHECK, PRIMARY KEY Transaction control with START TRANSACTION, COMMIT, ROLLBACK Views, stored procedures, and stored functions Cross-platform database tools like XAMPP Use of aliases, escaping characters in SQL strings, and user permissions for routines It also emphasizes best practices such as performance optimization for bulk updates and understanding the logic of Boolean expressions and string operations within SQL engines like MySQL. Ideal for: OMIS 452 students preparing for practical SQL quizzes or programming assignments Business Analytics, IT, and Computer Science students learning MySQL or relational databases Learners using L (LinkedIn Learning) resources for supplemental instruction Anyone reviewing for SQL certifications, data handling roles, or development positions This document is a practical and concise guide for solidifying SQL concepts tested in real-world coursework and assessments. Keywords: SQL functions, SELECT statement, LIMIT, LOCATE, PDO, data types, DECIMAL, TINYINT, TRANSACTION, COMMIT, ROLLBACK, aggregate function, update statement, subselect, view, stored procedure, CREATE DATABASE, MySQL, constraints, OMIS 452, Northern Illinois University