Practice IT DBMS Questions and Answers

• Which debugging tool allows a developer to pause program execution at specific lines, inspect variable values, and execute code step-by-step? 
• When debugging a recursive function that processes a `Tree` data structure, what is a common strategy to identify infinite recursion or incorrect base case...
• A software defect that causes a program to produce incorrect output without crashing or displaying an error message is typically classified as a: 
• Consider the following pseudo-code:   ```     function calculate(arr):         sum = 0         for i from 0 to length(arr) - 1:           ...
• Given the following Python-like code snippet:     ```python     class Counter:         def __init__(self):             self.count = 0     ...
• What will be the value of `x` after the following pseudo-code execution?  ```     x = 0     data = [10, 20, 30]     for item in data:         if...
• Consider a `Stack` data structure implemented with `push` and `pop` operations. What is the final state of the stack after the following sequence of operat...
• Examine the following Java-like code:      ```java     class Parent {         String name = "Parent";         public void display() {      ...
• What is the output of the following pseudo-code?   ```     count = 0     for i from 1 to 3:         for j from 1 to i:             count = ...
• Given a `Queue` data structure with `enqueue` and `dequeue` operations. What is the element returned by the last `dequeue` operation in the following seque...
• In an Object-Oriented program, which control flow construct is primarily used to handle unexpected events or errors that occur during program execution, su...
• Which of the following best describes the control flow when a method in a subclass overrides a method in its superclass, and an object of the subclass is r...
• Consider a `LinkedList` data structure. Which control flow statement is most appropriate for iterating through all elements of the list from head to tail?�...
• In a program that manages a collection of `Employee` objects, each with a `salary` attribute, which control flow mechanism would be most efficient to find ...
• When implementing a `Graph` traversal algorithm like Depth-First Search (DFS) recursively, what is the primary control flow mechanism that manages the orde...
• Which OOP concept directly influences control flow by allowing different implementations of a method to be called based on the type of the object at runtim...
• A program needs to process elements from a `Queue` until it becomes empty. Which control flow structure is most suitable for this task? 
• What will be the output of the following Python code: a=[1,2,3,4,5,6] print(a[-1],a[-1:],a[:-1])
• A company needs to schedule a maximum number of meetings in a single conference room. Each meeting `i` has a start time `s_i` and an finish time `f_i`. Onc...
• Consider the following C++-like pseudo-code for a binary tree traversal:     ```cpp     struct Node {         int data;         Node left;   �...
• Consider the following Java-like pseudo-code for inserting a node into a Binary Search Tree (BST):     ```java     class Node {         int data; �...
• Given a binary tree, a "zigzag" level order traversal prints the nodes level by level, but alternating the order of nodes from left-to-right and right-to-l...
• Which database model represents data in a tree-like structure, where each child record has only one parent?
• In the Relational Database Model, data is organized into:
• Which of the following is a significant disadvantage of using a traditional file system compared to an RDBMS?
• An RDBMS provides mechanisms for data integrity, such as primary keys and foreign keys, which are generally lacking in:
• A relation is in 1NF (First Normal Form) if:
• Which normal form eliminates transitive dependencies?
• A table is in 2NF (Second Normal Form) if it is in 1NF and:
• A column or set of columns that uniquely identifies each row in a table is called a:
• Which constraint ensures that a column contains only unique values, but allows NULL values?
• A `FOREIGN KEY` constraint is used to:
• Which property of a transaction ensures that either all operations within the transaction are completed successfully, or none of them are?
• The "Dirty Read" problem occurs when:
• Which of the following is a common technique for concurrency control in databases?
• In an E-R Diagram, entities are typically represented by:
• A "diamond" shape in an E-R Diagram typically represents a:
• In the context of computer networks, what is the primary function of a router?
• An SQL `VIEW` is a:
• A PL/SQL `TRIGGER` is a stored program that automatically executes in response to: