GUI & DBMS Viva faq

Chapter 1: Database Concepts and Systems

What is Database?

What is DBMS?

Advantages of DBMS over file systems.

What is data model?

What is DDL?

What is DML?

List different types of database users.

What are functions of database administrator?

Chapter 2: E-R Model

What is Entity?

What is Entity Set?

Difference between entity and entity set.

List different types of attributes.

What is domain?

What is Relationship?

What is Relationship Set?

What is Cardinality ratio?

What do you mean by total participation?

What do you mean by partial participation?

What is Super key?

What is Candidate key?

What is Primary key?

What is E-R diagram?

How to draw basic components of E-R diagram.

What is Strong Entity Set?

What is Weak Entity Set?

How to draw Weak Entity Set using E-R diagram?

What is Generalization?

What is Specialization?

What is Aggregation?

Chapter 2: Relational Model

What is Tuple?

What is Attribute?

What is Relation?

What is Domain?

What is Primary key?

What is Foreign key?

What is Referential Integrity?

What is Relational Algebra? (Check All operators i.e. select, project, rename, etc.)

What is SQL?

What is DDL? Give one example.

What is DML? Give one example.

What is DCL? Give one example.

What is basic structure of SELECT query?

Which are different aggregate functions used in SQL? Give example.

What is Join? Which are different types of joins in SQL?

Write INNER JOIN syntax.

Write (LEFT, RIGHT, FULL) OUTER JOIN syntax.

What is View? How to create a View?

Chapter 4: Transaction

What is Transaction?

What are ACID properties of transaction? Explain each property.

Draw transaction state diagram and explain.

Why concurrent execution is preferred?

What is Schedule?

What is Serial Schedule?

What is Serializable Schedule?

What is Serializability?

What are conflicting operations?

What is Conflict Equivalence?

What is Conflict Serializability?

What is View Equivalence?

What is View Serializability?

How to draw precedence graph?

What is recoverable schedule?

When the schedule is unrecoverable?

What is cascadeless schedule?

Which are different isolation levels?

What is TCL? Give one example.

Chapter 5: Concurrency Control

What is concurrency control?

What types of locks are used in lock based protocols?

Explain two phase locking protocol.

Give advantages of two phase locking protocol.

Give disadvantages of two phase locking protocol.

What are different variations of two phase locking protocol.

What is deadlock?

How to avoid deadlock?

What is wait-die scheme?

What is wound-wait scheme?

How to draw wait for graph?

Explain timestamp based protocol.

Explain validation based protocol.

Explain graph based protocol.

Chapter 6: Recovery System

Which are different types of failures?

Explain log based recovery.

Explain check point based recovery.

Explain shadow paging.

Chapter 7: GUI

What is Murphy’s law of GUI? Give one example.

What are features of GUI?

What are the standards used for GUI?

Whatare design considerations of GUI?

Chapter 8: Visual Programming

What are intrinsic controls in VB? Give example.

What are Extrinsic controls in VB? Give example.

What is significance of Option Explicit?

What is SDI and MDI?

What is OLE?

What are AciveX Conrols in VB?

What is ADO?

Give different naming conventions for Text box, label, checkbox, combo box, option

button controls.

What is ODBC?

What is the use of msgbox and input box in VB?