Technical Question Bank: Database Management System

Technical interviews are conducted to assess candidates for specialist or technical job positions. The interviewers intend to test your field-specific knowledge. You should be well-versed with the basics of database management system. 
 
List of Technical Questions based on Database Management System
  • What is Database?
  • What is DBMS?
  • What is a Database system?
  • Explain the advantages of DBMS?
  • Explain the disadvantages of the File Processing System?
  • Mention and describe the three levels of data abstraction?
  • Define the "integrity rules"?
  • What is extension and intension?
  • What is System R? What are its two major subsystems?
  • How is the data structure of relational structure different from System R?
  • Explain Data Independence?
  • What is a view? Explain its relation with data independence?
  • What is a Data Model?
  • What is an E-R model?
  • What is Object Oriented model?
  • What is an Entity?
  • What is an Entity type?
  • What is an Entity set?
  • What is an Extension of entity type?
  • What is Weak Entity set?
  • What is an attribute?
  • What is a Relation Schema and a Relation?
  • What is Relationship?
  • What is Relationship set?
  • What is Relationship type?
  • What is degree of Relationship type?
  • What is DDL (Data Definition Language)?
  • What is VDL (View Definition Language)?
  • What is SDL (Storage Definition Language)?
  • What is Data Storage - Definition Language?
  • What is DML (Data Manipulation Language)?
  • What is DML Compiler?
  • What is Query evaluation engine?
  • What is DDL Interpreter?
  • What is Record-at-a-time?
  • What is Set-at-a-time or Set-oriented?
  • What is Relational Algebra?
  • What is Relational Calculus?
  • How does Tuple-oriented relational calculus differ from domain-oriented relational calculus?
  • What is normalization?
  • What is Functional Dependency?
  • Explain Lossless join property?
  • What is 1 NF (Normal Form)?
  • Explain Fully Functional dependency?
  • What is 2NF?
  • What is 3NF?
  • What is BCNF (Boyce-Codd Normal Form)?
  • What is 4NF?
  • What is 5NF?
  • What is Domain-Key Normal Form?
  • What are partial, alternate, artificial, compound and natural keys?
  • What is indexing? What are the different kinds of indexing?
  • What is system catalog or catalog relation? What is it better known as?
  • Explain query optimization.
  • What does durability in DBMS mean?
  • What do you mean by: atomicity and aggregation?
  • Explain Phantom Deadlock?
  • What is a checkpoint? When does it occur?
  • What are the different phases of a transaction?
  • What is flat file database?
  • What is "transparent DBMS"?
  • What is a query?
  • What do we mean by Correlated subquery?
  • Mention the primitive operations common to all record management systems?
  • Name the buffer in which all the commands that are typed in are stored?
  • List the unary operations in Relational Algebra?
  • Are the resulting relations of PRODUCT and JOIN operation the same?
  • What is RDBMS KERNEL?
  • Name the sub-systems of an RDBMS.
  • Which part of the RDBMS takes care of the data dictionary? How?
  • What is the job of the information stored in datadictionary?
  • How do you communicate with an RDBMS?
  • Define SQL and state the differences between SQL and other conventional programming Languages.
  • Name the three major set of files on disk that compose a database in Oracle.
  • What is database Trigger?
  • What are stored-procedures? And what are their advantages?
  • What is Storage Manager?
  • What is Buffer Manager?
  • What is Transaction Manager?
  • What is Authorization and Integrity manager?
  • What are stand-alone procedures?
  • What are cursors. Give different types of cursors?
  • In case of Oracle, what is cold backup and hot backup?
  • What is meant by Proactive, Retroactive and Simultaneous Update
If you have any question, suggestion or feedback, feel free to post it in the discussion box given below.
Rate Us
Views:16330