Posts

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....
Post a Comment
Read more

unit- IV notes continued

Image
Database Recovery the concept of database recovery as a service that should be provided by the DBMS to ensure that the database is reliable and remains in a consistent state in the presence of failures. The Need for Recovery The storage of data generally includes four different types of media with an increasing degree of reliability: main memory, magnetic disk, magnetic tape, and optical disk. Main memory is volatile storage that usually does not survive system crashes. Magnetic disks provide online non-volatile storage. There are many different types of failure that can affect database processing, each of which has to be dealt with in a different manner. Some failures affect main memory only, while others involve non-volatile (secondary) storage. Among the causes of failure are: ·          system crashes due to hardware or software errors, resulting in loss of main memory; ·      ...
1 comment
Read more