DBMS viva questions


DBMS viva Questions

UNIT- I
1)      Define database, DBMS and application program.
2)      List advantages and disadvantages of DBMS.
3)      Define file based system and its disadvantages.
4)      Components of DBMS environment.
5)      Define three levels of ANSI SPARC Architecture.
6)      What is data independence.
7)      Define DDL and DML.
8)      List all the functions of DBMS.
9)      Define all relational keys. (primary key, foreign key, super key, candidate key, composite key)
10)  Define relational database schema.
11)  Define relation, attribute, domain, tuple (record), degree and cardinality.
12)  Define and list integrity constraints.
13)  Define view. Write the syntax to create a view.
14)  List set, join and aggregate operations.

UNIT- II

1)      Define SQL.
2)      What is a query?
3)      List SQL Data types.
4)      List all DML, DDL and DCL commands.
5)      Define ORDER BY, GROUP BY and HAVING clause.
6)      Write the syntax for CREATE TABLE, DROP TABLE, ALTER TABLE, CREATE INDEX, DROP INDEX.
7)      List out advantages and disadvantages of views.
8)      Define DCL commands (GRANT AND REVOKE). And write their syntaxes.
9)      Define TCL commands (COMMIT and ROLLBACK).
10)  Define Cursor, trigger and exceptions.
11)  Define control statements and its types.
12)  Define function, procedure and package.
13)  Difference between DELETE, TRUNCATE and DROP commands?
A)    DELETE command is used to remove rows from the table. COMMIT and ROLLBACK can be performed after DELETE statement.
TRUNCATE command removes all rows from the table. TRUNCATE operation cannot be rolled back.
DROP command removes a table from the database and operation cannot be rolled back.


UNIT-III

1)      Define strong and weak entities.
2)      What do you mean by entity type.
3)      Define all types of attributes.
4)      Define degrees of relationships.
5)      Define and give examples for types of relationships. (1:1, 1:*, *:*)
6)      Define fan traps and chasm traps. (problems of ER Model)
7)      Define Normalization
8)      Define 1NF, 2NF, 3NF and BCNF.
9)      Define all functional dependencies.
10)  Define insertion, deletion and update anomalies.
11)  Define super class, sub class and attribute inheritance.
12)  Define specialization and generalization.
13)  Define aggregation and composition.

UNIT- IV

1)      Define database security.
2)      Define threats and types of threats.
3)      Define each computer based control.
4)      Define transaction and properties of transaction.
5)      List out the states and properties of transactions.
6)      Define serializability and recoverability.
7)      Define types of locks, deadlock.
8)      Define timestamping and granularity.
9)      Explain optimistic techniques. (read, write and validate)
10)  Explain recovery facilities and techniques.
11)  Define checkpoint and savepoint.
12)  Define nested transaction model.

Comments

Post a Comment

Popular posts from this blog

DS unit-wise important questions

UNIT-I 4m questions(short type): 1) Define data structure 2) What is an ADT 3) Define algorithm, steps and characteristics 4) Define 1-D, 2-D and n-D arrays 5) Pros and cons of arrays 6) Briefly write about Stack ADT 7) Write how to convert infix to postfix expression 15m questions(essay): 1) Explain various types of data structures 2) Explain in detail analysis of algorithms 3) Algorithm design tools(pseudocode & flowchart) 4) Explain about string manipulation using arrays 5) Define stack. Explain different operations performed on stack 6) Describe in brief applications of stack 7) Pseudocode notations UNIT-II Short type: 1) Write in brief about recursion and its advantages 2) Write an algorithm on fibonacci series and factorial of given number 3) Iteration vs recursion 4) Define queue, circular queue and deque 5) Define Queue ADT 6) Define linked list, DLL and CLL 7) Advantages and disadvantages of linked list 8) Advantag...
Read more

web lab programs

Program 1: <html> <head> <title>text formatting tags</title> </head> <body bgcolor=red> <h1 align=center> different tag format </h1> <br> here the text with <b> bold</b> <br> here the text with <i>italic</i> <br> here the text with <u>underline</u> <br> here the text with <small>small </small> <br> here the text with <strong> strong </strong> here the text with <em> emphasise </em><br> here the text with <font size=6 color=red>font </font> <br> here the text with <s> strike </s> <br> here the text with <h1> header tag</h1> </body> </html> Program 2: <html> <head> <title> FONTS </title> </head> <body bgcolor=yellow> <center> <font color=red size=5 face="couriernew"...
Read more