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?