749+ questions with answers
Q1. A condition is referred to as __________
Q2. A deadlock exists in the system if and only if the wait-for graph contains a ___________
Q3. Which of the following is a fundamental operation in relational algebra?
Q4. Remote backup system must be _________ with the primary site.
Q5. Which among the following are the functions that any system with a user interface must provide?
Q6. Indices whose search key specifies an order different from the sequential order of the file are called ___________ indices.
Q7. The ORDER BY clause can only be used in
Q8. ’_ _ _ ’ matches any string of ______ three characters. ’_ _ _ %’ matches any string of at ______ three characters.
Q9. Which of the following hardware component is the most important to the operation of a database management system?
Q10. The __________________ contains a list of blocks that have been updated in the database buffer.
Q11. __________ scheme that records only information about dirty pages and associated information and does not even require of writing dirty pages to disk.
Q12. Let us consider phone_number ,which can take single or several values . Treating phone_numberas an _________ permits instructors to have several phone numbers (including zero) associated with them.
Q13. __________ is increasingly being used in server systems to improve performance by caching frequently used data, since it provides faster access than disk, with larger storage capacity than main memory.
Q14. In the client / server model, the database:
Q15. A graphical or text depiction of the relationship between different groups of content on a website is a:
Q16. Which of the following is used to get back all the transactions back after rollback?
Q17. In a _______ clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.
Q18. The unit of storage that can store one are more records in a hash file organization are
Q19. Many applications use _________________ where two independent factors are used to identify a user.
Q20. The _______ is that part of main memory available for storage of copies of disk blocks.
Well done!