Functions of a dbms - Study guides, Class notes & Summaries

ad hoc query - Answer-A "spur-of-the-moment" question. analytical database - Answer-A database focused primarily on storing historical data and business metrics used for tactical or strategic decision making. availability - Answer-In the context of data security, it refers to the accessibility of data whenever required by authorized users and for authorized purposes. Centralized - Answer-A database located at a single site. cloud database - Answer-A database that is created and maintaine...

ad hoc query A "spur-of-the-moment" question. analytical database A database focused primarily on storing historical data and business metrics used for tactical or strategic decision making. availability In the context of data security, it refers to the accessibility of data whenever required by authorized users and for authorized purposes. Centralized A database located at a single site. cloud database A database that is created and maintained using cloud services, such as Microsoft Az...

[WHERE conditionlist]; What command replaces the ***** in the above statement? a. SET columnname = expression b. columnname = expression c. expression = columnname d. LET columnname = expression - Answer a. SET columnname = expression A record consists of a ____. a. character b. collection of related records c. set of one or more fields d. group of files - Answer c. set of one or more fields A DBMS performs several important functions that guarantee the integrity and con...

ISTM 210 - Exam 3 (Phinney) Questions and Answers 100% Pass Google, DropBox, and Microsoft are company examples of what type of providers? Cloud Service Providers (CSP) Using data visualization instead of _______________________, makes business programming much easier to understand. Structured Query Language (SQL) Business Intelligence Can be described as computer applications that change data into significant, meaningful information that helps organizations make better decisions....

Google, DropBox, and Microsoft are company examples of what type of providers? - Answer-Cloud Service Providers (CSP) Using data visualization instead of _______________________, makes business programming much easier to understand. - Answer-Structured Query Language (SQL) Business Intelligence - Answer-Can be described as computer applications that change data into significant, meaningful information that helps organizations make better decisions. A well thought-out collection of computer...

What are the 3 components of IT (M1) - Hardware, Software, Users What are the 3 categories of Software (M1) - Operating Systems, Programming, Databases Define: System (M1) - A combination of independent parts all working together to accomplish a certain goal Define: Hardware Components (M1) - The structure of computers and their peripherals How does IT Support Business? (6 answers) (M1) - 1. Communication, internal and external 2. Sharing of resources 3. Facilitating integration of departm...

Data Management Foundations Latest Update Graded A+ file structure the format that data is arranged and stored in a file. flat files Files having no internal hierarchy heap files Files containing an unsorted set of records that are uniquely identified by a record id which allows them to be inserted or deleted using that id. index files Files containing an unsorted set of records that are uniquely identified by a record id which allows them to be inserted or deleted using that id...

D427 - Database Management Applications Exam Questions Schema The definition of how data in a database will be organized. - Create - Read - Update - Delete The basis of interacting with databases can be defined using the CRUD acronym. What does CRUD stand for? DATE: YYYY-MM-DD DATETIME: YYYY-MM-DD HH:MM:SS What is the DATE datatype syntax? What is the DATETIME datatype syntax? It will have 3 numbers before the decimal and 2 after. What does DECIMAL(3,2) indicate? ...

___ integrate different organizational processes information into a unified system for the entire enterprise - ANSWER B. ERP Just in Time (JIT) is - ANSWER C. a method for producing or delivering a product or service precisely when the customer wants it Monte Carlo Inc. wants to set up a luxury resort in a desert close to Cairo. With an eye on customer needs, it wants to ensure that all its guests can access the Internet from their rooms, the lobby, and the restaurants. Which of the follow...

a book of financial accounts - ledger A graphical representation of the flow documents and information between departments or areas of responsibility within an organization is called - a document flowchart a list of all general ledger accounts an organization uses - chart of accounts A listing of general ledger accounts by account number is called the - chart of accounts a process that begins with capturing data about a transaction and ends with an information output, such as a set of fina...