SQL Programming Question Bank
Course Introduction
SQL Programming introduces students to the fundamentals of Structured Query Language (SQL), the standard language for interacting with relational databases. This course covers essential SQL concepts including data definition, data manipulation, and data control operations. Students will learn how to write queries to create, retrieve, update, and delete data within database tables. Topics also include the use of joins, subqueries, indexes, and transactions to efficiently manage and organize complex datasets. Through hands-on exercises and real-world scenarios, students will develop the practical skills required for database development, administration, and data analysis roles across a variety of industries.
Recommended Textbook
A Guide to SQL 8th Edition by Philip J. Pratt
Available Study Resources on Quizplus
8 Chapters
600 Verified Questions
600 Flashcards
Source URL: https://quizplus.com/study-set/1123 Page 2
Chapter 1: Introduction to Premiere Products, Henry Books, and Alexamara Marina Group
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22071
Sample Questions
Q1) Alexamara provides boat maintenance service for owners at its two marinas. The SERVICE_CATEGORY table contains a ____.
A) slip ID
B) marina number
C) description of the category
D) marina name
Answer: C
Q2) The Alexamara Marina Group database uses a combination of letters and numbers to represent an owner number.
A)True
B)False Answer: True
Q3) An example of a relationship between categories is the relationship that exists in the Premiere Products database between sales reps and customers.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above.
Page 3
Chapter 2: Database Design Fundamentals
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22072
Sample Questions
Q1) In a relational database, column B is ____________________ on another column A, if at any point in time a value for A determines a single value for B.
Answer: functionally dependent
Q2) ____ can occur when there is a column in a table that is dependent on only a portion of the primary key.
A) Qualification
B) Update anomalies
C) Function splitting
D) Determination
Answer: B
Q3) Any column (or collection of columns) that determines another column is called a(n) ____.
A) nonkey column
B) primary key
C) dependency
D) determinant
Answer: D
Q4) A(n) ____________________ is another name for a record or a row.
Answer: tuple
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Creating Tables
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22073
Sample Questions
Q1) You use the ____________________ command to describe the layout of a table.
Answer: CREATE TABLE
Q2) The data type DECIMAL(5,2) represents a number with ____________________ places to the left and two places to the right of the decimal.
Answer: three 3
Q3) Table names cannot contain spaces.
A)True
B)False
Answer: True
Q4) In Oracle, the date, November 12, 2010 would be stored as '12-NOV-2010'.
A)True
B)False
Answer: True
Q5) To run SQL commands in Access, you must first create a new query.
A)True
B)False
Answer: True
Q6) SQL is Structured ____________________ Language.
Answer: Query
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Single-Table Queries
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22074
Sample Questions
Q1) Describe simple and compound conditions.
Q2) You cannot assign names to computed columns.
A)True
B)False
Q3) The column on which data is to be sorted is called a sort
Q4) When you use the ____ function, you can use the asterisk (*) to represent any column.
A) SUM
B) COUNT
C) MAX
D) MIN
Q5) Aggregate functions apply to groups of rows.
A)True
B)False
Q6) In a SELECT statement, the FROM clause and the WHERE clause (when used) must appear on separate lines.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Q7) A(n) ____________________ clause provides a concise way of phrasing certain conditions.
Chapter 5: Multiple-Table Queries
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22075
Sample Questions
Q1) To produce the same results as the MINUS operator, use NOT, the IN operator and a subquery.
A)True
B)False
Q2) You can use the IN operator to retrieve data from multiple tables..
A)True
B)False
Q3) To qualify a column name, precede the name of the column with the name of the table, followed by a(n) ____.
A) comma (,)
B) period (.)
C) percent sign (%)
D) asterisk (*)
Q4) Sometimes you need to list all the rows from one of the tables in a join, regardless of whether they match any rows in the other table. This type of join is called a(n) ____________________ join.
Q5) To relate two tables, in the FROM clause list all columns involved in the query.
A)True
B)False
Q6) Describe the types of outer joins.
Page 7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Updating Data
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22076
Sample Questions
Q1) To add a new column, use the ____________________ clause of the ALTER TABLE command.
Q2) In a transaction, it is acceptable if some steps fail.
A)True
B)False
Q3) You can use the existing value in a column and a calculation to update a value.
A)True
B)False
Q4) The command, CREATE TABLE AS LEVEL1_CUSTOMER FROM CUSTOMER; creates a table called LEVEL1_CUSTOMER that has the same structure as CUSTOMER.
A)True
B)False
Q5) Access does not support the ____ data type.
A) DECIMAL
B) CURRENCY
C) CHAR
D) INT
Q6) You can create a new table using data in an existing table.
A)True
B)False
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Database Administration
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22077
Sample Questions
Q1) A view can join two or more tables.
A)True
B)False
Q2) Within relational model systems on both mainframes and personal computers, the main mechanism for increasing the efficiency with which data is retrieved from the database is the ____________________.
Q3) When you create a view, you cannot assign column names that are different from those in the base table.
A)True
B)False
Q4) A(n) ____________________ subset view consists of a subset of the rows and columns in some base table.
Q5) To ensure the uniqueness of values in a non-primary key column, you can create a unique index by using the ____________________ command.
Q6) The DBMS provides integrity administration, the process of specifying integrity constraints for a database that the DBMS will enforce.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: SQL Functions and Procedures
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/22078
Sample Questions
Q1) SQL is a powerful ____________________ language in which you communicate tasks to the computer using simple commands.
Q2) In SQL Server, use the & symbol to concatenate columns.
A)True
B)False
Q3) A(n) ____________________ is a procedure that is executed automatically in response to an associated database operation, such as an INSERT, UPDATE, or DELETE command.
Q4) To truncate (remove) everything to the right of the decimal point, use the TRUNCATE function.
A)True
B)False
Q5) To create a stored procedure in Oracle, use the ____ command.
A) CREATE ROUTINE
B) CREATE SCRIPT
C) CREATE PROCEDURE
D) CREATE EXECUTABLE
Q6) If a price is 24.95, the function ROUND(PRICE,0) would result in 24.
A)True
B)False
Page 10
To view all questions and flashcards with answers, click on the resource link above.