Paper 2 - Computer Science

What will the following SQL statement return?

SELECT * FROM [Customers]

• The entire Customers table

• The first record in the Customers table

• The address of the first Customer

• Nothing

Cleaning up data entered by removing non-standard characters

• Input sanitation

• Defragmentation

• Validation

• Casting

Hiding or removing irrelevant details from a program to reduce complexity

• Abstraction

• Decomposition

• Logical thinking

• Algorithmic thinking

Checking that the user is allowed to access the program

• User permissions

• Decomposition

• File management

• User interface

Breaking a complex program down into smaller programs

• Decomposition

• Abstraction

• Input sanitation

• Iteration

Repeating elements of a program

• Iteration

• Decomposition

• Abstraction

• Casting

Converting one data type to another, for example converting an integer to a real number

• Casting

• Iteration

• Integer division

• Exponentiation

An informal way of programming description that does not require any strict programming language syntax

• Pseudocode

• Python

• Idle

• Interpreter

Examples of high-level language

• Python

• GUI

• Assembly language

• Machine code

Machine code is also known as

• Binary

• Assembly language