COSC: FINAL PRACTICE EXAM – Flashcards

Which view of data deals with how the data is actually formatted and located?

If all the data in a database is not physically located in one place, it would be a(n) _______ database.

Querying the database and generating reports is assisted by the application generation subsystem.

The ATM works on the principle of real-time processing.

Data consists of only numbers, letters, and symbols.

A commercial database is generally an enormous database that an organization develops to cover particular subjects.

The logical arrangement of data in a database is called the database model.

Information collected by an organization from a variety of external and internal databases is stored in this special type of database.

The company database may be stored on a central database server and managed by a database administrator.

In this subsystem, a user can create data entry forms.

Which of the following is not an advantage of using a database?

Database tables can be related or connected to other tables by common key fields.

This commercial database offers news and information on legal, public records, and business issues.

The database in which data elements are organized using classes, objects, attributes, and methods is called the object-oriented database.

In the object-oriented database model, this term is the equivalent to a field in a relational model.

In order to create, modify, and gain access to a database, special software, called the database management system, is required.

Access to these databases is offered to the public or selected outside individuals, for a fee.

Data redundancy can occur due to lack of data integrity.

A hierarchical database uses many-to-many relationships.

Analysis tools that support viewing all or selected parts of data, querying the database, and generating reports include query-by-example as well as specialized programming language called _______.

DO WHILE is an example of a sequential structure.

Top-down program design is used to identify the program's processing steps after the outputs and inputs have been determined.

A 5GL language incorporates the concepts of artificial intelligence to allow a person to provide a system with a problem and some constraints, and then request a solution.

These second generation languages use abbreviations or mnemonics that make it easier for humans to understand.

For an attempt at translation to work as a form of the testing process, the program must be free of logic errors to be able to run.

This is an outline of the logic of the program you will write.

These first generation languages are hard to use, with one of the reasons being that they are different depending on the make of the computer.

C++ is an example of a machine language.

Identify the programming tool that uses symbols to show the sequence of steps needed to solve a programming problem.

A condition must be met before a sequential structure can proceed to the next statement.

A _______ is a list of instructions for the computer to follow to accomplish the task of processing data into information.

These consist of logically related programming statements.

This type of error could be the result of the programmer making an incorrect calculation.

This is the process of testing and eliminating errors in a program.

One of the best ways to code effective programs is to write so-called _______ programs, using the logic structures.

Agile software development starts by getting core functionality of a program working, and then expands on it until the customer is satisfied with the results.

The report at the end of the program design step typically consists of pseudocode, flowcharts, and logic structures.

Pseudocode is an outline of the logic of the program you would like to write.

Program documentation is intended only for end-users.

Program maintenance involves ensuring that current programs are operating error-free, efficiently, and effectively.

In a network database, nodes may have a many-to-many relationship.

Relational database tables require a common data item.

A collection of related fields such as a person's name, address, and age.

A record is a collection of related tables.

In a network database, a node can be traced down through different branches.

Having several instances of the same data is called data _______.

These databases store not only data but also instructions to manipulate the data.

In this database model, the fields or records are structured in nodes.

If Mr. Smith's bike has been sent to his new address, but the bill to his old one, it can most likely be attributed to a lack of data _______.

This type of database is organized into many tables with common data items (key fields) linking the tables to one another.

The logical view of data focuses on meanings and content of the data.

Program objectives, desired outputs, needed inputs, and processing requirements are all recorded in this.

This is testing a program by a select group of potential users.

This type of software development focuses less on the procedures and more on defining the relationships between previously defined procedures.

Pseudocode graphically presents the detailed sequence of steps needed to solve a programming problem.

A programming language uses symbols, words, and phrases to instruct a computer to perform specific operations.

One of the items to be defined in the program specification is the program's objectives.

Fifth-generation languages (5GLs) incorporate the concepts of which of the following?

This type of language uses natural languages to allow humans to communicate more directly to a computer.

A condition must be met before a sequential structure can proceed to the next statement.

The DO WHILE loop means that the loop statements will be executed as long as a certain condition exists.

In this logic structure, one program statement follows another.

A compiler _______.

A field that uniquely identifies each record.

This subsystem defines the logical structure of the database by using a data dictionary or schema.

The combined information presented on this type of database can be used to change the whole merchandising strategy of a store.

C++ is a procedural language that is widely used by today's programmers.

Which of the following refers to tools that are used to provide some assistance in designing, coding, and testing software?

CASE tools are used to compile programs to test for logic errors.

Coding is only one of the six steps of programming.

The program's objectives, outputs, inputs, and processing requirements are determined during in this step.