Database Management System MCQs

Q2. The refinement from an initial entity set into successive levels of entity subgroupings represents a ________ design process in which distinctions are made explicit.

Q3. DBMS periodically suspends all processing and synchronizes its files and journals through the use of

Q4. Which operation are allowed in a join view:

Q5. A hash function must meet ________ criteria.

Q6. Indices whose search key specifies an order different from the sequential order of the file are called ___________ indices.

Q7. The function that an entity plays in a relationship is called that entity’s _____________

Q8. Subqueries cannot:

Q9. The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into employee1 (ID, name) employee2 (name, street, city, salary)

Q10. Inst_dept (ID, name, salary, dept name, building, budget) is decomposed into instructor (ID, name, dept name, salary) department (dept name, building, budget)

Q11. If an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called _____ is needed.

Q12. In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?

Q13. A dependency exist between two columns when

Q14. The simplest way of transferring control is for the old primary to receive __________ from the old backup site.

Q15. Which is the subset of SQL commands used to manipulate Oracle Database Structures, including tables?

Q16. Which of the following are the process of selecting the data storage and data access characteristics of the database?

Q17. A transaction is delimited by statements (or function calls) of the form __________

Q18. Which of the following queries are legal?

Q19. The Oracle RDBMS uses the ____ statement to declare a new transaction start and its properties.

Q20. Designers use which of the following to tune the performance of systems to support time-critical operations?