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
