Information Systems
Final Exam
Course Introduction
Information Systems is a foundational course that explores the role and impact of information technology within organizations. Students will learn about the core components of information systems, including hardware, software, data management, networking, and processes that support business operations and decision-making. The course covers key concepts such as system development, data security, ethical considerations, and the strategic use of information systems to achieve organizational goals. Through case studies and practical examples, students will examine how information systems are designed, implemented, and managed to solve real-world business problems and drive innovation.
Recommended Textbook
A Guide to SQL 9th Edition by Philip J. Pratt
Available Study Resources on Quizplus
8 Chapters
600 Verified Questions
600 Flashcards
Source URL: https://quizplus.com/study-set/813
Page 2
Chapter 1: Introduction to TAL Distributors, Colonial
Adventure Tours, and Solmaris Condominium Group
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/16101
Sample Questions
Q1) In the Colonial Adventure Tours database,the GUIDE table contains the guide's number,name,address,and salary.
A)True
B)False
Answer: False
Q2) How many tables make up the TAL Distributors database? A)4
B)5
C)6
D)7
Answer: B
Q3) Colonial Adventure Tours identifies each reservation by a unique reservation number that uses the last ____________________ digits of the current year followed by a five-digit number.
Answer: two 2
Q4) The table named ____________________ is used to relate trips and guides in the Colonial Adventure Tours database.
Answer: TRIP_GUIDES
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Database Design Fundamentals
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/16102
Sample Questions
Q1) ____ is the formal term for combining two or more columns to form a primary key.
A)Qualification
B)Joining
C)Normalization
D)Concatenation
Answer: D
Q2) The four categories of update anomalies are additions,deletions,inconsistent data,and ____________________.
Answer: updates
Q3) A relation is in ____________________ normal form if it does not contain any repeating groups.
Answer: first 1NF
Q4) In one style of entity-relationship (E-R)diagrams,a crow's foot is used to represent the ____________________ side of a relationship.
Answer: many
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/16103
Sample Questions
Q1) In Oracle,the date,November 12,2015 would be stored as '12-NOV-2015'.
A)True
B)False
Answer: True
Q2) In this text,SQL commands are illustrated using ____________________. Answer: Oracle
Oracle Database Express Edition
Oracle 11g Express
Q3) To move back one or more pages in Oracle Database 11g Express,click the pages icon in the task bar.
A)True
B)False
Answer: False
Q4) You must enclose values in ____________________ quotation marks for any column whose type is character (CHAR),even when the data contains numbers.
Answer: single
Q5) You can delete the entire table using the ____________________ TABLE command.
Answer: DROP
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/16104
Sample Questions
Q1) You cannot assign names to computed columns.
A)True
B)False
Q2) An arithmetic column is a column that does not exist in the database but can be computed using data in existing columns.
A)True
B)False
Q3) A query is a question represented in a way that the DBMS can understand.
A)True
B)False
Q4) A(n)____________________ column is a column that does not exist in the database but can be computed using data in the existing columns.
Q5) When you use the MAX function,SQL ignores any ____________________ value(s)in the column and eliminates them from the computations.
Q6) The ____ clause lets you group data on a particular column.
A)GROUP
B)GROUP BY
C)SET GROUP
D)GROUPING
Page 6
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/16105
Sample Questions
Q1) If you precede the subquery by the ____ operator,the condition is true only if it satisfies all values produced by the subquery.
A)TRUE
B)ALL
C)IS ALL
D)ALWAYS
Q2) What steps should you take to construct the SQL command to join (relate)tables?
Q3) A join that compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause is called a(n)____________________ join.
Q4) A(n)____ clause can include statistics calculated for only the groups or columns whose values are identical for each row in a group.
A)SELECT
B)WHERE
C)FROM
D)EXISTS
Q5) When joining tables,it is always necessary to qualify a column name.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Updating Data
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/16106
Sample Questions
Q1) In a transaction,it is acceptable if some steps fail.
A)True
B)False
Q2) With SQL,you can change a table's structure by using the ____________________ command.
Q3) To permanently remove both a table and its data,you must issue both a DROP TABLE command and a DELETE command.
A)True
B)False
Q4) Which of the following commands executes a rollback?
A)ROLLBACK TABLE;
B)ROLLBACK;
C)ROLLBACK ALL;
D)ROLLBACK DB;
Q5) Before beginning the updates for a transaction,commit any previous updates by executing the ____________________ command.
Q6) The DROP TABLE command creates an empty table.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 8
Q7) You use the ____________________ command to remove rows from a table.
Chapter 7: Database Administration
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/16107
Sample Questions
Q1) The command used to create an index is ____________________.
Q2) The database administrator uses the ____________________ command to revoke privileges from users.
Q3) To ensure the uniqueness of values in a nonprimary key column,use the ____ command to create an index.
A)CREATE UNIQUE INDEX
B)CREATE NONPRIMARY INDEX
C)CREATE INDEX
D)CREATE ONLY INDEX
Q4) The general form for assigning a foreign key is ADD FOREIGN KEY,the column name(s)of the foreign key,the ____ clause,and then the table name that the foreign key must match.
A)WHERE
B)REFERENCES
C)FROM
D)IN
Q5) Views provide a measure of security.
A)True
B)False
Q6) ____________________ is the prevention of unauthorized access to a database.
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/16108
Sample Questions
Q1) Variable names in PL/SQL must start with a letter and can contain letters,dollar signs,underscores,and number signs,but cannot exceed ____ characters.
A)15
B)30
C)45
D)60
Q2) In T-SQL,arguments should have the same data type and length as the particular column in a table that they represent.
A)True
B)False
Q3) PL/SQL,which was developed by Oracle as an extension of SQL,is an example of a procedural language.
A)True
B)False
Q4) Microsoft Access supports triggers.
A)True
B)False
Q5) To handle processing of errors,include a(n)____________________ clause in stored procedure.
To view all questions and flashcards with answers, click on the resource link above. Page 10