
INFOSYS POWER PREPARATION
RDBMS
1.
What is database?
2. What
is DBMS?
3.
What is a Database system?
4. Advantages
of DBMS?
5. Disadvantage
in File Processing System?
6. Describe
the three levels of data abstraction?
7. Define
the "integrity rules"
8. What
is extension and intension?
9. What
is System R? What are its two major subsystems?
10. How is the
data structure of System R different from
the relational structure?
11. What is Data Independence?
12. What is
a view? How it is related to data independence?
13. What is Data
Model?
14. What is E-R model?
15. What is Object
Oriented model?
16. What is an Entity?
17. What is an Entity
type?
18. What is an Entity
set?
19. What is an Extension
of entity type?
20. What is Weak
Entity set?
21. What is an attribute?
22. What is a Relation
Schema and a Relation?
23. What is degree
of a Relation?
24. What is Relationship?
25. What is Relationship
set?
26. What is Relationship
type?
27. What is degree
of Relationship type?
25. What is DDL (Data
Definition Language)?
26. What is VDL (View
Definition Language)?
27. What is SDL (Storage
Definition Language)?
28. What is Data
Storage - Definition Language?
29. What is DML (Data
Manipulation Language)?
31. What is DML Compiler?
32. What is Query
evaluation engine?
33. What is DDL Interpreter?
34. What is Record-at-a-time?
35. What is Set-at-a-time
or Set-oriented?
36. What is Relational
Algebra?
37. What is Relational
Calculus?
38. How does Tuple-oriented
relational calculus differ from domain-orientedrelational
calculus
39. What is normalization?
40. What is Functional
Dependency?
41. When is a functional
dependency F said to be minimal?
42. What is Multivalued
dependency?
43. What is Lossless
join property?
44. What is 1 NF
(Normal Form)?
45. What is Fully Functional
dependency?
46. What is 2NF?
47. What is 3NF?
48. What is BCNF
(Boyce-Codd Normal Form)?
49. What is 4NF?
50. What is 5NF?
51. What is Domain-Key
Normal Form?
52. What are partial,
alternate, artificial, compound and natural
key?
53. What is indexing
and what are the different kinds of indexing?
54. What is system
catalog or catalog relation? How is better
known as?
55. What is meant
by query optimization?
56. What is join
dependency and inclusion dependency?
57. What is durability
in DBMS?
58. What do you mean
by atomicity and aggregation?
59. What is a Phantom
Deadlock?
60. What is a checkpoint
and When does it occur?
61. What are the
different phases of transaction?
62. What do you mean
by flat file database?
63. What is "transparent
DBMS"?
64. Brief theory
of Network, Hierarchical schemas and their
properties
65. What is a query?
66. What do you mean
by Correlated subquery?
67. What are the
primitive operations common to all record
management systems?
68. Name the buffer
in which all the commands that are typed in
are stored
69. What are the
unary operations in Relational Algebra?
70. Are the resulting
relations of PRODUCT and JOIN operation the
same?
71. What is RDBMS
KERNEL?
72. Name the sub-systems
of a RDBMS
73. Which part of
the RDBMS takes care of the data dictionary?
How
74. What is the job
of the information stored in data-dictionary?
75. How do you communicate
with an RDBMS?
76. Define SQL and
state the differences between SQL and other
conventional programming Languages
77. Name the three
major set of files on disk that compose a
database in Oracle
78. What is an Oracle
Instance?
79. What are the
four Oracle system processes that must always
be up and running for the database to be useable
80. What are database
files, control files and log files. How many
of these files should a database have at least?
Why?
81. What is ROWID?
82. What is Oracle Block?
Can two Oracle Blocks have the same address?
83. What is database
Trigger?
84. Name two utilities that
Oracle provides, which are use for backup
and recovery.
85. What are stored-procedures?
And what are the advantages of using them.
86. What is Storage
Manager?
87. What is Buffer
Manager?
88. What is Transaction
Manager?
89. What is File
Manager?
90. What is Authorization
and Integrity manager?
91. What are stand-alone
procedures?
92. What are cursors
give different types of cursors.
93. What are Armstrong rules?
94. What do you understand
by dependency preservation?
95. What are the
different types of JOIN operations?