Computer Science Exit Exam Material

Computer Networking and Security 0/3 Intelligent Systems 0/1 Computer Architecture and Operating Systems 0/2 Compiler and Complexity 0/2 Mock Test 0/2 Text lesson Computer Programming-adv Q. 1 What is the primary purpose of a programming language?   a) To communicate with computers   b) To create beautiful websites   c) To design user interfaces   d) To play video games     Answer: a) To communicate with computers    Q. 2 Which of the following is NOT a high-level programming language?   a) Python   b) C++   c) Assembly   d) Java     Answer: c) Assembly    Q. 3 What is the role of a compiler in the software development process?   a) Executes the program   b) Converts source code to machine code   c) Debugs the code   d) Generates user documentation     Answer: b) Converts source code to machine code    Q. 4 Which programming paradigm focuses on breaking down a program into smaller, reusable functions or methods?   a) Object-Oriented Programming (OOP)   b) Procedural Programming   c) Functional Programming   d) Event-Driven Programming     Answer: b) Procedural Programming    Q. 5 What does “DRY” stand for in the context of programming best practices?   a) Don’t Repeat Yourself   b) Do Right Yourself   c) Do It Right, Yesterday   d) Develop, Run, Yield     Answer: a) Don’t Repeat Yourself    Q. 6 In Python, what is the keyword used to define a function?   a) def   b) function   c) func   d) define     Answer: a) def    Q. 7 Which data structure follows the “Last In, First Out” (LIFO) principle?   a) Queue   b) Stack   c) Array   d) Linked List     Answer: b) Stack    Q. 8 What is the purpose of conditional statements in programming?   a) To control the flow of a program   b) To create loops   c) To define data structures   d) To format output     Answer: a) To control the flow of a program    Q. 9 What is the term for a variable that can be accessed from any part of a program?   a) Local variable   b) Global variable   c) Static variable   d) Dynamic variable     Answer: b) Global variable    Q. 10 Which of the following is NOT a valid primitive data type in most programming languages?   a) Integer   b) Boolean   c) String   d) Loop     Answer: d) Loop    Q. 11 What is the purpose of a loop in programming?   a) To store data   b) To execute a block of code repeatedly   c) To declare variables   d) To display output     Answer: b) To execute a block of code repeatedly    Q. 12 In object-oriented programming, what is encapsulation?   a) The process of converting source code to machine code   b) The bundling of data and methods that operate on that data   c) The process of debugging code   d) The creation of user interfaces     Answer: b) The bundling of data and methods that operate on that data    Q. 13 What does the acronym “API” stand for in programming?   a) Advanced Programming Interface   b) Application Programming Interface   c) Automated Program Instruction   d) Application Program Installation     Answer: b) Application Programming Interface    Q. 14 In programming, what is an algorithm?   a) A type of data structure   b) A set of instructions for solving a specific problem   c) A programming language   d) A hardware component     Answer: b) A set of instructions for solving a specific problem    Q. 15 Which of the following is an example of a relational operator in programming?   a) if   b) +   c) >   d) for     Answer: c) >    Q. 16 What is the purpose of version control systems like Git?   a) To write code   b) To compile code   c) To manage and track changes in source code   d) To execute code     Answer: c) To manage and track changes in source code    Q. 17 What is the primary benefit of using functions or methods in programming?   a) They make code shorter   b) They eliminate the need for conditional statements

   Q. 68 What is the term for a software tool that helps programmers find errors in their code?   a) Compiler   b) Interpreter   c) Debugger   d) Linker     Answer: c) Debugger    Q. 69 In object-oriented programming, what is “inheritance”?   a) The process of bundling data and methods that operate on that data   b) The process of acquiring properties and behaviors from a parent class   c) The use of multiple inheritance   d) The process of creating objects     Answer: b) The process of acquiring properties and behaviors from a parent class    Q. 70 What is the primary purpose of a “finally” block in exception handling?   a) To handle exceptions   b) To define variables   c) To ensure that certain code is always executed, regardless of whether an exception occurs   d) To print error messages     Answer: c) To ensure that certain code is always executed, regardless of whether an exception occurs    Q. 71 Which of the following is NOT a valid data type in most programming languages?   a) Integer   b) String   c) Float   d) Loop     Answer: d) Loop    Q. 72 What is the term for the process of organizing data into a structured format for efficient storage and retrieval?   a) Compilation   b) Debugging   c) Data modeling   d) Data sorting     Answer: c) Data modeling    Q. 73 In programming, what is a “library”?   a) A collection of functions and pre-written code that can be used in a program   b) A data structure   c) A type of loop   d) A reserved keyword     Answer: a) A collection of functions and pre-written code that can be used in a program    Q. 74 What does the term “source code” refer to in programming?   a) The code that the computer executes   b) The code written by the programmer   c) The code that links different program components   d) The code used for debugging     Answer: b) The code written by the programmer    Q. 75 What is the primary role of a “constructor” in object-oriented programming?   a) To destroy objects   b) To create objects and initialize their attributes   c) To call methods in a class   d) To handle exceptions     Answer: b) To create objects and initialize their attributes    Q. 76 What is the term for a programming error that results in a program producing an incorrect or unintended output?   a) Syntax error   b) Compilation error   c) Logic error   d) Runtime error     Answer: c) Logic error    Q. 77 In programming, what is “modularity”?   a) The use of modules for software development   b) The process of breaking a program into smaller, self-contained units   c) The use of multiple inheritance   d) The process of designing user interfaces     Answer: b) The process of breaking a program into smaller, self-contained units    Q. 78 What is the term for a statement that does nothing and is used as a placeholder in code?   a) Null statement   b) Empty statement   c) No-operation statement   d) Placeholder statement     Answer: b) Empty statement    Q. 79 In programming, what is “code refactoring”?   a) The process of writing new code from scratch   b) The process of optimizing code for performance   c) The process of restructuring existing code to improve its quality, readability, and maintainability   d) The process of creating user interfaces     Answer: c) The process of restructuring existing code to improve its quality, readability, and maintainability    Q. 80 What is the term for a data structure that stores elements in key-value pairs?   a) Set   b) List   c) Dictionary   d) Stack     Answer: c) Dictionary Curriculum Exit Exam for Computer Science-Advanced System Development 0/4 Programming and Algorithms 0/4 Computer Programming-adv  Text lesson Object Oriented Programming-adv  Text lesson Design and Analysis of Algorithms-adv  Text lesson Data Structure and Algorithms-adv  Text lesson

   Q. 54 In programming, what is a “class”?   a) A data type   b) A block of code that performs a specific task   c) A template for creating objects with shared attributes and behaviors   d) A comment within the code     Answer: c) A template for creating objects with shared attributes and behaviors    Q. 55 What is the term for the process of converting human-readable source code into machine-readable instructions?   a) Compilation   b) Interpretation   c) Execution   d) Debugging     Answer: a) Compilation    Q. 56 What is the purpose of the “for” loop in programming?   a) To execute a block of code repeatedly until a condition is met   b) To perform a specific task a fixed number of times   c) To create conditional statements   d) To define functions     Answer: b) To perform a specific task a fixed number of times    Q. 57 Which of the following is an example of a reserved word in a programming language?   a) Variable   b) Function   c) If   d) Comment     Answer: c) If    Q. 58 In object-oriented programming, what is “encapsulation”?   a) The process of bundling data and methods that operate on that data   b) The process of converting source code to machine code   c) The use of multiple inheritance   d) The process of creating objects     Answer: a) The process of bundling data and methods that operate on that data    Q. 59 What is the primary purpose of a “try-catch” block in exception handling?   a) To intentionally raise exceptions   b) To create loops   c) To handle and recover from exceptions   d) To declare variables     Answer: c) To handle and recover from exceptions    Q. 60 In programming, what is the term for a named piece of code that can be reused throughout a program?   a) Function   b) Variable   c) Class   d) Statement     Answer: a) Function    Q. 61 What is the purpose of a “break” statement in a loop?   a) To terminate the loop and exit it   b) To restart the loop from the beginning   c) To skip the current iteration and continue to the next   d) To print a message to the console     Answer: a) To terminate the loop and exit it    Q. 62 What does the term “algorithm” mean in programming?   a) A step-by-step procedure for solving a problem   b) A type of programming language   c) A data structure   d) A type of error     Answer: a) A step-by-step procedure for solving a problem    Q. 63 What is the term for a data structure that consists of an ordered collection of elements where each element has an associated index?   a) Set   b) Queue   c) List   d) Array     Answer: d) Array    Q. 64 What is the main purpose of a “switch” statement in programming?   a) To declare variables   b) To create loops   c) To provide an alternative to if-else chains for multiple conditional branches   d) To handle exceptions     Answer: c) To provide an alternative to if-else chains for multiple conditional branches    Q. 65 What is the purpose of a “do-while” loop in programming?   a) To execute a block of code repeatedly while a condition is true   b) To perform a specific task a fixed number of times   c) To define functions   d) To declare variables     Answer: a) To execute a block of code repeatedly while a condition is true    Q. 66 What does the term “bug tracking” refer to in software development?   a) The process of finding and fixing errors in a program   b) The process of writing new code   c) The process of documenting code   d) The process of compiling code     Answer: a) The process of finding and fixing errors in a program    Q. 67 In programming, what is the purpose of the “continue” statement in a loop?   a) To end the loop   b) To restart the loop from the beginning   c) To skip the current iteration and continue to the next   d) To print a message to the console     Answer: c) To skip the current iteration and continue to the next

  a) A type of variable   b) A block of code that performs a specific task   c) A loop construct   d) A comment within the code     Answer: b) A block of code that performs a specific task    Q. 42 What does the term “DRY” stand for in the context of programming best practices?   a) Don’t Replicate Yourself   b) Do Right Yourself   c) Data Reusability Yearly   d) Development Ready Yet     Answer: a) Don’t Replicate Yourself    Q. 43 What is the main difference between a “while” loop and a “for” loop in programming?   a) A “while” loop is used for iteration, while a “for” loop is used for making decisions.   b) A “while” loop always runs at least once, while a “for” loop may not run at all.   c) A “for” loop is more efficient for small tasks, while a “while” loop is better for complex tasks.   d) A “while” loop and a “for” loop are functionally equivalent.     Answer: b) A “while” loop always runs at least once, while a “for” loop may not run at all.    Q. 44 In programming, what does the term “refactoring” refer to?   a) Rewriting code from scratch   b) Optimizing code for performance   c) Restructuring existing code to improve readability and maintainability   d) Adding new features to a program     Answer: c) Restructuring existing code to improve readability and maintainability    Q. 45 What is the purpose of the “else” statement in a conditional structure?   a) To end the conditional structure   b) To specify an alternate condition   c) To execute the code block unconditionally   d) To skip the current iteration     Answer: b) To specify an alternate condition    Q. 46 What is the term for a program that translates source code written by a programmer into machine code that a computer can execute?   a) Interpreter   b) Compiler   c) Debugger   d) Linker     Answer: b) Compiler    Q. 47 In programming, what is a “syntax error”?   a) An error that occurs when a program runs out of memory   b) An error that occurs when the program logic is incorrect   c) An error that occurs due to a violation of the programming language’s rules for structure and format   d) An error that occurs when a program crashes     Answer: c) An error that occurs due to a violation of the programming language’s rules for structure and format    Q. 48 Which of the following is an example of a unary operator in programming?   a) +   b) –   c) *   d) /     Answer: b) –    Q. 49 What is the purpose of the “if-else” statement in programming?   a) To create loops   b) To define variables   c) To control the flow of a program based on a condition   d) To declare functions     Answer: c) To control the flow of a program based on a condition    Q. 50 What is the primary purpose of a “while” loop in programming?   a) To perform a specific task a fixed number of times   b) To execute a block of code repeatedly as long as a condition is true   c) To define a function   d) To terminate a program     Answer: b) To execute a block of code repeatedly as long as a condition is true    Q. 51 In programming, what does the term “variable scope” refer to?   a) The physical location in memory where variables are stored   b) The range or context in which a variable can be accessed and modified   c) The data type of a variable   d) The process of declaring a variable     Answer: b) The range or context in which a variable can be accessed and modified    Q. 52 What is the primary role of the “return” statement in a function?   a) To specify the function’s name   b) To indicate the function’s return type   c) To terminate the program   d) To send a value back to the calling code     Answer: d) To send a value back to the calling code    Q. 53 Which of the following is a common data structure used to represent hierarchical data?   a) Queue   b) Stack   c) Tree   d) Set     Answer: c) Tree

    Answer: a) To store and manipulate data    Q. 26 Which of the following is an example of an imperative programming language?   a) Python   b) SQL   c) Haskell   d) Ruby     Answer: a) Python    Q. 27 What is the primary purpose of a comment in code?   a) To confuse other programmers   b) To provide documentation and explanations   c) To execute a specific task   d) To create variables     Answer: b) To provide documentation and explanations    Q. 28 What is the term for a programming error that occurs at runtime and causes a program to terminate abruptly?   a) Syntax error   b) Compilation error   c) Logic error   d) Runtime error     Answer: d) Runtime error    Q. 29 Which data structure stores elements in a first-in, first-out (FIFO) order?   a) Stack   b) Queue   c) Linked List   d) Array     Answer: b) Queue    Q. 30 What is the primary purpose of a function’s return statement in programming?   a) To terminate the program   b) To specify the input parameters   c) To indicate the function’s name   d) To return a value to the calling code     Answer: d) To return a value to the calling code    Q. 31 What is the term for the process of finding and fixing errors in a program?   a) Debugging   b) Compiling   c) Executing   d) Commenting     Answer: a) Debugging    Q. 32 In object-oriented programming, what is polymorphism?   a) The ability of an object to take on multiple forms   b) The process of creating new objects   c) The use of multiple inheritance   d) The process of encapsulating data     Answer: a) The ability of an object to take on multiple forms    Q. 33 Which type of programming language allows the programmer to specify what needs to be done rather than how to do it?   a) Procedural programming language   b) Declarative programming language   c) Object-oriented programming language   d) Functional programming language     Answer: b) Declarative programming language    Q. 34 What is the term for a named storage location in a program that holds data?   a) Data structure   b) Function   c) Variable   d) Statement     Answer: c) Variable    Q. 35 What does the term “syntax” refer to in programming?   a) The set of rules that dictate the structure of valid program statements   b) A programming language’s ability to execute code   c) The process of debugging code   d) The user interface design     Answer: a) The set of rules that dictate the structure of valid program statements    Q. 36 In programming, what does the “break” statement typically do within a loop?   a) Skips the current iteration and continues with the next   b) Ends the loop and continues with the code after the loop   c) Repeats the current iteration   d) Creates an infinite loop     Answer: b) Ends the loop and continues with the code after the loop    Q. 37 What is the purpose of a function’s parameters in programming?   a) To store the function’s local variables   b) To specify the function’s name   c) To receive input values when the function is called   d) To define the function’s return type     Answer: c) To receive input values when the function is called    Q. 38 Which programming concept involves breaking a complex problem into smaller, manageable parts?   a) Abstraction   b) Encapsulation   c) Decomposition   d) Polymorphism     Answer: c) Decomposition    Q. 39 What is the primary advantage of using object-oriented programming (OOP)?   a) Faster program execution   b) Reduced memory usage   c) Enhanced code organization and reusability   d) Simplicity in syntax     Answer: c) Enhanced code organization and reusability    Q. 40 Which programming construct allows you to make decisions based on a condition?   a) Loop   b) Function   c) Class   d) Conditional statement     Answer: d) Conditional statement    Q. 41 In programming, what is a “method”?

  a) Local variable   b) Global variable   c) Static variable   d) Dynamic variable     Answer: b) Global variable    Q. 10 Which of the following is NOT a valid primitive data type in most programming languages?   a) Integer   b) Boolean   c) String   d) Loop     Answer: d) Loop    Q. 11 What is the purpose of a loop in programming?   a) To store data   b) To execute a block of code repeatedly   c) To declare variables   d) To display output     Answer: b) To execute a block of code repeatedly    Q. 12 In object-oriented programming, what is encapsulation?   a) The process of converting source code to machine code   b) The bundling of data and methods that operate on that data   c) The process of debugging code   d) The creation of user interfaces     Answer: b) The bundling of data and methods that operate on that data    Q. 13 What does the acronym “API” stand for in programming?   a) Advanced Programming Interface   b) Application Programming Interface   c) Automated Program Instruction   d) Application Program Installation     Answer: b) Application Programming Interface    Q. 14 In programming, what is an algorithm?   a) A type of data structure   b) A set of instructions for solving a specific problem   c) A programming language   d) A hardware component     Answer: b) A set of instructions for solving a specific problem    Q. 15 Which of the following is an example of a relational operator in programming?   a) if   b) +   c) >   d) for     Answer: c) >    Q. 16 What is the purpose of version control systems like Git?   a) To write code   b) To compile code   c) To manage and track changes in source code   d) To execute code     Answer: c) To manage and track changes in source code    Q. 17 What is the primary benefit of using functions or methods in programming?   a) They make code shorter   b) They eliminate the need for conditional statements   c) They promote code reusability and modularity   d) They improve code execution speed     Answer: c) They promote code reusability and modularity    Q. 18 Which data structure allows you to store a collection of elements with unique values?   a) Array   b) Linked List   c) Set   d) Queue     Answer: c) Set    Q. 19 In object-oriented programming, what is inheritance?   a) The process of creating objects   b) The process of overriding a method   c) The process of acquiring properties and behaviors from a parent class   d) The process of debugging code     Answer: c) The process of acquiring properties and behaviors from a parent class    Q. 20 What is the purpose of exception handling in programming?   a) To create exceptions intentionally   b) To prevent code from running   c) To handle errors and unexpected situations gracefully   d) To improve code readability     Answer: c) To handle errors and unexpected situations gracefully    Q. 21 Which of the following is an example of a dynamic programming language?   a) C   b) C++   c) Java   d) JavaScript     Answer: d) JavaScript    Q. 22 What is the term for a set of rules that dictate how data is organized and stored in a computer’s memory?   a) Syntax   b) Algorithm   c) Data structure   d) Binary code     Answer: c) Data structure    Q. 23 What is a loop that continues to execute indefinitely until a specified condition is met called?   a) For loop   b) While loop   c) Infinite loop   d) Conditional loop     Answer: c) Infinite loop    Q. 24 In the context of programming, what is a “bug”?   a) A type of data structure   b) An insect that affects computers   c) An error or flaw in the code   d) A debugging tool     Answer: c) An error or flaw in the code    Q. 25 What is the purpose of a variable in programming?   a) To store and manipulate data   b) To create user interfaces   c) To define conditional statements   d) To write comments in the code

  d) A comment within the code     Answer: c) A template for creating objects with shared attributes and behaviors    Q. 55 What is the term for the process of converting human-readable source code into machine-readable instructions?   a) Compilation   b) Interpretation   c) Execution   d) Debugging     Answer: a) Compilation    Q. 56 What is the purpose of the “for” loop in programming?   a) To execute a block of code repeatedly until a condition is met   b) To perform a specific task a fixed number of times   c) To create conditional statements   d) To define functions     Answer: b) To perform a specific task a fixed number of times    Q. 57 Which of the following is an example of a reserved word in a programming language?   a) Variable   b) Function   c) If   d) Comment     Answer: c) If    Q. 58 In object-oriented programming, what is “encapsulation”?   a) The process of bundling data and methods that operate on that data   b) The process of converting source code to machine code   c) The use of multiple inheritance   d) The process of creating objects     Answer: a) The process of bundling data and methods that operate on that data    Q. 59 What is the primary purpose of a “try-catch” block in exception handling?   a) To intentionally raise exceptions   b) To create loops   c) To handle and recover from exceptions   d) To declare variables     Answer: c) To handle and recover from exceptions    Q. 60 In programming, what is the term for a named piece of code that can be reused throughout a program?   a) Function   b) Variable   c) Class   d) Statement     Answer: a) Function Curriculum Exit Exam for Computer Science-Advanced System Development 0/4 Programming and Algorithms 0/4 Computer Programming-adv  Text lesson Object Oriented Programming-adv  Text lesson Design and Analysis of Algorithms-adv  Text lesson Data Structure and Algorithms-adv  Text lesson Computer Networking and Security 0/3 Intelligent Systems 0/1 Computer Architecture and Operating Systems 0/2 Compiler and Complexity 0/2 Mock Test 0/2 Text lesson Computer Programming-adv Q. 1 What is the primary purpose of a programming language?   a) To communicate with computers   b) To create beautiful websites   c) To design user interfaces   d) To play video games     Answer: a) To communicate with computers    Q. 2 Which of the following is NOT a high-level programming language?   a) Python   b) C++   c) Assembly   d) Java     Answer: c) Assembly    Q. 3 What is the role of a compiler in the software development process?   a) Executes the program   b) Converts source code to machine code   c) Debugs the code   d) Generates user documentation     Answer: b) Converts source code to machine code    Q. 4 Which programming paradigm focuses on breaking down a program into smaller, reusable functions or methods?   a) Object-Oriented Programming (OOP)   b) Procedural Programming   c) Functional Programming   d) Event-Driven Programming     Answer: b) Procedural Programming    Q. 5 What does “DRY” stand for in the context of programming best practices?   a) Don’t Repeat Yourself   b) Do Right Yourself   c) Do It Right, Yesterday   d) Develop, Run, Yield     Answer: a) Don’t Repeat Yourself    Q. 6 In Python, what is the keyword used to define a function?   a) def   b) function   c) func   d) define     Answer: a) def    Q. 7 Which data structure follows the “Last In, First Out” (LIFO) principle?   a) Queue   b) Stack   c) Array   d) Linked List     Answer: b) Stack    Q. 8 What is the purpose of conditional statements in programming?   a) To control the flow of a program   b) To create loops   c) To define data structures   d) To format output     Answer: a) To control the flow of a program    Q. 9 What is the term for a variable that can be accessed from any part of a program?

   Q. 42 What does the term “DRY” stand for in the context of programming best practices?   a) Don’t Replicate Yourself   b) Do Right Yourself   c) Data Reusability Yearly   d) Development Ready Yet     Answer: a) Don’t Replicate Yourself    Q. 43 What is the main difference between a “while” loop and a “for” loop in programming?   a) A “while” loop is used for iteration, while a “for” loop is used for making decisions.   b) A “while” loop always runs at least once, while a “for” loop may not run at all.   c) A “for” loop is more efficient for small tasks, while a “while” loop is better for complex tasks.   d) A “while” loop and a “for” loop are functionally equivalent.     Answer: b) A “while” loop always runs at least once, while a “for” loop may not run at all.    Q. 44 In programming, what does the term “refactoring” refer to?   a) Rewriting code from scratch   b) Optimizing code for performance   c) Restructuring existing code to improve readability and maintainability   d) Adding new features to a program     Answer: c) Restructuring existing code to improve readability and maintainability    Q. 45 What is the purpose of the “else” statement in a conditional structure?   a) To end the conditional structure   b) To specify an alternate condition   c) To execute the code block unconditionally   d) To skip the current iteration     Answer: b) To specify an alternate condition    Q. 46 What is the term for a program that translates source code written by a programmer into machine code that a computer can execute?   a) Interpreter   b) Compiler   c) Debugger   d) Linker     Answer: b) Compiler    Q. 47 In programming, what is a “syntax error”?   a) An error that occurs when a program runs out of memory   b) An error that occurs when the program logic is incorrect   c) An error that occurs due to a violation of the programming language’s rules for structure and format   d) An error that occurs when a program crashes     Answer: c) An error that occurs due to a violation of the programming language’s rules for structure and format    Q. 48 Which of the following is an example of a unary operator in programming?   a) +   b) –   c) *   d) /     Answer: b) –    Q. 49 What is the purpose of the “if-else” statement in programming?   a) To create loops   b) To define variables   c) To control the flow of a program based on a condition   d) To declare functions     Answer: c) To control the flow of a program based on a condition    Q. 50 What is the primary purpose of a “while” loop in programming?   a) To perform a specific task a fixed number of times   b) To execute a block of code repeatedly as long as a condition is true   c) To define a function   d) To terminate a program     Answer: b) To execute a block of code repeatedly as long as a condition is true    Q. 51 In programming, what does the term “variable scope” refer to?   a) The physical location in memory where variables are stored   b) The range or context in which a variable can be accessed and modified   c) The data type of a variable   d) The process of declaring a variable     Answer: b) The range or context in which a variable can be accessed and modified    Q. 52 What is the primary role of the “return” statement in a function?   a) To specify the function’s name   b) To indicate the function’s return type   c) To terminate the program   d) To send a value back to the calling code     Answer: d) To send a value back to the calling code    Q. 53 Which of the following is a common data structure used to represent hierarchical data?   a) Queue   b) Stack   c) Tree   d) Set     Answer: c) Tree    Q. 54 In programming, what is a “class”?   a) A data type   b) A block of code that performs a specific task   c) A template for creating objects with shared attributes and behaviors

   Q. 27 What is the primary purpose of a comment in code?   a) To confuse other programmers   b) To provide documentation and explanations   c) To execute a specific task   d) To create variables     Answer: b) To provide documentation and explanations    Q. 28 What is the term for a programming error that occurs at runtime and causes a program to terminate abruptly?   a) Syntax error   b) Compilation error   c) Logic error   d) Runtime error     Answer: d) Runtime error    Q. 29 Which data structure stores elements in a first-in, first-out (FIFO) order?   a) Stack   b) Queue   c) Linked List   d) Array     Answer: b) Queue    Q. 30 What is the primary purpose of a function’s return statement in programming?   a) To terminate the program   b) To specify the input parameters   c) To indicate the function’s name   d) To return a value to the calling code     Answer: d) To return a value to the calling code    Q. 31 What is the term for the process of finding and fixing errors in a program?   a) Debugging   b) Compiling   c) Executing   d) Commenting     Answer: a) Debugging    Q. 32 In object-oriented programming, what is polymorphism?   a) The ability of an object to take on multiple forms   b) The process of creating new objects   c) The use of multiple inheritance   d) The process of encapsulating data     Answer: a) The ability of an object to take on multiple forms    Q. 33 Which type of programming language allows the programmer to specify what needs to be done rather than how to do it?   a) Procedural programming language   b) Declarative programming language   c) Object-oriented programming language   d) Functional programming language     Answer: b) Declarative programming language    Q. 34 What is the term for a named storage location in a program that holds data?   a) Data structure   b) Function   c) Variable   d) Statement     Answer: c) Variable    Q. 35 What does the term “syntax” refer to in programming?   a) The set of rules that dictate the structure of valid program statements   b) A programming language’s ability to execute code   c) The process of debugging code   d) The user interface design     Answer: a) The set of rules that dictate the structure of valid program statements    Q. 36 In programming, what does the “break” statement typically do within a loop?   a) Skips the current iteration and continues with the next   b) Ends the loop and continues with the code after the loop   c) Repeats the current iteration   d) Creates an infinite loop     Answer: b) Ends the loop and continues with the code after the loop    Q. 37 What is the purpose of a function’s parameters in programming?   a) To store the function’s local variables   b) To specify the function’s name   c) To receive input values when the function is called   d) To define the function’s return type     Answer: c) To receive input values when the function is called    Q. 38 Which programming concept involves breaking a complex problem into smaller, manageable parts?   a) Abstraction   b) Encapsulation   c) Decomposition   d) Polymorphism     Answer: c) Decomposition    Q. 39 What is the primary advantage of using object-oriented programming (OOP)?   a) Faster program execution   b) Reduced memory usage   c) Enhanced code organization and reusability   d) Simplicity in syntax     Answer: c) Enhanced code organization and reusability    Q. 40 Which programming construct allows you to make decisions based on a condition?   a) Loop   b) Function   c) Class   d) Conditional statement     Answer: d) Conditional statement    Q. 41 In programming, what is a “method”?   a) A type of variable   b) A block of code that performs a specific task   c) A loop construct   d) A comment within the code     Answer: b) A block of code that performs a specific task

  a) Integer   b) Boolean   c) String   d) Loop     Answer: d) Loop    Q. 11 What is the purpose of a loop in programming?   a) To store data   b) To execute a block of code repeatedly   c) To declare variables   d) To display output     Answer: b) To execute a block of code repeatedly    Q. 12 In object-oriented programming, what is encapsulation?   a) The process of converting source code to machine code   b) The bundling of data and methods that operate on that data   c) The process of debugging code   d) The creation of user interfaces     Answer: b) The bundling of data and methods that operate on that data    Q. 13 What does the acronym “API” stand for in programming?   a) Advanced Programming Interface   b) Application Programming Interface   c) Automated Program Instruction   d) Application Program Installation     Answer: b) Application Programming Interface    Q. 14 In programming, what is an algorithm?   a) A type of data structure   b) A set of instructions for solving a specific problem   c) A programming language   d) A hardware component     Answer: b) A set of instructions for solving a specific problem    Q. 15 Which of the following is an example of a relational operator in programming?   a) if   b) +   c) >   d) for     Answer: c) >    Q. 16 What is the purpose of version control systems like Git?   a) To write code   b) To compile code   c) To manage and track changes in source code   d) To execute code     Answer: c) To manage and track changes in source code    Q. 17 What is the primary benefit of using functions or methods in programming?   a) They make code shorter   b) They eliminate the need for conditional statements   c) They promote code reusability and modularity   d) They improve code execution speed     Answer: c) They promote code reusability and modularity    Q. 18 Which data structure allows you to store a collection of elements with unique values?   a) Array   b) Linked List   c) Set   d) Queue     Answer: c) Set    Q. 19 In object-oriented programming, what is inheritance?   a) The process of creating objects   b) The process of overriding a method   c) The process of acquiring properties and behaviors from a parent class   d) The process of debugging code     Answer: c) The process of acquiring properties and behaviors from a parent class    Q. 20 What is the purpose of exception handling in programming?   a) To create exceptions intentionally   b) To prevent code from running   c) To handle errors and unexpected situations gracefully   d) To improve code readability     Answer: c) To handle errors and unexpected situations gracefully    Q. 21 Which of the following is an example of a dynamic programming language?   a) C   b) C++   c) Java   d) JavaScript     Answer: d) JavaScript    Q. 22 What is the term for a set of rules that dictate how data is organized and stored in a computer’s memory?   a) Syntax   b) Algorithm   c) Data structure   d) Binary code     Answer: c) Data structure    Q. 23 What is a loop that continues to execute indefinitely until a specified condition is met called?   a) For loop   b) While loop   c) Infinite loop   d) Conditional loop     Answer: c) Infinite loop    Q. 24 In the context of programming, what is a “bug”?   a) A type of data structure   b) An insect that affects computers   c) An error or flaw in the code   d) A debugging tool     Answer: c) An error or flaw in the code    Q. 25 What is the purpose of a variable in programming?   a) To store and manipulate data   b) To create user interfaces   c) To define conditional statements   d) To write comments in the code     Answer: a) To store and manipulate data    Q. 26 Which of the following is an example of an imperative programming language?   a) Python   b) SQL   c) Haskell   d) Ruby     Answer: a) Python

   Q. 46 What is the term for a program that translates source code written by a programmer into machine code that a computer can execute?   a) Interpreter   b) Compiler   c) Debugger   d) Linker     Answer: b) Compiler    Q. 47 In programming, what is a “syntax error”?   a) An error that occurs when a program runs out of memory   b) An error that occurs when the program logic is incorrect   c) An error that occurs due to a violation of the programming language’s rules for structure and format   d) An error that occurs when a program crashes     Answer: c) An error that occurs due to a violation of the programming language’s rules for structure and format    Q. 48 Which of the following is an example of a unary operator in programming?   a) +   b) –   c) *   d) /     Answer: b) –    Q. 49 What is the purpose of the “if-else” statement in programming?   a) To create loops   b) To define variables   c) To control the flow of a program based on a condition   d) To declare functions     Answer: c) To control the flow of a program based on a condition    Q. 50 What is the primary purpose of a “while” loop in programming?   a) To perform a specific task a fixed number of times   b) To execute a block of code repeatedly as long as a condition is true   c) To define a function   d) To terminate a program     Answer: b) To execute a block of code repeatedly as long as a condition is true Curriculum Exit Exam for Computer Science-Advanced System Development 0/4 Programming and Algorithms 0/4 Computer Programming-adv  Text lesson Object Oriented Programming-adv  Text lesson Design and Analysis of Algorithms-adv  Text lesson Data Structure and Algorithms-adv  Text lesson Computer Networking and Security 0/3 Intelligent Systems 0/1 Computer Architecture and Operating Systems 0/2 Compiler and Complexity 0/2 Mock Test 0/2 Text lesson Computer Programming-adv Q. 1 What is the primary purpose of a programming language?   a) To communicate with computers   b) To create beautiful websites   c) To design user interfaces   d) To play video games     Answer: a) To communicate with computers    Q. 2 Which of the following is NOT a high-level programming language?   a) Python   b) C++   c) Assembly   d) Java     Answer: c) Assembly    Q. 3 What is the role of a compiler in the software development process?   a) Executes the program   b) Converts source code to machine code   c) Debugs the code   d) Generates user documentation     Answer: b) Converts source code to machine code    Q. 4 Which programming paradigm focuses on breaking down a program into smaller, reusable functions or methods?   a) Object-Oriented Programming (OOP)   b) Procedural Programming   c) Functional Programming   d) Event-Driven Programming     Answer: b) Procedural Programming    Q. 5 What does “DRY” stand for in the context of programming best practices?   a) Don’t Repeat Yourself   b) Do Right Yourself   c) Do It Right, Yesterday   d) Develop, Run, Yield     Answer: a) Don’t Repeat Yourself    Q. 6 In Python, what is the keyword used to define a function?   a) def   b) function   c) func   d) define     Answer: a) def    Q. 7 Which data structure follows the “Last In, First Out” (LIFO) principle?   a) Queue   b) Stack   c) Array   d) Linked List     Answer: b) Stack    Q. 8 What is the purpose of conditional statements in programming?   a) To control the flow of a program   b) To create loops   c) To define data structures   d) To format output     Answer: a) To control the flow of a program    Q. 9 What is the term for a variable that can be accessed from any part of a program?   a) Local variable   b) Global variable   c) Static variable   d) Dynamic variable     Answer: b) Global variable    Q. 10 Which of the following is NOT a valid primitive data type in most programming languages?

   Q. 33 Which type of programming language allows the programmer to specify what needs to be done rather than how to do it?   a) Procedural programming language   b) Declarative programming language   c) Object-oriented programming language   d) Functional programming language     Answer: b) Declarative programming language    Q. 34 What is the term for a named storage location in a program that holds data?   a) Data structure   b) Function   c) Variable   d) Statement     Answer: c) Variable    Q. 35 What does the term “syntax” refer to in programming?   a) The set of rules that dictate the structure of valid program statements   b) A programming language’s ability to execute code   c) The process of debugging code   d) The user interface design     Answer: a) The set of rules that dictate the structure of valid program statements    Q. 36 In programming, what does the “break” statement typically do within a loop?   a) Skips the current iteration and continues with the next   b) Ends the loop and continues with the code after the loop   c) Repeats the current iteration   d) Creates an infinite loop     Answer: b) Ends the loop and continues with the code after the loop    Q. 37 What is the purpose of a function’s parameters in programming?   a) To store the function’s local variables   b) To specify the function’s name   c) To receive input values when the function is called   d) To define the function’s return type     Answer: c) To receive input values when the function is called    Q. 38 Which programming concept involves breaking a complex problem into smaller, manageable parts?   a) Abstraction   b) Encapsulation   c) Decomposition   d) Polymorphism     Answer: c) Decomposition    Q. 39 What is the primary advantage of using object-oriented programming (OOP)?   a) Faster program execution   b) Reduced memory usage   c) Enhanced code organization and reusability   d) Simplicity in syntax     Answer: c) Enhanced code organization and reusability    Q. 40 Which programming construct allows you to make decisions based on a condition?   a) Loop   b) Function   c) Class   d) Conditional statement     Answer: d) Conditional statement    Q. 41 In programming, what is a “method”?   a) A type of variable   b) A block of code that performs a specific task   c) A loop construct   d) A comment within the code     Answer: b) A block of code that performs a specific task    Q. 42 What does the term “DRY” stand for in the context of programming best practices?   a) Don’t Replicate Yourself   b) Do Right Yourself   c) Data Reusability Yearly   d) Development Ready Yet     Answer: a) Don’t Replicate Yourself    Q. 43 What is the main difference between a “while” loop and a “for” loop in programming?   a) A “while” loop is used for iteration, while a “for” loop is used for making decisions.   b) A “while” loop always runs at least once, while a “for” loop may not run at all.   c) A “for” loop is more efficient for small tasks, while a “while” loop is better for complex tasks.   d) A “while” loop and a “for” loop are functionally equivalent.     Answer: b) A “while” loop always runs at least once, while a “for” loop may not run at all.    Q. 44 In programming, what does the term “refactoring” refer to?   a) Rewriting code from scratch   b) Optimizing code for performance   c) Restructuring existing code to improve readability and maintainability   d) Adding new features to a program     Answer: c) Restructuring existing code to improve readability and maintainability    Q. 45 What is the purpose of the “else” statement in a conditional structure?   a) To end the conditional structure   b) To specify an alternate condition   c) To execute the code block unconditionally   d) To skip the current iteration     Answer: b) To specify an alternate condition

  c) To manage and track changes in source code   d) To execute code     Answer: c) To manage and track changes in source code    Q. 17 What is the primary benefit of using functions or methods in programming?   a) They make code shorter   b) They eliminate the need for conditional statements   c) They promote code reusability and modularity   d) They improve code execution speed     Answer: c) They promote code reusability and modularity    Q. 18 Which data structure allows you to store a collection of elements with unique values?   a) Array   b) Linked List   c) Set   d) Queue     Answer: c) Set    Q. 19 In object-oriented programming, what is inheritance?   a) The process of creating objects   b) The process of overriding a method   c) The process of acquiring properties and behaviors from a parent class   d) The process of debugging code     Answer: c) The process of acquiring properties and behaviors from a parent class    Q. 20 What is the purpose of exception handling in programming?   a) To create exceptions intentionally   b) To prevent code from running   c) To handle errors and unexpected situations gracefully   d) To improve code readability     Answer: c) To handle errors and unexpected situations gracefully    Q. 21 Which of the following is an example of a dynamic programming language?   a) C   b) C++   c) Java   d) JavaScript     Answer: d) JavaScript    Q. 22 What is the term for a set of rules that dictate how data is organized and stored in a computer’s memory?   a) Syntax   b) Algorithm   c) Data structure   d) Binary code     Answer: c) Data structure    Q. 23 What is a loop that continues to execute indefinitely until a specified condition is met called?   a) For loop   b) While loop   c) Infinite loop   d) Conditional loop     Answer: c) Infinite loop    Q. 24 In the context of programming, what is a “bug”?   a) A type of data structure   b) An insect that affects computers   c) An error or flaw in the code   d) A debugging tool     Answer: c) An error or flaw in the code    Q. 25 What is the purpose of a variable in programming?   a) To store and manipulate data   b) To create user interfaces   c) To define conditional statements   d) To write comments in the code     Answer: a) To store and manipulate data    Q. 26 Which of the following is an example of an imperative programming language?   a) Python   b) SQL   c) Haskell   d) Ruby     Answer: a) Python    Q. 27 What is the primary purpose of a comment in code?   a) To confuse other programmers   b) To provide documentation and explanations   c) To execute a specific task   d) To create variables     Answer: b) To provide documentation and explanations    Q. 28 What is the term for a programming error that occurs at runtime and causes a program to terminate abruptly?   a) Syntax error   b) Compilation error   c) Logic error   d) Runtime error     Answer: d) Runtime error    Q. 29 Which data structure stores elements in a first-in, first-out (FIFO) order?   a) Stack   b) Queue   c) Linked List   d) Array     Answer: b) Queue    Q. 30 What is the primary purpose of a function’s return statement in programming?   a) To terminate the program   b) To specify the input parameters   c) To indicate the function’s name   d) To return a value to the calling code     Answer: d) To return a value to the calling code    Q. 31 What is the term for the process of finding and fixing errors in a program?   a) Debugging   b) Compiling   c) Executing   d) Commenting     Answer: a) Debugging    Q. 32 In object-oriented programming, what is polymorphism?   a) The ability of an object to take on multiple forms   b) The process of creating new objects   c) The use of multiple inheritance   d) The process of encapsulating data     Answer: a) The ability of an object to take on multiple forms

Computer Programming-adv Q. 1 What is the primary purpose of a programming language?   a) To communicate with computers   b) To create beautiful websites   c) To design user interfaces   d) To play video games     Answer: a) To communicate with computers    Q. 2 Which of the following is NOT a high-level programming language?   a) Python   b) C++   c) Assembly   d) Java     Answer: c) Assembly    Q. 3 What is the role of a compiler in the software development process?   a) Executes the program   b) Converts source code to machine code   c) Debugs the code   d) Generates user documentation     Answer: b) Converts source code to machine code    Q. 4 Which programming paradigm focuses on breaking down a program into smaller, reusable functions or methods?   a) Object-Oriented Programming (OOP)   b) Procedural Programming   c) Functional Programming   d) Event-Driven Programming     Answer: b) Procedural Programming    Q. 5 What does “DRY” stand for in the context of programming best practices?   a) Don’t Repeat Yourself   b) Do Right Yourself   c) Do It Right, Yesterday   d) Develop, Run, Yield     Answer: a) Don’t Repeat Yourself    Q. 6 In Python, what is the keyword used to define a function?   a) def   b) function   c) func   d) define     Answer: a) def    Q. 7 Which data structure follows the “Last In, First Out” (LIFO) principle?   a) Queue   b) Stack   c) Array   d) Linked List     Answer: b) Stack    Q. 8 What is the purpose of conditional statements in programming?   a) To control the flow of a program   b) To create loops   c) To define data structures   d) To format output     Answer: a) To control the flow of a program    Q. 9 What is the term for a variable that can be accessed from any part of a program?   a) Local variable   b) Global variable   c) Static variable   d) Dynamic variable     Answer: b) Global variable    Q. 10 Which of the following is NOT a valid primitive data type in most programming languages?   a) Integer   b) Boolean   c) String   d) Loop     Answer: d) Loop    Q. 11 What is the purpose of a loop in programming?   a) To store data   b) To execute a block of code repeatedly   c) To declare variables   d) To display output     Answer: b) To execute a block of code repeatedly    Q. 12 In object-oriented programming, what is encapsulation?   a) The process of converting source code to machine code   b) The bundling of data and methods that operate on that data   c) The process of debugging code   d) The creation of user interfaces     Answer: b) The bundling of data and methods that operate on that data    Q. 13 What does the acronym “API” stand for in programming?   a) Advanced Programming Interface   b) Application Programming Interface   c) Automated Program Instruction   d) Application Program Installation     Answer: b) Application Programming Interface    Q. 14 In programming, what is an algorithm?   a) A type of data structure   b) A set of instructions for solving a specific problem   c) A programming language   d) A hardware component     Answer: b) A set of instructions for solving a specific problem    Q. 15 Which of the following is an example of a relational operator in programming?   a) if   b) +   c) >   d) for     Answer: c) >    Q. 16 What is the purpose of version control systems like Git?   a) To write code   b) To compile code

COMPUTER PROGRAMMING

Up to this sample question next l will post the purchased qustion

Curriculum Exit Exam for Computer Science System Development 0/4 Software Engineering  Text lesson Web Programming  Text lesson Fundamental of Database Systems  Text lesson Advance Database Systems  Text lesson Programming and Algorithms 0/4 Computer Networking and Security 0/3 Intelligent Systems 0/1 Computer Architecture and Operating Systems 0/2 Compiler and Complexity 0/2 Text lesson Software Engineering Q. 1 What is the primary goal of software analysis?   A) Identifying hardware requirements   B) Defining the user interface   C) Understanding and specifying user needs   D) Writing code directly     Correct Answer: c    Q. 2 Which phase of the software development life cycle involves transforming user requirements into a detailed software design?   A) Testing   B) Implementation   C) Analysis   D) Maintenance     Correct Answer: c    Q. 3 What is UML (Unified Modeling Language) primarily used for in software engineering?   A) Writing code   B) Debugging   C) Documentation and visual representation of software designs   D) Database management     Correct Answer: c    Q. 4 Which of the following is not a category of software testing?   A) Unit testing   B) Requirement testing   C) Integration testing   D) Agile testing     Correct Answer: d    Q. 5 Which software development methodology emphasizes incremental and iterative development, focusing on customer collaboration and responding to changes?   A) Waterfall   B) Agile   C) RAD (Rapid Application Development)   D) V-Model     Correct Answer: b    Q. 6 What is the primary purpose of a use case diagram in software design?   A) Documenting code structure   B) Representing interactions between objects   C) Visualizing user interactions with a system   D) Debugging errors     Correct Answer: c    Q. 7 In object-oriented programming, what is encapsulation?   A) Hiding implementation details and exposing only necessary information   B) Writing code without comments   C) Combining multiple objects into a single class   D) Using only public methods in a class     Correct Answer: a    Q. 8 Which design principle aims to ensure that a class should have only one reason to change?   A) Cohesion   B) Abstraction   C) Inheritance   D) Single Responsibility Principle     Correct Answer: d    Q. 9 Which software development pattern involves creating objects without specifying the exact class of object that will be created?   A) Factory Method   B) Singleton   C) Observer   D) Abstract Factory     Correct Answer: d    Q. 10 Which type of software testing checks whether the system works as expected when subjected to varying workloads or stress conditions?   A) Unit testing   B) Regression testing   C) Performance testing   D) Usability testing     Correct Answer: c

Curriculum Exit Exam for Computer Science Course progress:6% System Development 1/4 Software Engineering  Text lesson Web Programming  Text lesson Fundamental of Database Systems  Text lesson Advance Database Systems  Text lesson Programming and Algorithms 0/4 Computer Networking and Security 0/3 Intelligent Systems 0/1 Computer Architecture and Operating Systems 0/2 Compiler and Complexity 0/2 Text lesson Web Programming Q. 1 What does HTML stand for?   a) Hyperlink Text Markup Language   b) HyperText Markup Language   c) High-Level Text Markup Language   d) Hyperlink Transfer Markup Language     Correct Answer: b    Q. 2 Which programming language is commonly used for client-side web development?   a) Python   b) Java   c) JavaScript   d) C++     Correct Answer: c    Q. 3 What does CSS stand for?   a) Computer Style Sheet   b) Cascading Style Sheet   c) Creative Style Sheet   d) Client-Side Style Sheet     Correct Answer: b    Q. 4 Which of the following is NOT a valid HTTP status code?   a) 404 Not Found   b) 200 OK   c) 403 Forbidden   d) 500 OK     (Correct Answer: d    Q. 5 What is the purpose of a web server?   a) To store web content   b) To process user data   c) To serve web pages to clients   d) To design website layouts     Correct Answer: c    Q. 6 Which protocol is used for secure data transmission over the web?   a) HTTP   b) SMTP   c) HTTPS   d) FTP     Correct Answer: c    Q. 7 What is the primary function of a web browser?   a) To create web pages   b) To display web content   c) To host web applications   d) To manage databases     Correct Answer: b    Q. 8 What is the purpose of the <head> element in an HTML document?   a) It defines the main content of the page.   b) It contains metadata about the document   c) It defines the page’s structure.   d) It displays visible content on the page.     Correct Answer: b    Q. 9 Which of the following is NOT a valid HTML tag?   a) <header>   b) <section>   c) <div>   d) <paragraph>     Correct Answer: d    Q. 10 What does the acronym API stand for?   a) Application Programming Interface   b) Advanced Program Integration   c) Automated Programming Interface   d) Application Process Interaction     Correct Answer: a

Curriculum Exit Exam for Computer Science Course progress:12% System Development 2/4 Software Engineering  Text lesson Web Programming  Text lesson Fundamental of Database Systems  Text lesson Advance Database Systems  Text lesson Programming and Algorithms 0/4 Computer Networking and Security 0/3 Intelligent Systems 0/1 Computer Architecture and Operating Systems 0/2 Compiler and Complexity 0/2 Text lesson Fundamental of Database Systems Q. 1 What is the primary goal of database design?   a) Maximize storage efficiency   b) Minimize data redundancy   c) Optimize query performance   d) Ensure high availability     Correct Answer: b) Minimize data redundancy    Q. 2 Which of the following is not a characteristic of a well-designed database?   a) Data redundancy   b) Data consistency   c) Data integrity   d) Data security     Correct Answer: a) Data redundancy    Q. 3 What is a primary key in a relational database?   a) A unique identifier for a record in a table   b) A key used for encryption   c) A key that is primary to the database administrator   d) A secondary key for accessing data     Correct Answer: a) A unique identifier for a record in a table    Q. 4 In the context of database design, what does the term “normalization” refer to?   a) Simplifying data to reduce storage space   b) Structuring data to eliminate redundancy and improve integrity   c) Encrypting data to enhance security   d) Indexing data for faster retrieval     Correct Answer: b) Structuring data to eliminate redundancy and improve integrity    Q. 5 Which normal form eliminates partial dependencies?   a) First Normal Form (1NF)   b) Second Normal Form (2NF)   c) Third Normal Form (3NF)   d) Boyce-Codd Normal Form (BCNF)     Correct Answer: c) Third Normal Form (3NF)    Q. 6 What is an index in a database?   a) A list of all tables in the database   b) A unique identifier for each database record   c) A data structure that improves the speed of data retrieval   d) A type of constraint that enforces data integrity     Correct Answer: c) A data structure that improves the speed of data retrieval    Q. 7 Which database model organizes data into tables with rows and columns?   a) Relational database model   b) Hierarchical database model   c) Network database model   d) NoSQL database model     Correct Answer: a) Relational database model    Q. 8 What is the purpose of a foreign key in a relational database?   a) To ensure data is unique   b) To establish a link between two tables   c) To encrypt sensitive data   d) To improve query performance     Correct Answer: b) To establish a link between two tables    Q. 9 Which SQL statement is used to retrieve data from a database?   a) DELETE   b) UPDATE   c) SELECT   d) INSERT     Correct Answer: c) SELECT    Q. 10 Which database design concept allows a single piece of data to be stored in one place?   a) Data normalization   b) Data denormalization   c) Data encryption   d) Data indexing     Correct Answer: a) Data normalization

Curriculum Exit Exam for Computer Science Course progress:18% System Development 3/4 Software Engineering  Text lesson Web Programming  Text lesson Fundamental of Database Systems  Text lesson Advance Database Systems  Text lesson Programming and Algorithms 0/4 Computer Networking and Security 0/3 Intelligent Systems 0/1 Computer Architecture and Operating Systems 0/2 Compiler and Complexity 0/2 Text lesson Advance Database Systems Q. 1 Query optimization is primarily concerned with:   a) Designing the database schema.   b) Choosing the best way to execute a given query.   c) Increasing storage space.   d) Ensuring ACID properties.     Answer: b    Q. 2 Which phase of a DBMS translates a high-level query into a low-level query?   a) Normalization phase   b) Transaction phase   c) Query compilation phase   d) Disk scheduling phase     Answer: c    Q. 3 Which of the following is NOT an advantage of using an index?   a) Reduced search time   b) Sequential access   c) Efficient updates   d) Direct access     Answer: c    Q. 4 A heuristic optimization approach involves:   a) Exhaustive search   b) Rule-based transformation   c) Always yielding optimal results   d) Cost calculations for all possible plans     Answer: b    Q. 5 In the context of query optimization, what does the term “selectivity” mean?   a) The percentage of disk space used by the table.   b) The speed at which records are accessed.   c) The fraction of records that satisfy a condition.   d) The order in which records are stored.     Answer: c    Q. 6 The primary goal of the query optimizer is to:   a) Reduce response time   b) Reduce the total execution time   c) Reduce memory usage   d) Ensure all queries are answered     Answer: b    Q. 7 Which operation is used to combine two relations with a common attribute?   a) Union   b) Intersection   c) Join   d) Difference     Answer: c    Q. 8 Which of the following algorithms for JOIN operation is most memory efficient?   a) Nested-loop join   b) Merge join   c) Hash join   d) Indexed join     Answer: a    Q. 9 Bitmap indices are particularly beneficial for:   a) High cardinality attributes   b) Text searching   c) Low cardinality attributes   d) Primary key lookups     Answer: c    Q. 10 The ___ tree is especially suitable for range queries.   a) AVL   b) Hash   c) B+   d) Quad     Answer: c Note: To cover t