Scholar Examination 1/16/12 9:14 AM Week three : Managing Property and Sources within the Digital Agency – Homework Save Solutions Submit for Grading 1. A attribute or high quality describing an entity is named a(n) (Factors : 1) area. tuple. key area. attribute.
2. The confusion created by _____ makes it tough for corporations to create buyer relationship administration, provide chain administration, or enterprise methods that combine information from completely different sources. (Factors : 1) batch processing information redundancy information independence on-line processing
three. Duplicate information in a number of information recordsdata is named (Factors : 1) information redundancy. ata multiplication. information independence. information backups.
four. A DBMS (Factors : 1) makes the bodily database out there for various logical views. makes the logical database out there for various analytical views. makes the bodily database out there for various analytical views. makes the relational database out there for various analytical views.
5. The logical view (Factors : 1) reveals how information are organized and structured on the storage media. presents an entry display to the consumer. permits the creation of supplementary reviews. presents information as they’d be perceived by finish customers.
6.The kind of logical database mannequin that treats information as in the event that they had been saved in two-dimensional tables is the (Factors : 1) OODBMS. pre-digital DBMS. relational DBMS. hierarchical DBMS.
7. A area recognized in a desk as holding the distinctive identifier of the desk’s data is named the (Factors : 1) main key. key area. http://takeexam. subsequent. ecollege. com/(NEXT(f83986aacf))/Major/CourseM…703=rDEJX%252foi1wqaW6CBxURnSNa8tZLcim9DauNr3z3CFpI%253d& Web page 1 of three Scholar Examination 1/16/12 9:14 AM main area. distinctive ID.
eight. The info dictionary serves as an necessary information administration device by (Factors : 1) ssigning attributes to the information. creating a list of knowledge contained within the database. presenting information as finish customers or enterprise specialists would understand them. sustaining information in up to date type.
9. An automatic or guide file that shops details about information components and information traits akin to utilization, bodily illustration, possession, authorization, and safety is the (Factors : 1) information dictionary. information definition diagram. entity-relationship diagram. relationship dictionary.
10. Which is the kind of database administration method that may deal with a lot of pages or paperwork? Factors : 1) Hierarchical DBMS Relational DBMS Community DBMS NoSQL
11. Which is essentially the most distinguished information manipulation language in the present day? (Factors : 1) Entry DB2 SQL Crystal Reviews
12. DBMSs sometimes embrace report-generating instruments in an effort to (Factors : 1) retrieve and show information. show information in an easier-to-read format. show information in graphs. carry out predictive evaluation.
13. A schematic of the complete database that describes the relationships in a database is named (Factors : 1) the information dictionary. the intersection relationship diagram. the entity-relationship diagram. the information definition diagram.
14. What’s the means of streamlining information to attenuate redundancy and awkward many-to-many relationships? (Factors : 1) Normalization Information scrubbing Information cleaning Information defining http://takeexam. subsequent. ecollege. com/(NEXT(f83986aacf))/Major/CourseM…703=rDEJX%252foi1wqaW6CBxURnSNa8tZLcim9DauNr3z3CFpI%253d& Web page 2 of three Scholar Examination 1/16/12 9:14 AM
15. Cloud computing provides (Factors : 1) no database capabilities. some database capabilities. merchandise solely from Amazon and Microsoft. Not one of the above
16. A knowledge warehouse consists of (Factors : 1) historic information from legacy methods. present information. inner and exterior information sources. istoric and present inner information.
17. A knowledge mart often could be constructed extra quickly and at decrease price than a knowledge warehouse as a result of (Factors : 1) a knowledge mart sometimes focuses on a single topic space or line of enterprise. all the knowledge is historic. a knowledge mart requires a Internet interface. the entire data belongs to a single firm.
18. Information mining is a device that permits customers to (Factors : 1) shortly evaluate transaction information gathered over a few years. discover hidden relationships in information. get hold of on-line solutions to advert hoc questions in a fast period of time. summarize huge quantities of knowledge into a lot smaller, conventional reviews.
19. What’s the device that permits customers to view the identical information in several methods utilizing a number of dimensions? (Factors : 1) Predictive evaluation SQL OLAP Information mining 20. OLAP is a device that permits (Factors : 1) customers to acquire on-line solutions to advert hoc questions in a brief period of time. customers to view each logical and bodily views of knowledge. programmers to shortly diagram information relationships. programmers to normalize information. Save Solutions Submit for Grading http://takeexam. subsequent. ecollege. com/(NEXT(f83986aacf))/Major/CourseM…703=rDEJX%252foi1wqaW6CBxURnSNa8tZLcim9DauNr3z3CFpI%253d& Web page three of three