PDA

View Full Version : DBMS


  1. How can you define a data base
  2. What is the meaning of DBMS
  3. What is meant by a database system
  4. What are the advantages of DBMS
  5. What are the three levels of data
  6. Disadvantage in File Processing System
  7. What is the main use of B & B+ trees in
  8. Explain the difference between a database
  9. Describe the advantages and disadvanta
  10. Explain how a database could be recovered
  11. Why is it important to write to the log
  12. What is data model
  13. What is an entity
  14. What is an entity set
  15. What are the different types of entities
  16. What is a relation
  17. What is a relationship set
  18. What is an Attribute
  19. What is degree of a Relation
  20. What is meant by relation schema
  21. What is the meaning of domain of
  22. What is the meaning of Relationship
  23. What is Relationship type
  24. What is degree of Relationship type
  25. What are the different types of
  26. What is a Weak entity set
  27. Can you define the existence
  28. What are the super key and key
  29. What is an Aggregation
  30. What is an Entity
  31. What is an Entity type
  32. What is an Extension of entity type
  33. What is meant by entity integrity
  34. Describe referential integrity
  35. What are the some utilities of E-R Model
  36. What are the tools to create E-R Model
  37. What are the some design issues of E-R
  38. What is Object Oriented model
  39. What is a recursive relationship
  40. What is a key
  41. What is a Super key
  42. What is a Candidate key
  43. What is a Primary Key
  44. What is the meaning of the functional
  45. When is a functional dependency F said
  46. What is Multivalued dependency
  47. What is Normalization
  48. What is the use of the Normalization
  49. What are the different normal forms
  50. What is Fully Functional dependency
  51. Explain st Normal Form
  52. Explain nd Normal Form
  53. Explain rd Normal Form
  54. Explain Boyce-Codd Normal Form(BCNF)
  55. Explain th Normal Form
  56. What is meant by Atomicity
  57. Explain Multi-valued Dependency
  58. Explain Lossless-join dependency
  59. What are aggregate functions
  60. What is the difference between Oracle
  61. What is the difference between static
  62. When using count(distinct) it is better to
  63. What is the difference between the
  64. In the WHERE clause what is BETWEEN
  65. What is 'LIKE' used for in WHERE clause
  66. What are the wildcard characters
  67. How would you find out the total number
  68. How do you eliminate duplicate values
  69. How do you find the maximum value
  70. My SQL statement SELECT AVG(SALARY)
  71. How do you retrieve the first characters
  72. How do you concatenate the FIRSTNAME and LASTNAME from EMP
  73. What is the use of VALUE function
  74. How do you select a row using indexes
  75. When do you use a LIKE statement
  76. What is meant by null
  77. What is the meaning of underscore
  78. What do you accomplish by GROUP BY
  79. Define rollback and roll forward
  80. Which system table contains information
  81. What are correlated sub queries
  82. What is the difference between the
  83. How to copy SQL table
  84. What is meant by Table
  85. Explain Table
  86. What is the syntax for a CREATE
  87. Can one add columns to a table after
  88. Where in a table are added columns located
  89. After a table is defined, can columns
  90. What authority is required to create a
  91. What is a results table
  92. What is minimum authority required for
  93. Explain index in SQL
  94. What alias can do
  95. What synonym can do in sql
  96. What are the column name qualifiers
  97. What is a correlation name
  98. What is meant by embedded SQL
  99. How would you retrieve rows from a
  100. Why SELECT * is not preferred in
  101. What is a subselect
  102. What is the difference between
  103. What keyword does an SQL SELECT
  104. Describe the elements of the SELECT
  105. Explain the use of the WHERE clause
  106. Apart from cursor, what other ways are
  107. Explain ORDER BY clause
  108. What are some SQL aggregates
  109. What will GRANT option do
  110. What does the term "grant privileges"
  111. Explain Alter and Drop statements can
  112. What is meant by Data Definition
  113. How to find out the database name f
  114. How is the SUBSTR keyword used in SQL
  115. Explain the EXPLAIN statement
  116. What is a Cartesian product
  117. What is the difference between the
  118. Define the "integrity rules
  119. What is the difference between IN
  120. What is extension and intension
  121. What is System R? What are its two
  122. How is the data structure of System R
  123. What is Data Independence
  124. What is a view
  125. What is Data Storage - Definition Language
  126. What is DML (Data Manipulation Language)
  127. What is VDL (View Definition Language)
  128. What is DML Compiler
  129. What is Query evaluation engine
  130. What is DDL Interpreter
  131. What is the restriction on using UNION i
  132. Explain Data Manipulation Language
  133. Select name from employee where
  134. What is Record-at-a-time
  135. What is Set-at-a-time or Set-oriented
  136. What is RDBMS
  137. What is the difference b/w the DBMS
  138. What is Relational Algebra
  139. What is Relational Calculus
  140. What is meant by tuple relational calculu
  141. Explain Domain relational calculus
  142. What are the different types of author
  143. How does Tuple-oriented relational
  144. What is an object-oriented analysis
  145. What is an object
  146. What is class
  147. Explain Abstraction
  148. Explain Encapsulatio
  149. Explain Modularity
  150. Explain the difference between an
  151. What is lock granularity
  152. What is Transaction
  153. In general, how should the boundaries
  154. Explain the meaning of the expression
  155. What is meant by Consistency
  156. What is meant by Isolation
  157. What is meant by Durability
  158. Explain schedule
  159. What are the different types of schedule
  160. What is meant by serial schedule
  161. What is meant by non-serial schedule
  162. What is meant by serializability
  163. What are the different types o
  164. What is meant by Conflict serializability
  165. What is meant by View serializability
  166. What are the different Concurrency
  167. Explain the necessity of definin
  168. What happens when you say OPEN
  169. What is a cursor
  170. How do you specify and use a cursor in
  171. What is a cursor
  172. Explain an outer join
  173. Compare a subselect to a join
  174. When is it necessary to create a table
  175. What techniques are used to retrieve
  176. What is the basic difference between a j
  177. What are the different types of joints
  178. What is extension and intension
  179. What is degree of Relationship type
  180. What is Data Storage - Definition
  181. What is VDL (View Definition Language
  182. What is Fully Functional dependency
  183. In general, how should the boundaries of
  184. Explain the necessity of defining
  185. Explain STOGROUP
  186. What is a
  187. specify UNION to eliminate the duplicate
  188. Is BETWEEN inclusive of the range
  189. How do you specify and use a cursor
  190. Is DECLARE CURSOR executable
  191. Can you have more than one cursor
  192. When you COMMIT, is the cursor closed
  193. Can we use MAX on a CHAR column
  194. SQL statement SELECT AVG(SALARY)
  195. How do you retrieve the first
  196. What is UNION,UNION ALL
  197. How is the SUBSTR keyword used in SQL
  198. What is an alias and how does it differ
  199. What is meant by Atomicity
  200. DBMs