Database | Information Systems (PLS 21, Lecture)

1. 1Database can be classified according to?
   

   1. ANumber of users.
   2. BDatabase location.
   3. CExpect of type and extent of use.
   4. DAll of the above.
2. 2Which one is not the advantage of a DBMS?
   

   1. ABetter data integration.
   2. BImprove data access.
   3. CImprove decision making.
   4. DMaximized data inconsistency.
3. 3What is the difference of the data and information?
   

   1. AData are raw facts.
   2. BInformation is the result of processing raw data to reveal meaning.
   3. CInformation requires context to reveal meaning.
   4. DA B C (All of the above.)
4. 4What is data?
   

   1. ARaw facts.
   2. BData is made up from information.
   3. CSomething that doesn't need to be formatted for storage and processing.
   4. DData is the same as information.
5. 5A relational database consists of a collection of:
   

   1. ATables
   2. BFields
   3. CRecords
   4. DKeys
6. 6What is data?
   

   1. ARaw facts
   2. BNeeds context
   3. CNot facts
   4. DLimited Context
7. 7What is the definition of End-user data?
   

   1. AData about data
   2. BRaw facts of interest to end user
   3. CData about computer programs
   4. DData about hard drives
8. 8What is data?
   

   1. ARaw facts such as telephone number, birthday and year-to- year.
   2. BA group of characters.
   3. CVersions of same data.
   4. DTransaction-oriented database systems.
9. 9What does XML stand for?
   

   1. AExtensible markup language
   2. BXray markup language
   3. CExtra markup language
   4. DExcess markup language
10. 10What is/are characteristic(s) of a spyware?
    

    1. ADoes not need to attach itself to another program
    2. BDestroys file
    3. CTrick the user into some action to activate the software on your computer
    4. DWatches the actions of the user and passes it to a server.

11. 11Which one is not an advantage of a database management system (DBMS)?
    

    1. AMaximized data inconsistency
    2. BImproved data access
    3. CBetter data integration
    4. DIncreased end-user productivity
12. 12Data is managed most efficiently when stored in a ...
    

    1. ADatabase
    2. BComputer
    3. CRAM
    4. DDrawer
13. 13Which of the following is not an example of an advantage of a DBMS?
    

    1. AImproved data sharing
    2. BImproved data access
    3. CImproved data security
    4. DImprove datum's appearance
14. 14Which one does NOT belong to the 4 rules in access?
    

    1. AWe need to double check the colour of header.
    2. BThe fields must have the same data type, but field names can be different.
    3. COne of the fields must be a primary key.
    4. DTables must be closed.
15. 15Databases can be classified according to which of the following?
    

    1. ANumber of users
    2. BDatabase location(s)
    3. CExpected type and extent of use
    4. DAll of above
16. 16What is data?
    

    1. ASource of information
    2. BBuilding blocks of information
    3. CGeneric information
    4. DPlain information
17. 17Which of the following are NOT advantages of a DBMS?
    

    1. AImproved data sharing and security
    2. BBetter data integration
    3. CMinimized data inconsistency
    4. DIncreased money in our lawmakers pockets
18. 18Which is an advantage and role of a Database Management System?
    

    1. ADBMS is the intermediary between user and database
    2. BDBMS enables data to be shared
    3. CDBMS integrates many users' view of the data
    4. DAll of the Above
19. 19Which of the following is not a required software in the database system environment?
    

    1. AOperating system software
    2. BDBMS software
    3. CHardware
    4. DApplication programs and utility software
20. 20What are some reasons for studying file systems?
    

    1. AComplexity of database design is easier to understand
    2. BUnderstanding file system problems helps to avoid problems with DBMS systems
    3. CKnowledge of file system is useful for converting file system to database system
    4. DAll of the above
21. 21What is data?
    

    1. AInformation
    2. BSomething that requires context to reveal meaning
    3. CRaw facts
    4. DThe result of processing raw data to reveal meaning.
22. 22Data must be processed in order to produce information.
    

    1. ATrue.
    2. BFalse.
    3. CIs this a trick question? Data and information are the same.
    4. DSometimes A, sometimes B.
23. 23All of the following describe the advantages of Database Management Systems except:
    

    1. AImproved data security
    2. BImproved data sharing
    3. CBetter data integration
    4. DDecrease in productivity
24. 24What are the 5 major parts of a database system?
    

    1. ASoftware, Procedures, Places, Data, Hardware
    2. BHardware, Software, People, Procedures, Data
    3. CData, Software, Procedures, Hardware, Planets
    4. DProtocol, Hardware, Software, Data, People
25. 25What is metadata?
    

    1. AMetabolism data
    2. BRaw data
    3. CData about data
    4. DMetamorphic data
26. 26What are the building blocks of information?
    

    1. AData
    2. BInformation
    3. CAtoms
    4. DNone of the above.
27. 27Which of these modern settings involve data management?
    

    1. ABusiness
    2. BResearch
    3. CAdministration
    4. DAll of the above.
28. 28What are databases classified by?
    

    1. ANumber of users
    2. BDatabase location(s)
    3. CExpected type and extent of use
    4. DAll of the above
29. 29Which is NOT a limitations of file system data management?
    

    1. ASystem administration is complex and difficult
    2. BRequires extensive programming
    3. CSecurity features are likely inadequate
    4. DAnalysts must review and update file systems frequently
30. 30What is a disadvantage of managing a database system?
    

    1. AManagement complexity
    2. BIncreased costs
    3. CMaintaining currency
    4. DAll of the above
31. 31Which of the following is NOT an advantage of DBMS?
    

    1. AImproved data sharing
    2. BImproved data access
    3. CBetter data integration
    4. DData redundancy
32. 32What does DBMS stand for?
    

    1. ADatabase managerial system
    2. BDatabase management system
    3. CDatabase multiple system
    4. DDatabase multicycle short
33. 33What is the role and advantage of DBMS?
    

    1. AIt is the intermediary between the user and the database
    2. BIt enables data to be shared
    3. CIt integrates many users' views of the data
    4. DAll of the above
34. 34What is not an advantage of database management systems?
    

    1. AImproved data sharing
    2. BImproved data security
    3. CImproved data access
    4. DQuicker data filtering
35. 35Data Management is understood to focus on the proper generation, storage and retrieval of data; therefore, all of the following are significant in this process EXCEPT:
    

    1. AGood decision making is imperative for proper organization
    2. BAccurate information contributes to proper management
    3. CInformation serves to reveal meaningful and proper data
    4. DInformation and data have no role in data management
36. 36What is database?
    

    1. AShared, integrated computer structure that stores a collection of end-user data and metadata
    2. BRaw facts of interest to end user
    3. CProvides description of data characteristics and relationships in data.
    4. DManages structure and controls access to data
37. 37Data management focuses on?
    

    1. AProper Generation of Data
    2. BProper Storage of Data
    3. CProper Retrieval of Data
    4. DAll are correct
38. 38What is End-user data?
    

    1. ARaw facts of interest to end user
    2. BData about data
    3. CBoth A & B
    4. DNone of the above
39. 39Databases can be classified according to?
    

    1. ANumber of users
    2. BDatabase location(s)
    3. CExpected type and extent of use
    4. DAll The Above
40. 40Which is not a limitation of file system data management?
    

    1. ARequires extensive programming
    2. BCan perform ad hoc queries
    3. CSecurity features aren’t adequate
    4. DDifficult to make changes to existing structures
41. 41What is needed to make a good decision?
    

    1. AGood information
    2. BEfficient database
    3. CUnderstand file systems
    4. DNone of the above
42. 42A collection of data related to a specific topic:
    

    1. ATable
    2. BForm
    3. CQuery
    4. DBigdata
43. 43What is one advantage of DBMS?
    

    1. AImprove data sharing
    2. BImprove organization
    3. CIncrease more customers
44. 44Which of the following is not a setting databases are used?
    

    1. ABusiness
    2. BResearch
    3. CAdministration
    4. DFor Facebook use
45. 45Which of the following is consider a hardware?
    

    1. AExcel
    2. BWindows7
    3. CScreen
    4. DMicrosoft Word
46. 46Which of the following are problems with Non-ERP Systems?
    

    1. ALong-term maintenance costs high?
    2. BLimits ability to engage in process reengineering
    3. CStrategic decision-making not supported
    4. DAll of them above
47. 47What are some risks Associated with ERP Implementation?
    

    1. AChoosing the Wrong ERP
    2. BChoosing the Wrong Consultant
    3. CHigh Cost and Cost Overruns
    4. DAll of the above
48. 48What are some ERP products?
    

    1. AOracle
    2. BPeopleSoft
    3. CBaan
    4. DAll of the above.
49. 49Which of the following is NOT the essential stage of data warehousing process?
    

    1. AModeling data for the data warehouse
    2. BCleansing extracted data
    3. CTransforming data out of the warehouse model
    4. DLoading the data into the data warehouse database
50. 50Which of the following is the problem with NON-ERP Systems?
    

    1. ALong-term maintenance costs high
    2. BLimits ability to engage in process reengineering
    3. CStrategic decision-making not supported
    4. DAll of the above
51. 51What does the acronym ERP stand for?
    

    1. AEntrepreneurship Reasoning Plan
    2. BEnterprise Resource Planning
    3. CEntertainment Resource Planning
    4. DExcellent Ramen Place
52. 52Where are some areas with high costs regarding Enterprise Resource Planning Systems?
    

    1. ATraining
    2. BTesting and Integration
    3. CDatabase Conversion
    4. DAll of the above
53. 53Which of the following is not an essential stage of data warehousing process?
    

    1. AModeling data for the data warehouse
    2. BCleansing extracted data
    3. CLoading the data into the data warehouse database
    4. DPut the data on a external hard drive
54. 54What links vendors, carriers, third-party logistics companies, and information systems providers?
    

    1. AIBM
    2. BRAM
    3. CSCM
    4. DROM
55. 55What is CRM?
    

    1. AAn integrated approach to identifying, acquiring and maintaining customers.
    2. BThose activities supported by multi-module application software that help a company manage the important parts of its business in an integrated fashion.
    3. CSupports management-critical tasks through analytical investigation of complex data associations captured in data warehouses.
    4. DA database constructed for quick searching, retrieval, ad-hoc queries, and ease of use.
56. 56What is ERP？
    

    1. AEnterprise Resource Planning
    2. BEconomic Resource Planning
    3. CEnvironment Resources Planning
    4. DEducation Resources Planning
57. 57What is CRM?
    

    1. AAn integrated approach to identifying, acquiring and maintaining customers.
    2. BAllows companies to coordinate their approach across channels, departments and also geographically.
    3. CBoth answers above are correct.
    4. DNone of answer is correct.
58. 58What to look for in CRM software:
    

    1. ABe able to integrate smoothly and flawlessly
    2. BMake sure the primary goal is standard in software
    3. CMake sure the program doesn't offer more than you need
    4. DAll of the above
59. 59Which of the followings are the essential stages of the data warehousing process:

    1. AModeling data for the data warehouse
    2. BExtracting data from operational databases
    3. CCleansing extracted data
    4. DAll of above
60. 60Reasons ERP systems are powerful tools?
    

    1. AIs a logical solution to incompatible applications.
    2. BAddresses global information sharing and reporting.
    3. CAvoids the pain and expense of fixing legacy systems.
    4. DAll of above.
61. 61What does CRM stand for?
    

    1. AComputer Resource Management
    2. BCustomer Relationship Management
    3. CConsumer Relation Motives
    4. DConsumer Relationship Management
62. 62Which Tier is the application layer on?
    

    1. ATier 1
    2. BTier 2
    3. CTier 3
    4. DTier 4
63. 63What does ERP stand for?
    

    1. AEstimate resource planning
    2. BEnterprise research planning
    3. CEnterprise resource planning
    4. DEnterprise shipping planning
64. 64Which of the following is NOT a product of ERP?
    

    1. AOracle
    2. BPeopleSoft
    3. CBaan
    4. DD.J. Edwards
65. 65What is CRM?
    

    1. AAn integrated approach to identifying, acquiring and maintaining customers.
    2. BAllows companies to coordinate their approach across channels, departments and also geographically.
    3. CAn integrated approach to match consumers with workers that can help them sell their products.
    4. DA and B
66. 66What are the problems with Non-ERP systems?
    

    1. AStrategic decision-making not supported.
    2. BLong-term maintenance costs high.
    3. CLimits ability to engage in process reengineering.
    4. DAll of the above.
67. 67Which key features does ERP include?
    

    1. ASmooth and seamless flow of information across organizational boundaries
    2. BStandardized environment with shared database independent of applications and integrated applications.
    3. CNone of the above
    4. DBoth A and B
68. 68CRM leads to all of the following benefits except:
    

    1. AHelps make call centers more efficient.
    2. BHelps sales staff close deals faster.
    3. CIncreases employees salaries.
    4. DSimplifies marketing and sales processes.
69. 69Which one is not the essential stages of the data warehousing process?
    

    1. AModeling data for the data warehouse
    2. BExtracting data from operational databases
    3. CCleaning extracted data
    4. DDeleting the data you have
70. 70What is one of the ERP Applications?
    

    1. ACore Applications
    2. BExamine Applications
    3. CRandom Applications
    4. DPlug Applications
71. 71What is CRM?
    

    1. AA technology that allows companies to track consumer demands
    2. BA process that companies use to assess customer relations
    3. CA mindset of providing high-quality customer experiences
    4. DA way of attracting customers to your product
72. 72Which is TRUE about a Data Warehouse?
    

    1. AAn ERP system could exist without having a data warehouse.
    2. BA database constructed for quick searching, retrieval, ad-hoc queries, and ease of use
    3. CA relational or multi-dimensional database that may consume hundreds of gigabytes or even terabytes of disk storage
    4. DAll of the Above
73. 73Which one is the full name of IT?
    

    1. AInformal technology
    2. BInteresting technology
    3. CInformation Technology
    4. DIndividual Technology
74. 74What is benefit of CRM?
    

    1. AResearch has shown that companies that create satisfied, loyal customers have more repeat business, lower customer-acquisition costs and stronger brand value.
    2. BWhich equals better financial performance
    3. CAll of above
    4. DNone of above

Description

PLS 21 Quiz on Database | Information Systems (PLS 21, Lecture), created by Crystani C'Mickey Freeman on 25/05/2018.

Author

Crystani C'Mickey Freeman

Language

English

Views

21

Tags

pls 21

Rating

No ratings yet

Rate this quiz

Rate this quiz

More on Data Management and Databases