SQL Programming Exam Questions
Course Introduction
SQL Programming introduces students to the fundamentals of Structured Query Language (SQL) used for managing and manipulating relational databases. The course covers essential topics such as database design concepts, writing queries to retrieve, insert, update, and delete data, as well as using aggregate functions and joining multiple tables. Students will also explore advanced concepts like subqueries, indexing, and stored procedures, gaining hands-on experience through practical exercises and real-world scenarios. By the end of the course, learners will be equipped with the skills necessary to design efficient queries and manage data across various database management systems.
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) Because Premiere Products wants the flexibility to quote and charge different prices to different customers, the QUOTED_PRICE column is included in the ORDER_LINE table.
A)True
B)False
Answer: True
Q2) Alexamara stores information about the boat owners to whom it rents slips in the ____________________ table.
Answer: OWNER
Q3) The LENGTH column in the MARINA_SLIP table in the Alexamara Marina Group stores the length of the boat in meters.
A)True
B)False
Answer: False
Q4) A category name uniquely identifies each service that Alexamara performs. A)True
B)False
Answer: False
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 relation, all values in a column are values of the same attribute.
A)True
B)False
Answer: True
Q2) You can determine functional dependence by viewing sample data.
A)True
B)False
Answer: False
Q3) If a table contained both employee numbers and Social Security numbers, both columns would be referred to as candidate keys.
A)True
B)False
Answer: True
Q4) A(n) ____ is a characteristic or property of an entity.
A) field
B) attribute
C) column
D) All of the above
Answer: D
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) Unlike Oracle, Access does not support the DECIMAL data type.
A)True
B)False
Answer: True
Q2) The data type DECIMAL(5,2) represents a number with three places to the left and two places to the right of the decimal.
A)True
B)False
Answer: True
Q3) To move back one or more pages in Oracle Database Express, click the pages in the task bar.
A)True
B)False
Answer: False
Q4) You indicate the end of a command by typing a ____.
A) column
B) comma
C) semicolon
D) period
Answer: C
Page 5
To view all questions and flashcards with answers, click on the resource link above.
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) The ____ operator specifies a range of values in a condition.
A) LIKE
B) BETWEEN
C) DISTINCT
D) GROUP
Q2) Oracle supports only the <> version of the "not equal to" comparison operator.
A)True
B)False
Q3) How do you construct the SELECT query?
Q4) When you connect two or more simple conditions with the AND operator, each condition must be listed on a separate line.
A)True
B)False
Q5) You cannot assign names to computed columns.
A)True
B)False
Q6) All SELECT statements require a WHERE clause.
A)True
B)False
Page 6
Q7) The column on which data is to be sorted is called a sort
To view all questions and flashcards with answers, click on the resource link above.
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) It is permissable to qualify all column names in a query.
A)True
B)False
Q2) If you precede a subquery by the ____________________ operator, the condition is true only if it satisfies one or more values produced by the subquery.
Q3) When tables are listed in the FROM clause, you can give each table a(n) ____________________, or an alternate name.
Q4) The ____________________ of two tables is the combination of all rows in the first table and all rows in the second table.
Q5) Table A has 10 rows and table B has 10 rows. The product of Table A and Table B would have 100 rows.
A)True
B)False
Q6) You can join tables by using a condition in the WHERE clause.
A)True
B)False
Q7) Joining a table to itself is called a(n) ____________________.
Q8) 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) In SQL Server, execute the sp_columns command to list all the columns in a table.
A)True
B)False
Q2) You cannot commit and roll back data in SQL Server.
A)True
B)False
Q3) Describe the format of the ALTER TABLE command to add a new column.
Q4) By placing a(n) ____________________ command in an INSERT command, you can add the query results to a table.
Q5) In SQL, use the ____ data type for variable-length character columns.
A) TEXT
B) VARCHAR
C) VARIABLE
D) CHARLENGTH
Q6) There are table structure changes that are beyond the capabilities of SQL.
A)True
B)False
Q7) The ROLLBACK command reverses changes made to the ____________________ only.
Q8) A(n) ____________________ is a logical unit of work.
To view all questions and flashcards with answers, click on the resource link above. Page 8
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) The command used to delete an index is ____________________.
Q2) The DROP VIEW command removes the tables and data on which the view is based.
A)True
B)False
Q3) You cannot delete a row from a view.
A)True
B)False
Q4) When renaming columns, you include the new column names in ____ following the name of the view.
A) single quotes
B) double quotes
C) parentheses
D) square brackets
Q5) In Oracle, the ____ table contains information about the tables known to SQL.
A) DBA_TABLES
B) SHOW_TABLES
C) ALL_TABLES
D) SP_TABLES
Q6) Explain what happens when you create a query that involves a view.
Q7) The command used to create an index is ____________________.
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) Each procedure that you create in Oracle should end with a(n)
Q2) You can embed SQL commands in Access programs similarly to the way you can in PL/SQL and T-SQL.
A)True
B)False
Q3) In the function UPPER(LAST_NAME), the item in parentheses (LAST_NAME) is called the ____________________ for the function.
Q4) In PL/SQL, you can ensure that a variable has the same data type as a particular column by using the ____ attribute.
A) @VARIABLE
B) %VARIABLE
C) @DATATYPE
D) %TYPE
Q5) SQL Server uses an extended version of SQL called T-SQL or Transact-SQL.
A)True
B)False
Q6) To close a cursor and deactivate it, use the ____________________ command.
Q7) A procedure that updates data is called a(n) ____________________ procedure.
To view all questions and flashcards with answers, click on the resource link above. Page 10