35. Fields acting as a unique identifier are known as and they tell the database
ID: 3595804 • Letter: 3
Question
35. Fields acting as a unique identifier are known as and they tell the database management systom which records are related and can therefore be joined with others in related tables a. Common fselds b. Commion attributes c. Primary keys d. Secondary key e. Common £iles 36. An entity is a person, place, thing, or event about which information is maintained In a database. a. True b. False 37. A standardized programming language used to manipulate data and write queries in relational database system, which collects data about commercial transactions, i s a. query-by-example language tOBE) b. MS-Excel (XLSX) c. Oracle database management system (DBMS) d. Structured Query Language (SOL) 38. One example of an enterprise resource planning (ERP) system is the corporate software product (used in class to run your bottled water company) which is called a. Norton ants-virus software b. Facebook c. SAP d. Microsoft Access 39. An ERP system is typically used: a. Within one department to do a single functlon b. In only one manufacturing plant to run their factory production line c. In only one isolated subsidiary of a company d. Across most or all of an entire corporation 40. An example of master data in the ERP simulation which is setup at installation, applies across the company, and which seldom changes, would be: a. The product ID code and names of bottle water sold by the company b. The amount of money spent per region on marketing (advertising) c. Price of a product d. The amount of inventory for the 1 liter ClearPure product 41. A transaction processing system (TLP) is a system that a. analyzes historic archived business data b. processes business events and stores transaction data as these events c. handles later batch processing of business transactions all at once at the en of a day d. only provides a high level summary of business data without providing supporting details view of the overall 42. Enterprise resource planning systems take a(n) organization so that different functional areas work effectively together. a. integrated and cross-functional b. end user c. functional d. custoner A major benefit of using an integrated Enterprise Resource Planning (ERP) 43. system is that it: a. Allows each department to operate in its own chosen way b. Separates data and prevents sharing information (about customers, vendors, products, etc.) between functional departments within a company. c. Limits data input to only one curre all subsidiaries of company throughout the world d. Makes real time business information available in a central database ncy and one language that must be used inExplanation / Answer
35. Primary Keys
the other options are not necessarily unique.On the other hand, primary keys are uniques which are used to retrieve the data uniquely from the tables in the databases.
36. True
Entity is nothing but the real world thing which could be basically anything
37. Structured Query Language
The other given options are used with the help of query language like Structured query language but without SQL the other cannot accomplish the task of retrieving the data from the databases.
38. SAP
Norton anti-virus is just virus protection system software. Facebook is the social networking site. Microsoft Access is an application in the office package. The only SAP is an ERP in the given options.
39. Across most or all of an entire corporation
By the definition, ERP is to work integrated with all the departments of the organizations
40.
41.
42. Integrated and cross-functional view
43.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.