Information Systems Practice Exam
Course Introduction
Information Systems explores the use and management of information technology to support organizational processes, decision-making, and strategic objectives. This course covers foundational concepts such as system components, data management, communication networks, and the integration of hardware and software resources. Students will learn about the role of information systems in businesses, including enterprise resource planning, e-commerce, and cybersecurity. Emphasis is placed on understanding how information systems align with business goals, improve efficiency, and provide a competitive advantage, as well as addressing ethical and social considerations in the digital age.
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) Why would you not combine the two tables ORDERS and ORDER_LINE at Premiere Products?
Answer: If the two tables were combined, the new table would be more complicated. Some of the individual positions within this table will contain multiple entries, making it difficult to track the information between columns. In general, the simpler structure is preferable, and that is why order lines appear in a separate table.
Q2) The ____ field of the WROTE table of Henry Books indicates the order in which the authors of a particular book are listed on the cover.
A) ORDER
B) SEQUENCE
C) ORDERS
D) NUMBER
Answer: B
Q3) If another appointment is required to complete additional service, the appointment date appears in the NEXT_SERVICE_DATE column of the ____________________ table of Alexamara.
Answer: SERVICE_REQUEST
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) A primary key always comprises a single column.
A)True
B)False
Answer: False
Q2) A record is another term for a(n) ____.
A) row
B) field
C) attribute
D) property
Answer: A
Q3) A matrix is the association between entities.
A)True
B)False
Answer: False
Q4) In a relational database each ____ should be unique.
A) row
B) record
C) tuple
D) All of the above
Answer: D
Page 4
To view all questions and flashcards with answers, click on the resource link above.
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) In this text, SQL commands are illustrated using ____________________.
Answer: Oracle
Oracle Database Express Edition
Oracle 10G Express
Q2) You must enclose values in ____________________ quotation marks for any column whose type is character (CHAR), even when the data contains numbers.
Answer: single
Q3) In SQL Server, execute the sp_columns command to list all the columns in a table.
A)True
B)False
Answer: True
Q4) To indicate columns that cannot contain null values, use the ____________________ clause in a CREATE TABLE statement.
Answer: NOT NULL
Q5) Dropping a table also deletes any data that you entered into the table.
A)True
B)False
Answer: True
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) The DISTINCT operator is useful when used in conjunction with the COUNT function.
A)True
B)False
Q2) The only arithmetic operators that can be used in SELECT statements are + for addition and - for subtraction.
A)True
B)False
Q3) The MIN function determines the minimum value in a column.
A)True
B)False
Q4) You can assign a name to a computed column by following the computation with the word ____________________ and the desired name.
Q5) The UNIQUE operator eliminates duplicate values in a query.
A)True
B)False
Q6) The GROUP BY clause sorts the data in a particular order.
A)True
B)False
Q7) The inner query in a nested query is called a(n) ____________________.
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/22075
Sample Questions
Q1) In small databases, there is a significant time difference between different query approaches.
A)True
B)False
Q2) There is only one approach to joining tables.
A)True
B)False
Q3) You can precede a subquery with the ____ operator to create a condition that is true if one or more rows are obtained when the subquery is executed.
A) IS NULL
B) IS TRUE
C) IS EXIST
D) EXISTS
Q4) To retrieve data from more than one table, you must ____________________ the tables together by finding rows in the two tables that have identical values in matching columns.
Q5) To relate two tables, in the FROM clause list all columns involved in the query. 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/22076
Sample Questions
Q1) You can use the existing value in a column and a calculation to update a value.
A)True
B)False
Q2) If the Autocommit mode is turned off, you can cancel updates at any time during your current work session.
A)True
B)False
Q3) If you decide that you do not want to save the changes you have made during your current work session, you can reverse the changes by executing the ____________________ command.
Q4) You can create a new table using data in an existing table.
A)True
B)False
Q5) In Oracle, use the ____ command to display the structure of a table.
A) SHOW TABLE
B) SHOW LAYOUT
C) DESCRIBE
D) DISPLAY LAYOUT
Q6) How can you use the COMMIT and ROLLBACK commands to support transactions?
Page 8
Q7) The ROLLBACK command reverses changes made to the ____________________ only.
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) The main mechanism for providing access to a database is the ____ command.
A) PERMIT
B) ACCESS
C) GRANT
D) REVOKE
Q2) You use the LEGAL clause of the ALTER TABLE command to ensure that only legal values satisfying a particular condition are allowed in a given column.
A)True
B)False
Q3) The correct command to allow user Thompson to delete rows in the CUSTOMER table would be: GRANT ____ ON CUSTOMER TO THOMPSON.
A) DROP
B) REMOVE
C) UPDATE
D) DELETE
Q4) The process of managing a database is called database ____________________.
Q5) To add a row to your view, simply add a row to each underlying derived table. 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) A(n) ____________________ is a procedure that is executed automatically in response to an associated database operation, such as an INSERT, UPDATE, or DELETE command.
Q2) In SQL Server, the cursor property ____________________ means that the cursor is used for retrieval purposes only.
Q3) A(n) ____ is a procedure that is executed automatically in response to an associated database operation.
A) cursor
B) trigger
C) waypoint
D) fetchpoint
Q4) A trigger is a pointer to a row in the collection of rows retrieved by an SQL command.
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
To view all questions and flashcards with answers, click on the resource link above. Page 10