|
Some Unsolved Important
Questions:
42. what is difference between RDBMS and ADBMS
43. What is a thin driver used for SQL Server for Java
44. What is the difference between Primary Key and Aggregate Key What is
the difference between varchar and varchar2?
45. In a distributed database system can we access two queries
simultaneously ? give reason.
46. how many type of Implementation methodologies ?
47. what is topdown and bottomup logical database?
48. What is Sub-schema?
49. What parameters define RDBMS?
50. what is the difference between IS and AS keyword in procedures.
51 What is the syntax for creation of a trigger?
52. What are the datatypes of oracle?
53.What is the command of role back of database?
54 What is a foreign key?
55 Can a datafield have null value in oracle?
56 What is the difference between before and after trigger?
57.Why SQL is a database query language?
58 What is entity integrity?
59 Define DDL & DML?
60 Define binary locks
61 Define Indexing and its types?
62 What are triggers?
63 Define views?
64 Define Data Warehousing?
65 What do you understand by attribute and key?
66 What is Equi-Join
67 What do u understand by relationship
68 Give example using SQL for the retrieval with a sub query with same
table involved.
69 What is a transaction
70 How rollback of transaction take place
71 What are the security needs of database
72 what is locking feature of a database
73 What is trigger?
74 Define 3rd Normal Form
75 What is query optimization?
76 Why concurrency control is needed.
77 What is meant by Timestamp ordering
78 Give example using SQL For the retrieval using union
79 Give example Using SQL For the retrieval using any
80 What are the log files
81 What are the general files
82 What is the candidate key
83 What is the difference between a schema and a sub schema
84 What is data independence
85 What are logical and physical database
86 What do u mean understand by transaction committing
87 What is the difference between relation algebra and relation calculus
88 What do u mean by a relation
89 What are triggers. What are their different types
90 Name the different levels is three schema architecture
91 Differentiate data types available in SQL.
92 What is lossless join decomposition?
93 Show that 4nf implies 3nf
94 Explain the role of DBA in a database environment?
95 What are the responsibilities of DBA?
96 What is the difference between second and fourth normal forms?
Explain.
97 Discuss the difference integrity rules used in RDBMS.
98 How can the query optimization carried out? Explain.
99 Discuss the purpose of distributed database system and their
demerits.
100 What is meant by Data Independence? How can it be achieved>
101 Consider the database of a department stored as follow:
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.
102 What is usage of triggers in oracle and how are they stored?
103 Explain the method to create a table and modification in oracle.
104 What are the various datatypes of field can be used in oracle.
Explain with
example.
105 What are the salient features of PL/SQL.
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)….
106 What are various objectives of a database system?
107 Explain architecture of distributed system.
108 Explain background processes of an ORACLE SERVER.
109 Explain concept of recovery and security.
110 Describe E-R model with the help of suitable diagram.
111 What are various states of transaction? Write in brief about each
state.
112 What are different types of keys? Explain difference between them.
113 What is B-tree? Explain structure of B-tree.
114 What is hashing? Give description about various types of hashing.
115 What do you understand by primary index? How it is useful in the
file
Organization.
116 How DDL work for database system? Describe its interaction with DML.
117 What is concurrency control? How it is achieved in database system?
118 Briefly describe Codd’s Rules.
119 Discuss Oracle Server Architectural components in brief.
120 What are triggers? Explain in brief.
121 What are various types of control structures? Give brief
explanation.
122 Write a note on:
a) Conceptual Schema
b). Functional Dependency
c). Embedded SQL.
123 What are the first three normalization relational database models?
124 Explain three schema architecture of a database system. Describe
function of
each schema.
125 What are security needs of database? Discuss this with respect to
ORACLE in
NETWORK environment.
126 What is need of normalization of data? What are techniques for
normalization in a Relational database model?
127. Explain architecture and working of an ORACLE server.
128 What do you mean by entity, entity set, entity type, attributes, and
relationship?
Explain in detail.
129 What do you mean by index? What are its types? How it is useful in
database system.
130 Differentiate between PL SQL and SQL *plus.
131. what is codd's rule?
|
