BABA BANDA SINGH BAHADUR ENGINEERING COLLEGE FATEHGARH SAHIB ONLINE QUESTION BANK Branch: CSE/IT Semester: 7th Subject: RDBMS II Subject Code: CS-302 1. What are the structures of selection? Explain…. 2. What is a committing of transaction? 3. What do you call the overall design of a database? 4. What is database integrity? 5. What is the syntax for creation of a trigger? 6. What are the datatypes of oracle? 7. What is the command of role back of database? 8. What is a foreign key? 9. Can a datafield have null value in oracle? 10. What is the difference between before and after trigger? 11. Why SQL is a database query language? 12. What is entity integrity? 13. What is the difference between a primary and secondary key? 14. Explain the relational algebra operator (difference) in brief? t/tE rell ^ E s ( s E rel2 ^ (s.c =+B)) 15. Define DDL & DML? 16. Define binary locks 17. Define Indexing and its types? 18. What are triggers? 19. Define views? 20. Define Data Warehousing? 21. What do you understand by attribute and key? 22. What is Equi-Join 23. What do u understand by relationship 24. Give example using SQL for the retrieval with a sub query with same table involved 25. What is a transaction 26. How rollback of transaction take place 27. Give example using SQL for the retrieval with a sub query with interblock reference 28. What are the security needs of database 29. what is locking feature of a database 30. What is trigger? 31. Define 3rd Normal Form 32. What is query optimization? 33. Why concurrency control is needed. 34. What is meant by Timestamp ordering 35. Give example using SQL For the retrieval using union 36. Give example Using SQL For the retrieval using any 37. What are the log files 38. What are the general files 39. What is the candidate key 40. What are the primary and secondary keys 41. What is the difference between a schema and a sub schema 42. What is data independence 43. What are logical and physical database 44. What do u mean understand by transaction committing 45. What is the difference between relation algebra and relation calculus 46. What do u mean by a relation 47. What are triggers. What are their different types 48. Name the different levels is three schema architecture 49. Differentiate data types available in SQL. Short Answer Question 50. What is the need for normalization of data? 51. What are the various laws involving selection? 52. What a trigger? How can it be used to enforce integral constraints? 53. What is lossless join decomposition? 54. Show that 4nf implies 3nf 55. Explain the role of DBA in a database environment? 56. What are the responsibilities of DBA? 57. What is the difference between second and fourth normal forms? Explain. 58. Discuss the difference integrity rules used in RDBMS. 59. How can the query optimization carried out? Explain. 60. Discuss the purpose of distributed database system and their demerits. 61. What is meant by Data Independence? How can it be achieved> 62. Consider the database of a department stored as follow: a) Each employee is represented the data about an employee are his emp no, name, address, deptt. b) Each deptt is represented the data about department are its name, Employees, manager and items sold. c) Each item sold is represented the data about item are its name, manufacturer, price, model and internal itemno. d) Each manufacturer is represented the data about manufacturer are its name, address, item supplied, price. Give an ER diagram for this database. 63. What is usage of triggers in oracle and how are they stored? 64. Explain the method to create a table and modification in oracle. 65. What are the various datatypes of field can be used in oracle. Explain with example. 66. What are the salient features of PL/SQL. 67. Give the following relational scheme: Enroll (S#,C#section)S# represent the student number Teach (prof,S#section) c# represent course number Advice(prof,S#)prof is a thesis advisor of S# Pre Req(C#,pre req#) Grade(S#,C#,grade,year)…. 68. What are various objectives of a database system? 69. Explain architecture of distributed system. 70. Explain background processes of an ORACLE SERVER. 71. Explain concept of recovery and security. 72. Describe E-R model with the help of suitable diagram. 73. What are various states of transaction? Write in brief about each state. 74. What are different types of keys? Explain difference between them. 75. What is B-tree? Explain structure of B-tree. 76. What is hashing? Give description about various types of hashing. 77. What do you understand by primary index? How it is useful in the file Organization. 78. How DDL work for database system? Describe its interaction with DML. 79. What is concurrency control? How it is achieved in database system? 80. Briefly describe Codd’s Rules. 81. Discuss Oracle Server Architectural components in brief. 82. What are triggers? Explain in brief. 83. What are various types of control structures? Give brief explanation. Long Answer Question 84. Write a note on: a) Conceptual Schema b). Functional Dependency c). Embedded SQL. 85. What are the first three normalization relational database models? 86. Explain three schema architecture of a database system. Describe function of each schema. 87. What are security needs of database? Discuss this with respect to ORACLE in NETWORK environment. 88. What is need of normalization of data? What are techniques for normalization in a Relational database model? 89. Explain architecture and working of an ORACLE server. 90. What do you mean by entity, entity set, entity type, attributes, and relationship? Explain in detail. 91. (a). What do you mean by index? What are its types? How it is useful in database system. (b). Differentiate between PL SQL and SQL *plus. 92. What is meant by relational algebra and calculus? Discuss the operation under the relation algebra. Consider the following name database employee (EMP-name, street, city) Works (EMP-name, salary) company (company-name, city) managers (EMP-name, manager-name). Give an expression in the relational algebra, tuple calculus and SQL for each of the following queries. (a). Find all employee in the DB who live in the same cities and on the same street as do their managers. (b). Assume that wipro is located in several cities. Find all companies located in every city where wipro is located. 93. Explain normalization and functional dependency with examples. 94. Give the state transaction diagram illustrating the state of transaction execution. Also define commit point and rollback. 95. Write the difference between of the following: (a). Procedural and Non-Procedural Languages. (b). Logical data independence and physical data independence. (c). Database schema database state. 96. What is Data Model? Explain how the relational model is better than the earlier models? 97. Write a short note on a) DELPHI b) SQL, SQL+ and T-SQL 98. What are rule based and cost based indexes? Describe difference between them/. 99. What are Views ? What is need to create Views? How are these created? 100. What do you understand by cursor? Explain Implicit and Explicit cursors. 101. Define Boyce-Codd normal form. How is It different from 3NF? 102. Explain functions, procedures and cursors in detail in PL/SQL? 103. Design a relation database to the following E-R elements of a part of a Banking Enterprise:- Account Number, Balance, Account Branch, Account, Branch, Branch Name, Branch City, Assets. 104.What do you understand by a Join? How are these used ni Database System. 105. Explain the architecture of RDBMS in Detail. Also explain function of each part.