Uark ISYS 2103 Final Exam 3
Questions and All Correct Answers
2025-2026 Edition.
Customer Relationship Management (CRM) - Answer a technology for managing all your
companies’ relationships and interactions with customers and potential customers
GOAL: Improve Business Relations - Answer goal of CRM
Marketing/ Sales (CRM) - Answer -have to know customers
-make the connection
-earn customer trust
Benefit for customers (CRM) - Answer 1. Organizations: allows efficiency by automating
elements of business
2. Optimization: simplify/ streamline customer interaction
3. Learn: Learn about purchasing a product
Customer Relationships Widen, Lengthen, and Deepen
Supply Chain and CRM - Answer -Track data to see customers product preference
-the collection of data to get products where they need to go
SCM/ CRM integration - Answer -Provides a system to execute supply chain transactions,
manage supply chain relationships, and monitor related processes
Accounting (CRM) - Answer -Creates long term relationships, and documents it
-Introduction of Converged CRM
Finance (CRM) - Answer -used for CUSTOMER COLLECTIONS and Outstanding invoices
-BANKING
, Why CRM is important - Answer -Computers work all the time
- make customers feel unique
-Improved information
Advantages of Databases - Answer -Minimal data redundancy
-Improved data consistency
-Increase Security
-Improved Data quality
-Improved data accessibility and sharing
Advantages of Databases - Answer -Enforcement of Standards
-Program-data Independence
-Increased Productivity of application development
-Reduced program maintenance
Intro to SQL - Answer -Relational database mgmt system (RDBMS)
a. Create, update, administer data
-Introduction to Structured query language (SQL)
Data Definition Language (DDL) - Answer Commands that define a database, including
creating, altering, and dropping tables and establishing constraints
Data Manipulation Language (DML) - Answer Commands that maintain and query a database
Writing SQL Statements - Answer -NOT case sensitive
-one or more lines
-keywords can not be split across lines
-Each Sql statement (Not line) end with semicolon
Anatomy of a SQL statement- Select - Answer -list the columns (or expressions) that should be
returned from the query
-What comes back in the Results?
Questions and All Correct Answers
2025-2026 Edition.
Customer Relationship Management (CRM) - Answer a technology for managing all your
companies’ relationships and interactions with customers and potential customers
GOAL: Improve Business Relations - Answer goal of CRM
Marketing/ Sales (CRM) - Answer -have to know customers
-make the connection
-earn customer trust
Benefit for customers (CRM) - Answer 1. Organizations: allows efficiency by automating
elements of business
2. Optimization: simplify/ streamline customer interaction
3. Learn: Learn about purchasing a product
Customer Relationships Widen, Lengthen, and Deepen
Supply Chain and CRM - Answer -Track data to see customers product preference
-the collection of data to get products where they need to go
SCM/ CRM integration - Answer -Provides a system to execute supply chain transactions,
manage supply chain relationships, and monitor related processes
Accounting (CRM) - Answer -Creates long term relationships, and documents it
-Introduction of Converged CRM
Finance (CRM) - Answer -used for CUSTOMER COLLECTIONS and Outstanding invoices
-BANKING
, Why CRM is important - Answer -Computers work all the time
- make customers feel unique
-Improved information
Advantages of Databases - Answer -Minimal data redundancy
-Improved data consistency
-Increase Security
-Improved Data quality
-Improved data accessibility and sharing
Advantages of Databases - Answer -Enforcement of Standards
-Program-data Independence
-Increased Productivity of application development
-Reduced program maintenance
Intro to SQL - Answer -Relational database mgmt system (RDBMS)
a. Create, update, administer data
-Introduction to Structured query language (SQL)
Data Definition Language (DDL) - Answer Commands that define a database, including
creating, altering, and dropping tables and establishing constraints
Data Manipulation Language (DML) - Answer Commands that maintain and query a database
Writing SQL Statements - Answer -NOT case sensitive
-one or more lines
-keywords can not be split across lines
-Each Sql statement (Not line) end with semicolon
Anatomy of a SQL statement- Select - Answer -list the columns (or expressions) that should be
returned from the query
-What comes back in the Results?
