Year 12 CSC Sem 2 Revision 1

What RAID mirrors data between a minimum of two storage devices?

These act as a translator between a piece of hardware and the operating system.

What do we use to decompose high-level processes in system documentation?

What SQL statement is used to modify the existing records in a table?

What allocates space on the hard disk to supplement the immediate, functional memory capacity of RAM?

IP allows does not protect our ideas by law and prevents gaining compensation if our creations are stolen

The final process (Store) of the Fetch Execute Cycle sends and writes the results back in main memory.

Which type of processing refers to a single computer that uses more than one CPU to run applications and tasks?

What notation is represented below

We use what to make a computer with minimal hardware and server allocated software?

Directories work off a ____ basis, meaning each folder can contain multiple sub-folders, each containing their own files

What is the biggest issue with Data mining?

We can use what to help us run multiple Operating Systems

What puts more emphasis on planning and less on development

The ________ bus specifies the the location of a physical memory address

What controls how data is stored and accessed?

Swapping programs or parts of programs between memory and one or more disk devices—this is a concept called what?

What allows the running an operating system and associated software separate from its host machine.

An advantage of this database type is ability for total security.

Which of the following is not an example of secure data disposal?

A form of preventing data loss as files are backed up externally.

_______ allows for data to be mirrored on multiple storage devices, hence preserving data if one device should fail

Which of the following is not a way to protect our intellectual property?

Which of the following is not a role of an operating system?

A disadvantage of this database type is the complexity of the database.

An issued right for an invention that allows the creator to commercially exploit the invention for the life provided

CPU's are designed to only act upon data once stored in a register

A backup that only contains files that have been changed or altered since the last full backup.

Which of the following is NOT an SQL operator?

What ties all of the OS components together and regulates other programs?

What allocates computer resources to make the best use of each system’s assets?

A database or collection of databases that are updated across a larger area.

______________partitions are generally for use as reserved sections that allow for important data.

What system is designed to perform a specific purpose?

What CPU component performs all arithmetic (mathematic) and logic operations?

A disadvantage of this type of database is the potential bottlenecking if multiple users are trying to access it at once

A document that ensures harmony within an organization, encouraging proper etiquette and behaviour.

An advantage of this type of database is due to the fact that the data can be accessed from anywhere

What processor architecture is used in high end CPUs for applications that need video processing, supercomputers etc?

What type of processing runs in the order that the tasks were received?

The illegal use or reproduction of someone else's work is known as...

Intellectual property is a term referred as...

We use this to find trends which can assist sales, promotions and marketing.

What is accessing data and programs over the Internet as opposed to your Computer's hard drive.

What bus ensures that the operation is happening at the correct time

What processor architecture has a memory unit to conduct complex instructions?

A process which only takes input is called what?

Codes of conduct apply to websites and online resources as well as computing systems.

At what phase would you test the security of a database in a production environment?

These are capable of grouping specific files in to a centralized place

________________ statement is used to drop an existing SQL database.

Generally systems are case insensitive, meaning "MyFile" and "myfile" will point to the same file

What ensures a user has enough reserve power to shut down a system correctly, thus preserving data?

A ______ will wipe all the data on the hard drive, as well as over-writing and removing the factory pre-recorded data.

What emulates whole computers and associated applications?

Which type of implementation is the lowest cost and highest risk?

What model makes sure phases do not overlap?

Which of the following is not a type of benchmarking?

SQL - A table can have only ONE primary key

Context diagrams only ever have one process bubble.

When data is grouped in order to make it easy to identify, we call this a..

What regulates the timing and speed of a computer system's functions?

The ability to carry a single pocket-sized device with the capability of 4 devices is an example of

SQL- We use ______ to sort the result-set in ascending or descending order

What bus is responsible for transferring program instructions to the CPU

Program licensing costs can be reduced as software can be hosted and used externally thanks to...

__________ processing allows for tasks to be run simultaneously

These are used to identify where a specific set of information is stored on a file system.

The act of conducting tests to measure performance of parts within a computer system is what?

The __________ KEY constraint uniquely identifies each record in a table.

Which of the following is not an advantage of Virtualisation?

What phase would you use Data Gathering Techniques?

Which of the following is NOT a type of piracy?

The ___________ in the Control Unit works out what to do with the instruction

During the Fetch process, the instruction is collected from a ______ location.

What type of implementation has both systems run simultaneously until the new one is considered stable and usable.

SQL - The ____________ constraint ensures that all values in a column are different

A set of programs that controls the computer hardware and acts as an interface with applications.

_________ benefits our economy, as less resources are used in gathering new materials since old materials are re-used

As each instruction is fetched, the program counter increments (increases) by ----

What type of design defines the boundary between a system and it's environment?

The action of breaking up a storage device in to many usable chunks is called...

A computer utilizes __________ to send and receive binary data as encoded electrical signal

SQL - This statement is used to filter records

Which CPU component is not involved in the Fetch Execute Cycle?

What allows us to upgrade and maintain software and hardware on multiple computers?

The _________ stores the address (location) of the instruction being processed at any point in time

_____________ is a legal method of ensuring your work won't be stolen.

A set of documented steps (or procedures) to be used in the event of a disaster is referred to as what?

At what phase would you begin documenting the new system?

Like the address bus, the data bus is incapable of two way operations

What system is configured to a particular hardware configuration?

Allows for performance and no redundancy, but should not be used for backing up data as information is not mirrored.

What RAID allows striping across a minimum of four storage devices, and also mirrors data on storage devices?

The storage of data warehouses and marts are on _________.

Simply moving a file to the computer's trash is ineffective, as this only removes the indexes to the data.

Which of the following involves defining the goals of the new system?

The Arithmetic Logic Unit (ALU) executes the decoded instructions

A small data warehouse usually with data for just one area.