DBMS Basics technical interview question
31. What is a SQL view? Briefly explain the use of views. A SQL view is a virtual table built […]
31. What is a SQL view? Briefly explain the use of views. A SQL view is a virtual table built […]
61. Why is XML a better markup language than HTML? XML is a better markup language than HTML, primarily because
55. What triggers does SQL Server 2000 support? SQL Server 2000 supports INSTEAD OF and AFTER triggers only. There is
49. Explain the three levels of transaction isolation supported by Oracle. Oracle supports read committed, serializable, and read-only transaction isolation
43. What is deadlock? How can it be avoided? How can it be resolved once it occurs? Deadlock occurs when
37. What is the difference between a correlated subquery and a regular subquery? A correlated subquery appears deceptively similar to
31. What is a SQL view? Briefly explain the use of views. A SQL view is a virtual table built
25. What is a recursive relationship? Give an example not used in the text. A recursive relationship is a relationship
19. Why is the multivalue, multicolumn problem another form of the multivalued dependency problem? Both problems try to store multiple
13. What is a foreign key, and what is it used for? A foreign key is used to establish relationships
7. Write an SQL SELECT statement to display all the columns of the STUDENT table but only those rows where
1. What are data and information, and how are they related in a database? Data is recorded facts and figures,
85. What is cold backup and hot backup (in case of Oracle)? Cold Backup: It is copying the three sets
79. What is Buffer Manager? It is a program module, which is responsible for fetching data from disk storage into
73. How do you communicate with an RDBMS? You communicate with an RDBMS using Structured Query Language (SQL). 74. Define
67. What are the unary operations in Relational Algebra? PROJECTION and SELECTION. 68. Are the resulting relations of PRODUCT and
61. What do you mean by flat file database? It is a database in which there are no programs or
55. What is meant by query optimization? The phase that identifies an efficient execution plan for evaluating a query that
49. What is 4NF? A relation schema R is said to be in 4NF if for every Multivalued dependency X
43. What is Lossless join property? It guarantees that the spurious tuple generation does not occur with respect to relation
37. What is Set-at-a-time or Set-oriented? The High level or Non-procedural DML can specify and retrieve many records in a
31. What is Data Storage – Definition Language? The storage structures and access methods used by database system are specified
25. What is Relationship set? The collection (or set) of similar relationships. 26. What is Relationship type? Relationship type defines
19. What is an Extension of entity type? The collections of entities of a particular entity type are grouped together
1. What is database? A database is a logically coherent collection of data with some inherent meaning, representing some aspect