MORE Know HoW Flashcards
WHAT is Data definition language?
AN overall description of a database, including the names of data elements, their characteristics, and their relationship to each other
WHAT is a procedure that should be apart of a disaster recovery plan for an IT department?
IDENTIFICATION of Critical applications
i.e. THIS is the first step in preparing a business continuity/disaster recovery plan (to identify and prioritize the entity’s critical applications)
WHAT would be considered the first step in the development of a business continuity plan for a company?
Conducting a business-impact analysis
WHY? - Because a company must determine what must be recovered before it can develop a recovery plan
WHAT will government setting of maximum or ceiling prices below the equilibrium price do to the economy in the short run?
IT will create Product Shortages
WHY? -Because the artificially low price results in an amount supplied less than that at the equilibrium price
Thus, consumers will demand more of the commodity than at the equilibrium price
WHAT is an advantage of a database management system (DBMS)?
THE Independence of data from the application programs
- This allows the programs to be developed for the user’s specific needs without concern for data capture problems
NOTE: Only the “schema” requires alteration
What SHOULD be provided by effective internal controls for application development?
(1) A project steering committee to initiate and oversee the system
(2) Feasibility studies to evaluate existing systems
(3) The establishment of standards for systems design and programming
WHAT is a procedure that would be included in the development of a new system?
Creating the system module by module until completed
WHAT are Fourth-generation computer programming languages represented by?
Query languages - They are intended to simplify programming
i.e. Query languages are most often used with databases
THEY also allow direct access to a computer
WHAT is systems maintenance?
THE process of managing changes in a Change Control System
WHAT would be considered an appropriate justification for selecting a higher-level language over a lower-level language?
BECAUSE higher-level languages are more machine and device independent and more easily understood
WHY? - THEY are more human efficient
WHAT are methods considered for distributing relational databases across multiple servers?
(1) Snapshot
(2) Replication
(3) Fragmentation
WHAT phase of a computer system development would training occur?
In the “Implementation” Phase
WHAT are the configuration elements for data recovery?
(1) Alternate processing site
(2) Backup and off-site storage procedures
(3) Identification of critical applications
(4) Test of Plan
WHAT would be considered a Fourth-generation computer programming language?
Query languages
- They allow direct access to a computer database
WHAT are “Utility” Programs?
Computer programs that perform routine processing functions (e.g. sorting and merging)
These programs are pretested, and independent of the client’s own programming efforts
WHAT are some examples of “Procedural” Languages?
C++, BASIC, FORTRAN, and COBOL
THESE are also known as “higher-level languages”
WHAT are examples of database management systems?
DB2, Oracle, SQL Server, and Access
i.e. THEY are integrated sets of computer programs that create the database, maintain the elements, safeguard the data from loss or destruction, and make the data available to application programs and inquiries
WHAT would be a reason a company Establishes an off-site web server?
IF a company has a significant e-commerce presence and self-hosts its web site
WHAT is eXtensible Markup Language (XML)?
useful for putting structured data into a text file
i.e. It is focused on the content of the data
WHAT is the equation for Accrual accounting rate of return?
Annual Increase in Net Income
Divided by: Initial Investment
*It is important to not that you must account for depreciation if there is any
