Practice IT DBMS Questions and Answers

• During transaction before commit which of the following statements is done automatically in case of shutdown?
• Which of the following matches the definition given below: It is an artificial key that aims to uniquely identify each record.
• Which of the following commands are used to put a restriction on the number of rows returned from a query?
• Which of the following operators is used to compare a value to a list of literal values that have been specified?
• What is a table joined with itself called?
• What does the ‘’ element in HTML5 allow you to do?
• Which stage involves evaluating the project's practicality, cost, and resources before proceeding further?  
• The 'thrashing' in an operating system is related to:
• In paging, the page size is defined by:
• What is a page fault?
• Which system call is used to create a new process in UNIX/Linux?
• What is the maximum number of processes that can be in the Ready state?
• Which of the following is not part of the process control block (PCB)?
• Which interrupt is generated by software?
• What is context switching?
• A system is in a safe state when:
• Which of the following illustrates an advantage of DBMS over traditional file systems?
• A relation is in 2NF if:
• Which join should be used when you want to list all customers and any orders they may have placed, including customers who haven’t placed any orders?
• Which key uniquely identifies a record in a table?
• What does normalization in DBMS achieve?
• Which of the following is a DML command?
• Which type of join returns rows when there is a match in both tables?
• ACID properties in DBMS ensure:
• Which of the following is a non-relational database?
• A view in SQL is:
• Which of these ensures referential integrity?
• Which of the following is NOT a type of database model?
• Which normal form removes transitive dependency?
• Which operation is NOT part of relational algebra?
• Indexing in DBMS improves:
• Deadlock occurs when:
• Which isolation level allows dirty reads?
• Which concurrency anomaly is specific to phantom reads?
• Multiversion Concurrency Control (MVCC) ensures:
• Bitmap indexes are most efficient when:
• Shadow paging in recovery eliminates the need for:
• Which deadlock prevention scheme allows older transactions to preempt younger ones?
• Query optimization heuristics often include:
• Distributed transactions typically use which protocol for atomicity?