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. : Explain different types of table used/created in your project ?
Ques. : What is relation, tuple and attributes in RDBMS ?
Ques. : What is Primary Key and mention in your project?
Ques. : What is Secondary 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 regarding your project. List its types also.
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. : Explain different types of SQL queries used in your project ?
Ques. : What is Entity? Explain its type. Also list no. of entities in your project.
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 ? How many types of Codd rules you know?
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 ?
Ques. : Difference between SQL Server, Oracle and MySql database?
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 ?
Ques. : Differentiate between char, varchar & varchar2
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 ?
0 Comments