Practice IT DBMS Questions and Answers
- 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...
- What does ACID stand for in database transactions?
- Which of the following is an example of a NoSQL database?
- Which of the following correctly describes a 'primary key' in a relational database?
- In database management, what is a 'foreign key'?
- What is 'normalization' in database design?
- What is the purpose of 'indexing' in a database?
- What is a 'transaction' in DBMS and what does 'COMMIT' do?
- What is an 'ER Diagram' (Entity-Relationship Diagram) used for in database design?
- What is 'query optimization' in DBMS?
- In SQL, which clause is used to filter groups of rows after aggregate functions (such as SUM, COUNT, or AVG) have been applied?
- Which normal form in relational database design specifically eliminates transitive dependency of non-key attributes on the primary key?
- Which key, selected from among the candidate keys of a table, is used to uniquely identify each record and is automatically enforced by the DBMS to disallo...
- Which SQL command permanently removes a table's entire structure along with all of its data from the database?
- What does the acronym ACID stand for in the context of database transaction management?
- Which type of SQL JOIN returns all rows from both tables involved, placing NULLs in columns where there is no matching row on the other side?
- What does the 'principle of least privilege' mean in information security?
- Which SQL keyword is used to combine the result sets of two or more SELECT statements, automatically removing duplicate rows from the combined result?
- What is a 'foreign key' in a relational database?
- What does the SQL COMMIT statement do?
- A table Orders(order_id, customer_id, order_date, amount) needs a query that returns each order alongside a running cumulative total of that customer's ord...
- In database normalization theory, which anomaly specifically refers to the unintended loss of information when a record is removed, because that record hap...
- What is the key behavioral difference between the SQL DELETE and TRUNCATE commands when used to remove all rows from a table?
- A relation R(A, B, C, D, E) has the functional dependencies ABβC, CβD, DβE, and EβA. Assuming AB is the only candidate key of R, which normal form ...
- Which transaction isolation level permits non-repeatable reads and phantom reads while still guaranteeing that dirty reads never occur?
- Given a table Employees(EmpID, ManagerID, Salary), which SQL statement correctly returns the EmpID of every employee who earns strictly more than their dir...
- Given a table Orders(OrderID, CustomerID, Amount), which SQL statement correctly returns the CustomerID of every customer who has placed more than 3 orders...
- In a database with a foreign key constraint defined using "ON DELETE CASCADE," what happens when a row in the parent (referenced) table is deleted?
More Topics
- Algorithms Questions
- Analog and Digital Communication Questions
- Artificial Intelligence & Machine Language Questions
- Basics of Computers Questions
- Big Data Analytics Questions
- C Programming Questions
- C++ Questions
- Cloud Computing Questions
- Compiler Design Questions
- Computer Architecture and Design Questions
- Cyber Security Questions
- Data Analytics Languages Questions
- Data Structure Questions
- Data Warehousing Questions
- Digital Logic Questions
- Emerging Technologies Questions
- IOT and mobile Computing Questions
- IT Networking Questions
- IT Operating System Questions
- Java Language Questions
- Machine Learning Questions
- Memory Management Questions
- Microsoft Office Questions
- Miscellaneous Questions Questions
- Network Layer and IP Protocol Questions
- Numerical and Statistical Computing Questions
- Object Oriented Programming Questions
- OOPS Concepts Questions
- Previous Year Questions Questions
- Programming Concept Questions
- Python Questions
- Shell Scripting Questions
- Software Engineering and Web Technology Questions
- SQL Questions
- String Manipulation Questions
- TCP IP and OSI Questions