Inmt 342 final exam - Study guides, Class notes & Summaries

INMT 342 Final Exam with correct Answers

INMT 342 Final Exam Questions and Answers What is middleware and what purpose does it serve - CORRECT ANSWER-Middleware expands on the abilities of an operating system. Middleware connects User interfaces with back end data How do you set up ODBC connections - CORRECT ANSWER-to create: click on windows icon, click Windows Administrator Tools, ODBS 64Bit, System DSN tab, Add, Choose relevant back end system, Name your new ODBC, put in your authorization to link: On DBMS system, click...

INMT 342 Final Exam Questions and Answers What are relational database strengths? - Answer-consistency, persistance, concurrency, standardization, application integration what are relational database shortcomings? - Answer-impedance mismatch, scalability (horizontal vs vertical), clusters, cost what is big data? - Answer-the data situation where volume, velocity, variety, and variability of data exceed typical storage or computing capacity for accurate and timely decision making wha...

subjects = data entities, objects = descriptions Conceptual Modeling Subjects = ? Objects = ? Unique identifiers Conceptual Modeling unique characteristics that distinguish between objects/subjects of the same type attributes (describe each subject), alternate keys (describe each object) Conceptual Modeling ______________ describe each subject and _____________ describes each object relationships and cardinalities Conceptual Modeling events that occur that imply associations between objec...

What are relational database strengths? consistency, persistance, concurrency, standardization, application integration what are relational database shortcomings? impedance mismatch, scalability (horizontal vs vertical), clusters, cost what is big data? the data situation where volume, velocity, variety, and variability of data exceed typical storage or computing capacity for accurate and timely decision making what is volume? amount. "giga, tera, exa" what is velocity? speed at which new ...

Final Actual Exam for INMT 342 Questions and Answers - CORRECT ANSWER-Data that describe the properties of other data are: a. Logical Data b. Physical Data c. Metadata d. Conceptual Data - CORRECT ANSWER-Which of the following is NOT an advantage of database systems? a. improved data sharing b. program-data dependence c. better data quality d. reduced program maintenance - CORRECT ANSWER-The detailed technology-dependent specifications of the database design are created in the: ...

INMT 342 Exam 2 Concepts Final Questions and Answers Latest Updated leverage - CORRECT ANSWERNormalization - CORRECT ANSWER-The process of grouping attributes together - Validates and improves logical design to satisfy constraints Creating Well structured tables - CORRECT ANSWER-- Contain minimal redundancy - Allows users to insert, modify, and delete the rows in the table without errors or inconsistencies Well- structed tables avoid - CORRECT ANSWER-Insert Update Deletion

INMT 342 Final Exam Question with 100% Accuracy

INMT 342 FINAL EXAM QUESTIONS WITH ALL CORRECT ANSWERS – UPDATED!!! what is key value storage? - Answer-store data and an index to find them based on a key, simplest NoSQL database, large, huge lookup table spread across many servers what is column family storage? - Answer-store data as columns of data rather than as rows of data, row and column oriented view: each row gives a complete view of one entity, column view indexes particular aspects across the whole dataset, vary and may not ex...

INMT 342 FINAL EXAMINATION QUESTIONS WITH ALL CORRECT ANSWERS What is the problem & solution for data integrity & transactions - Answer-Problem: Many users accessing data at once can interfere with each other Solution: Concurrency Controls-managing users interfering What are the 4 issues due to concurrency - Answer-Lost Updates: Two or more transactions attempt to update a record at same time, last update overwrites prior update Dirty reads: Transaction reads a record that has been ch...