Explain the difference between TCP and UDP protocols.

TCP is reliable and connection-oriented; UDP is faster and connectionless.

TCP is faster and connectionless; UDP is reliable and connection-oriented.

TCP and UDP are both connection-oriented protocols.

UDP guarantees delivery of packets, while TCP does not.

What are the main phases of the Software Development Life Cycle?

Planning, Requirements Analysis, Design, Implementation, Testing, Deployment, Maintenance

Concept, Development, Evaluation, Support

Analysis, Design, Testing, Release

Planning, Design, Implementation, Review

What is the purpose of a flowchart in software development?

The purpose of a flowchart in software development is to visualize the process and workflow.

To replace the need for coding entirely.

To create a detailed technical specification.

To serve as a user manual for end-users.

Describe the basic components of computer architecture.

The basic components of computer architecture are the CPU, memory, I/O devices, and system bus.

Operating system, firmware, application software, and peripherals

Network interface, hard drive, display, and keyboard

Motherboard, power supply, graphics card, and software

What is the function of the ALU in a CPU?

The ALU performs arithmetic and logical operations in a CPU.

The ALU manages input and output devices.

The ALU controls the CPU's clock speed.

How do you perform a JOIN operation in SQL?

Use the syntax: SELECT columns FROM table1 JOIN table2 ON table1.column = table2.column;

JOIN table1 WITH table2 ON table1.column = table2.column;

SELECT columns FROM table1 UNION table2 ON table1.column = table2.column;

SELECT * FROM table1 AND table2 WHERE table1.column = table2.column;

What is the purpose of an index in a database?

To improve the speed of data retrieval operations.

To create backups of the database.

To store data in a more compact format.

To ensure data integrity and consistency.

What is the main advantage of using a NoSQL database over a traditional SQL database?

NoSQL databases can handle unstructured data more effectively.

NoSQL databases are only suitable for small applications.

NoSQL databases are always faster than SQL databases.

NoSQL databases do not require any form of data modeling.

What is the purpose of a foreign key in a relational database?

To establish a relationship between two tables.

To uniquely identify a record in a table.

To create a backup of the database.

What is the significance of version control in software development?

Version control allows multiple developers to work on the same project simultaneously.

Version control eliminates the need for testing.

Version control is used to create backups of the entire project.

Version control is only necessary for large projects.

What is the purpose of a trigger in a database?

A trigger is a set of instructions that are automatically executed in response to certain events on a particular table.

To enforce data integrity constraints.

To create a backup of the database.

To automatically generate reports based on data changes.

What is the difference between a relational database and a non-relational database?

Relational databases use tables to store data, while non-relational databases can use various formats like key-value pairs, documents, or graphs.

Relational databases can only store structured data, while non-relational databases can store unstructured data.

Non-relational databases do not support transactions.

Relational databases are always faster than non-relational databases.

What is the purpose of a data warehouse?

A data warehouse is used for reporting and data analysis, storing historical data from multiple sources.

To store operational data for real-time processing.

To manage user access and permissions.

What is the purpose of a stored procedure in a database?

A stored procedure is a set of SQL statements that can be stored and executed on the database server.

To enforce data integrity constraints.

To store data in a more compact format.

To create backups of the database.

What is the difference between a compiler and an interpreter?

A compiler translates the entire program at once, while an interpreter translates it line by line.

A compiler is used for scripting languages, while an interpreter is used for compiled languages.

Both compiler and interpreter execute code in the same way.

An interpreter is faster than a compiler.

What is the purpose of a cache in computer systems?

A cache is used to temporarily store frequently accessed data to speed up data retrieval.

To permanently store data for long-term access.

To encrypt sensitive information in the database.

To manage user permissions and access controls.

What is the purpose of a data model in database design?

To define the structure of data and relationships between data elements.

To enforce data integrity constraints.

To create backups of the database.

To store data in a more compact format.

What is the difference between synchronous and asynchronous programming?

Synchronous programming executes tasks sequentially, while asynchronous programming allows tasks to run concurrently.

Asynchronous programming is always faster than synchronous programming.

There is no difference; both terms refer to the same concept.

Synchronous programming is used for web applications, while asynchronous programming is used for desktop applications.

What is the role of a database management system (DBMS)?

A DBMS is used to manage and manipulate databases, providing an interface for users and applications.

A DBMS is a programming language for writing database queries.

A DBMS is a type of hardware used for data processing.

A DBMS is only used for data storage.

What is the purpose of a view in a database?

A view is a virtual table that provides a way to present data from one or more tables.

To permanently store data in the database.

To create backups of the database.

To enforce data integrity constraints.

What is the purpose of a foreign key constraint?

To ensure that a column in one table matches a column in another table.

To create a backup of the database.

To uniquely identify a record in a table.

What is the purpose of a data warehouse?

A data warehouse is designed to store and analyze large volumes of historical data.

A data warehouse is primarily used for data entry.

A data warehouse is used for real-time transaction processing.

A data warehouse is a type of NoSQL database.

What is the significance of data integrity in databases?

Data integrity ensures that data is accurate and consistent over its lifecycle.

Data integrity is only important during data entry.

Data integrity is a method of data encryption.

Data integrity refers to the speed of data retrieval.

What is the role of a database index?

A database index helps to speed up the retrieval of rows from a table.

A database index is used to enforce data integrity constraints.

A database index is used to store large binary files.

A database index is a type of data model.

What is the purpose of a primary key in a relational database?

To uniquely identify a record in a table.

To create a backup of the database.

To establish a relationship between two tables.

What is the purpose of a transaction in a database?

To ensure that a series of operations are completed successfully or not at all.

To improve the performance of data retrieval.

To permanently delete data from the database.

To create a backup of the database.

What is the purpose of a schema in a database?

A schema defines the structure of the database, including tables, fields, and relationships.

A schema is only relevant for NoSQL databases.

A schema is a type of database backup.

A schema is used to encrypt sensitive data.

What is a greedy algorithm?

An algorithm that makes the best choice at each step with the hope of finding the global optimum.

An algorithm that uses randomization to find a solution.

An algorithm that explores all possible solutions to find the best one.

An algorithm that requires backtracking to find the optimal solution.

What is the purpose of a sorting algorithm?

To arrange data in a specific order, such as ascending or descending.

To encrypt data for security purposes.

To compress data to save storage space.

To randomly shuffle data for testing.

What is a recursive algorithm?

An algorithm that solves a problem by breaking it down into smaller subproblems of the same type.

An algorithm that uses loops to repeat operations.

An algorithm that requires a fixed number of steps to complete.

An algorithm that cannot be implemented in programming languages.

What is the main purpose of using an API in software development?

To allow different software systems to communicate with each other.

To improve the performance of a single application.

To create a user interface for applications.

What is the role of a cache in computer systems?

To temporarily store frequently accessed data for faster retrieval.

To permanently store data for future use.

To encrypt sensitive information.

To manage user permissions and access.

What is the purpose of a software framework?

To provide a set of tools and libraries for building applications.

To replace the need for programming languages.

To create a user manual for software.

To ensure data security in applications.

What is the function of an index in a database?

To speed up the retrieval of records from a table.

To store data in a more compact format.

To ensure data integrity in the database.

What is the purpose of a view in a database?

To provide a virtual table based on the result of a query.

To permanently store data in the database.

To enforce data integrity constraints.

To create backups of the database.

What is the significance of ACID properties in database transactions?

ACID properties ensure that transactions are processed reliably.

ACID properties refer to the speed of data retrieval.

ACID properties are only relevant for NoSQL databases.

ACID properties are used to encrypt sensitive data.

What is the primary purpose of normalization in database design?

To reduce data redundancy and improve data integrity.

To increase the speed of data retrieval.

To create backups of the database.

To store data in a more compact format.

IBDP Computer Science SL Revision

Authored by Mario Himawan

Computers

12th Grade

Used 4+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

48 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a data structure?

A data structure is a specialized format for organizing, processing, and storing data.

A data structure is a method for writing code.

A data structure is a type of computer program.

A data structure is a programming language.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Explain the difference between a stack and a queue.

Both stack and queue use LIFO.

A stack uses LIFO, while a queue uses FIFO.

A stack uses FIFO, while a queue uses LIFO.

A stack allows random access, while a queue does not.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of an algorithm?

To replace the need for human decision-making entirely.

To create random data for testing purposes.

To generate artistic content without any rules.

The purpose of an algorithm is to provide a systematic method for solving problems or performing tasks.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Describe the Big O notation and its significance.

Big O notation describes the upper bound of an algorithm's complexity, indicating its efficiency and scalability.

Big O notation is used to describe the exact runtime of an algorithm.

Big O notation measures the average case performance of an algorithm.

Big O notation indicates the lower bound of an algorithm's complexity.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is database normalization?

Database normalization is the method of encrypting data for security purposes.

Database normalization is the technique of merging multiple databases into one.

Database normalization is the process of creating backups of a database.

Database normalization is the process of structuring a relational database to minimize redundancy and dependency by organizing fields and tables.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

List the different normal forms in database normalization.

1NF, 2NF, 3NF, BCNF, 4NF, 5NF

1NF, 2NF, 3NF, 6NF

1NF, 2NF, 3NF, 4NF, 5NF, 6NF

1NF, 2NF, 3NF, 4NF, 5NF, 7NF

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the role of a primary key in a database?

To store large binary files in the database.

The role of a primary key in a database is to uniquely identify each record in a table.

To encrypt sensitive data in the database.

To create relationships between different tables.

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

50 questions

TEST EXCEL

Quiz

•

9th - 12th Grade

50 questions

LATIHAN PAT INFORMATIKA KELAS X

Quiz

•

9th - 12th Grade

44 questions

Chapter 41 & 42 Fuel Injection

Quiz

•

12th Grade

43 questions

Parts of DSLR Camera

Quiz

•

10th - 12th Grade

50 questions

Kuis tentang Kecerdasan Buatan

Quiz

•

10th Grade - University

50 questions

Kuis BAB 3 Computational Thinking XII - P5

Quiz

•

12th Grade

50 questions

Uji Pengetahuan UKK TKJ 2023

Quiz

•

9th - 12th Grade

50 questions

SYSTEM KOMPUTER

Quiz

•

12th Grade

Popular Resources on Wayground

8 questions

Spartan Way - Classroom Responsible

Quiz

•

9th - 12th Grade

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

14 questions

Boundaries & Healthy Relationships

Lesson

•

6th - 8th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

3 questions

Integrity and Your Health

Lesson

•

6th - 8th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

9 questions

FOREST Perception

Lesson

•

20 questions

Main Idea and Details

Quiz

•

5th Grade

Discover more resources for Computers

10 questions

Exponent Rules

Quiz

•

9th - 12th Grade