Practice IT Networking Questions and Answers

• Which computer architecture uses a single bus to connect the CPU, memory, and peripherals?
• What is the primary purpose of performing backups in an operating system?
• Which type of backup includes all selected files and marks them as backed up?
• What is the advantage of using incremental backups over full backups?
• In the context of backups, what is a retention policy?
• Which backup strategy involves rotating backup media to ensure data redundancy and off-site storage?
• What is the purpose of a recovery point objective (RPO) in backup planning?
• Which type of backup includes all files that have changed since the last full backup?
• Which backup storage method involves backing up data to a remote data center over a network?
• What is the purpose of a backup verification process?
• Which recovery strategy involves reinstalling the operating system and applications, followed by restoring user data from backups?
• What is the primary function of the Relational Database Management System (RDBMS) architecture?
• Which component of RDBMS is responsible for processing SQL queries and managing database interactions?
• What is the role of the Transaction Manager in RDBMS architecture?
• Which part of the RDBMS architecture is responsible for maintaining a physical copy of the database on disk?
• In RDBMS, what is the purpose of the Data Dictionary?
• What does the Query Optimizer do in RDBMS architecture?
• Which part of RDBMS handles concurrency control to ensure multiple transactions operate concurrently without conflicts?
• Which component of RDBMS allows users and applications to interact with the database through SQL queries?
• What is the purpose of the Index Manager in RDBMS architecture?
• In RDBMS architecture, what is the role of the Buffer Manager?
• What is the scope of a variable in programming?
• Which type of variable has the widest scope and can be accessed from any part of the program?
• In which part of a function are local variables typically declared?
• What happens to the memory allocated to a local variable when the function exits?
• In object-oriented programming, what is the scope of an instance variable?
• What is the scope of a variable declared as "static" inside a function?
• What is the scope of a variable declared inside a block of code (e.g., within curly braces)?
• In which type of scope do variables declared in a function have priority over variables declared in the surrounding program?
• Which programming concept allows a variable name to refer to different entities based on its location in code?
• What is the scope of a parameter in a function?
• What will be the output of the following code snippet? int num = 10; int *ptr = # printf("%d", *ptr);
• In SQL, which keyword is used to retrieve data from a database?
• Which clause is used to filter rows in the result set based on a specific condition in SQL?
• What is the purpose of the "ORDER BY" clause in an SQL query?
• Which SQL keyword is used to add new rows to a table?
• What is the purpose of the "GROUP BY" clause in an SQL query?
• Which SQL clause is used to specify conditions for multiple tables when joining them together?
• Which SQL keyword is used to modify existing rows in a table?
• What is the purpose of the "HAVING" clause in an SQL query?