Common DBMS/RDBMS Viva-Voce Questions

Ques.  : What is Database ?

Ques.  : What is DBMS ?

Ques.  : What is RDBMS ? Say/List at least any three popular examples of RDBMS packages.

Ques.  : What is relation, tuple and attributes in RDBMS ?

Ques.  : What is Primary Key ?

Ques.  : What is Unique Key ?

Ques.  : What is Foreign Key ?

Ques.  : What is Super Key ?

Ques.  : What is Alternate Key ?

Ques.  : What is Candidate Key ?

Ques.  : What is Composite Key ?

Ques.  : What is the importance of join in RDBMS ? List its types.

Ques.  : What is Normalization ? What is its importance in RDBMS. List its types.

Ques.  : What is view in RDBMS and discuss its importance ?

Ques.  : What is cardinality ?

Ques.  : Explain the role of various keys(such as primary, foreign etc.) used in your                                   project’s database ?

Ques.  : Say about various datatypes(such as char, varchar, integer etc.) used in your                                 project’s database table ?

Ques.  : Say about role of key constraints (such as primary key constraints etc.)used in your                   project’s database table  ?

Ques.  : What is normalization ? How they are useful for your project ?

Ques.  : Explain all the form of normalisation ?

Ques.  : What is cardinality ?

Ques.  : What is data dictionary ?

Ques.  : What is data consistency ?

Ques.  : What is integrity constraint ?

Ques.  : What is Entity ? Explain its type.

Ques.  : What is Attribute ? Explain its type.

Ques.  : What is tuple ? 

Ques.  : What is Record ? 

Ques.  : What is Relation ? 

Ques.  : SQL stands for !

Ques.  : SQL was developed by ?

Ques.  : What is Sql ? List five major Sql used in your project.

Ques.  : How to select unique records from a table ?

Ques.  : What is codd rules ? Why is it useful ?

Ques.  : who is father of RDBMS ?

Ques.  : What is ACID properties in DBMS ?

Ques.  : What is trigger and cursor ?

Ques.  : What is the difference between Delete and Truncate commands ?

Ques.  : What is the difference between Drop and Truncate commands ?

Ques.  : What is constraint ? List the name of constraint.

Ques.  : What is data integrity ? Discuss its importance.

Ques.  : What is aggregate and scalar function ?. Give two examples each.

Ques.  : What is Data warehouse ?

Ques.  : What is Data Mart ?

Oracle10g/11g Viva-Voce Questions

Ques.  : Say/write different versions of Oracle ?

Ques.  : What is the meaning of ‘ i ‘ in Oracle 9i ?

Ques.  : What is the meaning of ‘ g ‘ in Oracle 10g/11g ?

Ques.  : What is the meaning of ‘ c ‘ in Oracle 12c ?

Ques.  : Say/write various datatype of Oracle 10g ?

Ques.  : Say/write the datatype to store image/audio/video/animation object in Oracle 10g ?

Ques.  : What is the difference between varchar & varchar2 datatype in Oracle 10g ?

Ques.  : Why do you use Oracle 10g as back end tool in your project ?

Ques.  : Say/write some important features of Oracle 10g ?

Ques.  : How do you import/export database tables in Oracle 10g ?

MySql Viva-Voce Questions

Ques.  : Why do you use MySql as back end tool in your project ?

Ques.  : Say/write important features of MySql ?

Ques.  : Say/write various datatype of MySql ?

Ques.  : How do you import/export database tables in MySql ?

Sql Server Viva-Voce Questions

Ques.  : Why do you use SqlServer as back end tool in your project ?

Ques.  : Say/write important features of Sql Server 2014 ?

Ques.  : Say/write various datatype of Sql Server 2014 ?

Ques.  : How do you import/export database tables in Sql Server 2014 ?

 3,095 total views,  1 views today


0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.