Information Systems Question
Bank
Course Introduction
Information Systems explores the use of technology in managing and processing information within organizations. The course covers the fundamentals of computer hardware and software, database management, networking, cybersecurity, and the strategic role of information systems in business operations and decision-making. Students will learn how information systems support organizational goals, drive innovation, and contribute to competitive advantage. The course also introduces ethical, social, and legal issues related to information technology, and emphasizes analytical and problem-solving skills through real-world case studies and practical projects.
Recommended Textbook
Concepts of Database Management 8th Edition by Philip J. Pratt
Available Study Resources on Quizplus
9 Chapters
525 Verified Questions
525 Flashcards
Source URL: https://quizplus.com/study-set/1756
Page 2
Chapter 1: Introduction to Database Management
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/34985
Sample Questions
Q1) A good _________________________ has many features that allow users to gain access to data in a database without having to do any programming.
Answer: DBMS
database management system database management system (DBMS) DBMS (database management system)
Q2) Which of the following statements is correct?
A) In a nondatabase, file-oriented environment, data is often partitioned into several disjointed systems with each system having its own collection of files.
B) User data cannot be combined and shared among authorized users.
C) Database users should not have access to the same information.
D) The elimination of redundancy is always possible.
Answer: A
Q3) Unlike a typical data file,a database can store information about multiple ____.
A) attributes
B) bytes
C) entities
D) characters
Answer: C
To view all questions and flashcards with answers, click on the resource link above.
Page 3
Chapter 2: The Relational : Introduction, QBE, and Relational Algebra
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/34986
Sample Questions
Q1) If you are sorting records by more than one field,the more important field is called the ____.
A) primary sort key
B) secondary sort key
C) maximum sort key
D) minor sort key
Answer: A
Q2) A(n)____________________ database is a collection of tables.
Answer: relational
Q3) To list the records in a query's results in a particular order,you need to ____________________ the records.
Answer: sort
Q4) A query that changes data is a(n)____ query.
A) addition
B) update
C) update
D) select
Answer: C
Page 4
Q5) ____________________ is a theoretical way of manipulating a relational database.
Answer: Relational algebra
To view all questions and flashcards with answers, click on the resource link above.
Page 5
Chapter 3: The Relational : SQL
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/34987
Sample Questions
Q1) Based on the code above,for each sales rep,list the rep number,the number of customers assigned to the rep,and the average balance of the rep's customers.Group the records by rep number and order the records by rep number.
A) SELECT RepNum, AVG(Balance) FROM Customer GROUP BY RepNum ORDER BY RepNum ;
B) SELECT RepNum, COUNT(*), AVG(Balance) FROM Part GROUP BY RepNum ORDER BY RepNum ;
C) SELECT RepNum, COUNT(*), AVG(Balance) FROM Customer GROUP BY RepNum ORDER BY RepNum ;
D) SELECT RepNum, COUNT(*) FROM Customer GROUP BY RepNum ORDER BY RepNum ; Answer: C
Q2) Preceding a condition by the NOT operator reverses the truth or falsity of the original condition.
A)True
B)False
Answer: True
Q3) You use the SQL ____________________ command to create a table by describing its layout.
Answer: CREATE TABLE
To view all questions and flashcards with answers, click on the resource link above.
Page 6
Chapter 4: The Relational : Advanced Topics
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/34988
Sample Questions
Q1) Referential integrity is specified using the FOREIGN KEY clause in the SELECT command.
A)True
B)False
Q2) An individual can use a view to create reports,charts,and other objects that show database data.
A)True B)False
Q3) In Access,a(n)____________________ enables you to add logic to table events such as adding,changing,or deleting data
Q4) A view is a physical table in the DBMS.
A)True
B)False
Q5) The type of field for which you should never allow nulls is the ____________________.
Q6) In Access,you can restrict the legal values accepted by a field by entering an appropriate ____________________ that data entered in the field must follow.
Q7) Explain what is meant by a null value.Is a null value the same as a value of zero?
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 5: Database Design 1: Normalization
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/34989
Sample Questions
Q1) A table is in first normal form if it does not contain ____.
A) repeating groups
B) a foreign key
C) a primary key
D) alternate keys
Q2) By splitting relations to achieve third normal form tables,you create the need to express interrelation constraints.
A)True
B)False
Q3) To convert a table to fourth normal form,split the third normal form table into separate tables,each containing the column that ____ the others.
A) determines
B) multidetermines
C) defines
D) identifies
Q4) A column is a nonkey column if it is not a part of the ____________________.
Q5) What is the difference between a table in first normal form and one in second normal form?
Q6) Describe the procedure for converting a table to the third normal form.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 6: Database Design 2: Design Method
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/34990
Sample Questions
Q1) A relationship that is not necessary for identification is called a(n)____________________ relationship.
Q2) If each employee works in a single department and each department has only one employee,the relationship between employees and departments is ____.
A) one-to-one
B) one-to-many
C) many-to-one
D) many-to-many
Q3) When provided with a user view or some sort of stated requirement,you must develop a collection of tables that will support it.
A)True
B)False
Q4) One way to indicate a one-to-many relationship is to place a crow's foot at the ____________________ end of the relationship.
Q5) In DBDL,you represent a table by listing all columns and then underlining the primary key.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 7: Dbms Functions
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/34991
Sample Questions
Q1) Explain the difference between a procedural language and a nonprocedural language.Give at least one example of each type of language.
Q2) Explain how a database is updated using batch processing.
Q3) The more important it is to avoid redoing work,the more often you should make backups.
A)True
B)False
Q4) A backward recovery is also called a(n)____________________.
Q5) Discuss the advantages and disadvantages of timestamping.
Q6) Smart cards have built-in circuits containing processing logic to identify the cardholder.
A)True
B)False
Q7) In some database systems,such as Microsoft Access,users can access and update metadata about fields,tables,relationships,and indexes.
A)True
B)False
Q8) ____________________ is the prevention of unauthorized access,either intentional or accidental.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 8: Database Administration
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/34992
Sample Questions
Q1) Which of the following DBMS evaluation categories does the following question relate to: What types of files can you import or export?
A) Cost
B) Future plans
C) Portability
D) Performance
Q2) Which of the following DBMS evaluation categories does the following question relate to: Is it a simple catalog or can it contain more content,such as information about programs and the various data items these programs access?
A) Backup and recovery
B) Data dictionary
C) Security
D) Integrity
Q3) A configuration of several computers connected together that allow users to share a variety of hardware and software resources is known as a(n)_________________________.
Q4) The DBA creates security policies and procedures.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 9: Database Management Approaches
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/34993
Sample Questions
Q1) With respect to UML,the type of diagram most relevant to database design is the ____________________.
Q2) A(n)____________________ DDBMS is a database that has the same local DBMS at each site.
Q3) The site that initiates the update in a two-phase commit is known as the ____.
A) director
B) initiator
C) coordinator
D) leader
Q4) Computers in a network communicate through ____.
A) tokens
B) messages
C) notes
D) letters
Q5) In a DDBMS,the site where the user is located is called the remote site.
A)True
B)False
Q6) With ____________________ visibility,any other class can view or update the value of an attribute.
Q7) Explain the difference between a Web page,a Web server,and a Web client.
To view all questions and flashcards with answers, click on the resource link above. Page 12