Database and Computer Architecture Concepts

This video provides a comprehensive revision of the OCR H446 A Level Paper One 2022, covering key topics such as the fetch-decode-execute cycle, pipelining, CPU architectures, CISC vs RISC, scheduling algorithms, translators, the compilation process, assembly language, SQL, transaction processing, network protocols, number systems, floating point representation, and character sets. The video aims to prepare students for their exams by summarizing these topics and providing examples and explanations.

What is the first step in the fetch stage of the fetch-decode-execute cycle?

• The control unit decodes the instruction.

• The program counter copies the address of the next instruction into the memory address register.

• The instruction is executed by the CPU.

• The data is loaded into the accumulator.

Which architecture stores instructions and data together in the same memory unit?

• Von Neumann Architecture

• CISC Architecture

• Harvard Architecture

• RISC Architecture

What is a key advantage of RISC over CISC?

• More instructions supported by the CPU

• Simplified hardware and better for pipelining

• More power consumption

• Larger physical size

In round-robin scheduling, what happens if a process does not finish within its allocated time?

• It is prioritized.

• It is given additional time.

• It is moved to the back of the queue.

• It is terminated.

Which stage of the compilation process involves removing comments and white space from the code?

• Syntax Analysis

• Optimization

• Code Generation

• Lexical Analysis

What does the 'BRP' instruction in assembly language stand for?

• Branch if Positive

• Branch if Zero or Positive

• Branch if Negative

• Branch Always

In SQL, what does the 'JOIN' keyword do?

• Deletes records from a table

• Filters records based on a condition

• Selects all columns from a table

• Combines records from two tables based on a related column

What does the 'A' in ACID properties stand for?

• Atomicity

• Availability

• Accuracy

• Authentication

Which type of switching divides messages into packets that are sent across a network?

• Channel Switching

• Circuit Switching

• Packet Switching

• Message Switching

How is the decimal number 75 represented in binary?

• 1001011

• 01101001

• 1100101

• 01001011