Database Management Systems
Practice Questions
Course Introduction
Database Management Systems (DBMS) is a comprehensive course that introduces students to the fundamental concepts, design, implementation, and management of database systems. The course covers data models, with a primary focus on the relational model, as well as database architecture, normalization, and query languages such as SQL. Students will learn about database design principles, transaction management, concurrency control, data security, and recovery techniques. Through theoretical lessons and hands-on labs, the course equips students with the skills necessary to design efficient databases, manipulate data, ensure data integrity, and understand the role of modern database systems in supporting business operations and decision-making processes.
Recommended Textbook
Systems Analysis and Design 10th Edition by
Harry J. Rosenblatt
Available Study Resources on Quizplus
16 Chapters
1522 Verified Questions
1522 Flashcards
Source URL: https://quizplus.com/study-set/1798
Page 2
Chapter 1: Introduction to Systems Analysis and Design
Available Study Resources on Quizplus for this Chatper
112 Verified Questions
112 Flashcards
Source URL: https://quizplus.com/quiz/35757
Sample Questions
Q1) In an information system, data is information that has been transformed into output that is valuable to users.
A)True
B)False
Answer: False
Q2) An IT department team includes _________________________ who plan, develop, and maintain information systems.
Answer: systems analysts
Q3) In many large companies, these kinds of systems provide cost-effective support for users and managers throughout the company.
Answer: E
Q4) In the systems planning phase, a key part of the preliminary investigation is a feasibility study that reviews anticipated costs and benefits and recommends a course of action based on operational, technical, economic, and time factors.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above.
3
Chapter 2: Analyzing the Business Case
Available Study Resources on Quizplus for this Chatper
112 Verified Questions
112 Flashcards
Source URL: https://quizplus.com/quiz/35758
Sample Questions
Q1) Feasibility analysis is an ongoing task that must be performed throughout the systems development process.
A)True
B)False
Answer: True
Q2) A survey is ____, generally takes less time, and can involve a broad cross-section of people.
A)more flexible than a series of interviews, and it is less expensive
B)more flexible than a series of interviews, but it is more expensive
C)not as flexible as a series of interviews, but it is less expensive
D)not as flexible as a series of interviews, and it is more expensive
Answer: C
Q3) Projects where management has no choice in implementing them are called ____ projects.
A)discretionary
B)nondiscretionary
C)appended
D)concatenated
Answer: B
To view all questions and flashcards with answers, click on the resource link above.
Page 4
Chapter 3: Managing Systems Projects
Available Study Resources on Quizplus for this Chatper
112 Verified Questions
112 Flashcards
Source URL: https://quizplus.com/quiz/35759
Sample Questions
Q1) A risk ____ plan is a proactive effort to anticipate a risk and describe an action plan to deal with it.
A)identification
B)management
C)response
D)balancing
Answer: C
Q2) Project status meetings give project managers an opportunity to seek input and conduct brainstorming sessions.
A)True
B)False
Answer: True
Q3) In GanttProject, unlike in Microsoft Project, you create tasks and durations, indicate dependencies, and assign resources.
A)True
B)False
Answer: False
Q4) A project is based on a pattern of ____________________. Answer: tasks
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Requirements Modeling
Available Study Resources on Quizplus for this Chatper
112 Verified Questions
112 Flashcards
Source URL: https://quizplus.com/quiz/35760
Sample Questions
Q1) The main objective of a sample is to ensure that it represents the overall population accurately.
A)True
B)False
Q2) When preparing a representative sample from a list of 200 customers who complained about errors in their statements, a ____ could ensure the sample is balanced geographically by selecting five customers from each of four zip codes.
A)systematic sample
B)stratified sample
C)random sample
D)comprehensive sample
Q3) In a sequence diagram, vertical arrows represent messages from one object to another. _________________________
A)True
B)False
Q4) If one of these is available, analysts can use it to develop models and enter documentation from the JAD session.
Q5) JAD, RAD, and agile methods all have advantages and disadvantages. What are they?
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Data and Process Modeling
Available Study Resources on Quizplus for this Chatper
112 Verified Questions
112 Flashcards
Source URL: https://quizplus.com/quiz/35761
Sample Questions
Q1) A black hole is a process that has ____.
A)no input
B)at least one output and one input, but the output obviously is insufficient to generate the input shown
C)no output
D)at least one input and one output, but the input obviously is insufficient to generate the output shown
Q2) A(n) ____________________ is a data flow in which the same data travels to two or more different locations.
Q3) Systems analysts call an entity that supplies data to the system a sink.
A)True
B)False
Q4) In DFDs, a process resembles a(n) ____________________, where the inputs, outputs, and general functions of the process are known, but the underlying details are not shown.
Q5) Shows how a system transforms input data into useful information.
Q6) Model that shows what the system must do, regardless of how it will be implemented.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Object Modeling
Available Study Resources on Quizplus for this Chatper
112 Verified Questions
112 Flashcards
Source URL: https://quizplus.com/quiz/35762
Sample Questions
Q1) An object belongs to a group or category called a(n) ____.
A)catalog
B)roster
C)index
D)class
Q2) As shown in the accompanying figure, objects within a class can be grouped into ____, which are more specific categories within a class.
A)schedules
B)units
C)subclasses
D)clusters
Q3) A class can belong to a more general category called a(n) subclass.
A)True
B)False
Q4) A class diagram resembles a horizontal flowchart that shows the actions and events as they occur.
A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Development Strategies
Available Study Resources on Quizplus for this Chatper
112 Verified Questions
112 Flashcards
Source URL: https://quizplus.com/quiz/35763
Sample Questions
Q1) Outsourcing can refer to ____.
A)relatively minor programming tasks
B)the rental of software from a service provider
C)the handling of a company's entire IT function
D)BPO
Q2) Some firms offer ____, which provide powerful Web-based support for transactions such as order processing, billing, and customer relationship management.
A)ASP
B)IBS
C)fixed usage
D)fixed-fee transfer
Q3) The ____________________ contains the requirements for a new system, describes the alternatives that were considered, and makes a specific recommendation to management.
Q4) If a purchased package will be used without modification, you can begin planning the systems implementation phase upon its purchase.
A)True
B)False
Q5) The outsourcing of a basic business function.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: User Interface Design
Available Study Resources on Quizplus for this Chatper
112 Verified Questions
112 Flashcards
Source URL: https://quizplus.com/quiz/35764
Sample Questions
Q1) On a form, such as that shown in the accompanying figure, the ____________________ is the zone that usually contains the company name or logo and the title and number of the form.
Q2) Because source documents should be stored in a safe location for some specified period of time, a company should have a(n) ____________________ that meets all legal requirements and business needs.
Q3) Although online data entry is used in specific situations, most business activity requires batch input.
A)True
B)False
Q4) A system is maintainable if it is ____.
A)flexible
B)distributed
C)scalable
D)easily modified
Q5) ____________________ policies and procedures protect data from loss or damage, which is a vital goal in every organization.
Q6) Can include grand totals for numeric fields and other end-of-report information.
Q7) Generally paper-based but can be provided online.
Page 10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Data Design
Available Study Resources on Quizplus for this Chatper
112 Verified Questions
112 Flashcards
Source URL: https://quizplus.com/quiz/35765
Sample Questions
Q1) An integer format uses ____ bits to represent the number 12,345 in binary form.
A)8
B)12
C)16
D)20
Q2) Three main types of relationships that can exist between entities are a one-to-one relationship, abbreviated 1:1; a one-to-many relationship, abbreviated 1:M; and a many-to-many relationship, abbreviated M:N.
A)True
B)False
Q3) JDBC is the language of the Web. _________________________
A)True
B)False
Q4) Microsoft Excel uses ____________________ dates in calculations.
Q5) The ____________________ for DBMS design, which was introduced in the 1970s and continues to be the dominant approach for organizing, storing, and managing business data.
Q6) A primary key cannot be composed of more than one field.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: System Architecture
Available Study Resources on Quizplus for this Chatper
111 Verified Questions
111 Flashcards
Source URL: https://quizplus.com/quiz/35766
Sample Questions
Q1) Standard that uses MIMO technology to boost performance.
Q2) Securing approvals from users throughout the design phase ensures that a systems analyst does not have the major task of obtaining approvals at the end, keeps users involved with the system's development, and gives feedback about whether or not the analyst is on target.
A)True
B)False
Q3) A specific physical topology can support at most one logical topology.
A)True
B)False
Q4) Which of the following is not one of the main functions that every business information system must carry out?
A)Managing applications that perform the processing logic
B)Handling data storage and access
C)Providing an interface that allows users to interact with the system
D)Using a mainframe to deliver a multiuser environment
Q5) Process that automatically allows a wireless client to associate with a stronger access point.
Q6) List at least five guidelines for developing an e-commerce site in-house.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Q7) Broadband wireless communications protocols for metropolitan area networks.
Chapter 11: Managing Systems Implementation
Available Study Resources on Quizplus for this Chatper
112 Verified Questions
112 Flashcards
Source URL: https://quizplus.com/quiz/35767
Sample Questions
Q1) A testing sequence should move to the integration stage as soon as it has performed properly in any unit tests.
A)True
B)False
Q2) User documentation includes ____.
A)security and audit trail information
B)program, systems analyst, programmer, and system identification
C)frequently asked questions (FAQs)
D)description of source document content, preparation, processing, and samples
Q3) Because this is not language-specific, it can be used to describe a software module in plain English without requiring strict syntax rules.
Q4) The skill set required to develop documentation usually is the same as that to develop a system.
A)True
B)False
Q5) When training is complete, many organizations conduct a full-scale test, or ____________________, which is a dress rehearsal for users and IT support staff.
Q6) In a structure chart, typically this kind of module directs lower-level modules.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Managing Systems Support and Security
Available Study Resources on Quizplus for this Chatper
112 Verified Questions
112 Flashcards
Source URL: https://quizplus.com/quiz/35768
Sample Questions
Q1) Corrective maintenance ____.
A)adds enhancements to an operational system and makes the system easier to use
B)diagnoses and corrects errors in an operational system
C)involves changing an operational system to make it more efficient, reliable, or maintainable
D)requires analysis of areas where trouble is likely to occur in order to avoid problems
Q2) Risk ____ measures risk likelihood and impact.
A)assessment
B)management
C)identification
D)control
Q3) Triangle that shows the three main elements of system security.
Q4) Perfective maintenance usually is cost effective ____ the system's operational life. A)early in
B)during the middle of C)late in
D)throughout
Q5) Protects the system and keeps it safe, free from danger, and reliable.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Communication Tools
Available Study Resources on Quizplus for this Chatper
45 Verified Questions
45 Flashcards
Source URL: https://quizplus.com/quiz/35769
Sample Questions
Q1) A presentation should be planned in three stages: the introduction, the information, and the summary.
A)True
B)False
Q2) To avoid getting fired, be absolutely sure your message content is appropriate and in no way violates your company's ____________________ policy.
Q3) Knowing WHAT is expected and when to go into detail is directly related to knowing ____.
A)WHO your targets are
B)WHEN to speak and when to remain silent
C)HOW to communicate effectively
D)WHERE to communicate best
Q4) When you have a large number of supporting documents such as questionnaires or sampling results, you should put those items in an appendix located at the end of the document.
A)True
B)False
Q5) Many word processing programs include a tool that can generate a(n) ____________________ automatically.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 14: Case Tools
Available Study Resources on Quizplus for this Chatper
44 Verified Questions
44 Flashcards
Source URL: https://quizplus.com/quiz/35770
Sample Questions
Q1) A(n) ____________________ is an interactive tool that helps in designing a custom interface, creating screen forms, and handling data entry format and procedures.
Q2) A(n) ____________________ organizes and documents system development tasks.
Q3) Traditional code was written in ____ languages such as COBOL, which required a programmer to create code statements for each processing step.
A)event-driven
B)procedural
C)fourth-generation
D)non-procedural
Q4) The CASE tool marketplace includes only a few vendors and products, and one tool dominates the marketplace.
A)True
B)False
Q5) Unattractive features of an O-O approach include all-inclusive design and single-use code, which increases costs and slows down development.
A)True
B)False
Q6) A(n) ____________________ is a tool for designing formatted reports rapidly.
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 15: Financial Analysis Tools
Available Study Resources on Quizplus for this Chatper
45 Verified Questions
45 Flashcards
Source URL: https://quizplus.com/quiz/35771
Sample Questions
Q1) When IT department costs are not charged to other departments, the information systems department is called a(n) ____________________, because it generates accounting charges with no offsetting credits for IT services.
Q2) The concept that a future monetary value is related to a specific value invested today is known as the time value of money, and it is the basis of a technique called ____________________.
Q3) In present value analysis, most companies require a rate of return that is higher than the discount rate because of the degree of risk in any project compared with investing in a bond.
A)True B)False
Q4) ____________________ is the process of determining how long it takes an information system to pay for itself.
Q5) The ____________________ of a project is the total present value of the benefits minus the total present value of the costs.
Q6) Intangible costs are costs for which a specific dollar value can be assigned.
A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 16: Internet Resource Tools
Available Study Resources on Quizplus for this Chatper
45 Verified Questions
45 Flashcards
Source URL: https://quizplus.com/quiz/35772
Sample Questions
Q1) Endnote uses a special information transfer method that prevents a user from connecting directly to any government or university databases.
A)True
B)False
Q2) One online communication resource is called a Web-based discussion group, which is an online community that combines features of ____.
A)chat rooms and channels
B)instant messages and newsletters
C)mailing lists and forums
D)search engines and subject directories
Q3) A(n) ____________________ is a software program that allows users to access and display Web pages delivered by a Web server.
Q4) ____ allows systems analysts to connect to an extended family of personal and professional contacts, with unlimited opportunities.
A)Social networking
B)A forum
C)RSS
D)A webinar
To view all questions and flashcards with answers, click on the resource link above. Page 18