Year 12 CSC Sem 2 Revision 1

The storage of data warehouses and marts are on _________.

What emulates whole computers and associated applications?

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

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

What system is designed to perform a specific purpose?

What notation is represented below

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

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

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

________________ statement is used to drop an existing SQL database.

Which of the following is not an advantage of Virtualisation?

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

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

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

SQL - This statement is used to filter records

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

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

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

What phase would you use Data Gathering Techniques?

Intellectual property is a term referred as...

Which of the following is NOT a type of piracy?

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

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

What puts more emphasis on planning and less on development

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

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

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

A process which only takes input is called what?

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

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

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

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

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

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

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

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

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

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

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

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

What model makes sure phases do not overlap?

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

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

SQL - A table can have only ONE primary key

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

Which of the following is not a type of benchmarking?

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

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

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

We can use what to help us run multiple Operating Systems

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

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

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

Context diagrams only ever have one process bubble.

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

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

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

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

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

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

The Arithmetic Logic Unit (ALU) executes the decoded instructions

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

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

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

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

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

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

Which of the following is NOT an SQL operator?

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

What controls how data is stored and accessed?

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

__________ processing allows for tasks to be run simultaneously

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

What system is configured to a particular hardware configuration?

At what phase would you begin documenting the new system?

What bus is responsible for transferring program instructions to the CPU

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

What is the biggest issue with Data mining?