baba banda singh bahadur engineering college - DOC - DOC

Document Sample
baba banda singh bahadur engineering college - DOC - DOC Powered By Docstoc
                                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
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
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
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#)
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
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
    (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
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
       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.

Shared By: