Oracle Questions for Viva-Voce

• What is Data.
• What is DBMS. Give example. 
• What are the advantages of DBMS
• What is RDBMS. Give example. 
• What are the advantages of RDBMS.
• What is normalisation.
• What is table and record.
• What are attributes.
• what is tuple.
• What is key. And types of key.
• What is primary key.
• What is foreign key.
• What is the difference between primary key and unique key
• what is a query.
• What is DDL. 
• What are DDL  queries.
• What is DML.
• What are DML queries.
• Difference between char and varchar.
• Difference between alter and update.
• Difference between drop and  delete.
• What is join and types of join.
• What is CURSOR. And purpose of each parts of cursor.
• What is stored procedure. Advantage of stored procedure.
• What is stored function. Advantage of stored function.
• Difference between stored procedure and stored functions