KyaPoocha.com

Huge Collection of Interview Questions

Search our list of 7708 Interview Questions


DBMS V/s File Processing System 

Posted in Database Interview Questions

DBMS
Ø Redundancy is controlled.
Ø Unauthorised access is restricted.
Ø Providing multiple user interfaces.
Ø Enforcing integrity constraints.
Ø Providing backup and recovery.

File Processing System
Ø Data redundancy & inconsistency.
Ø Difficult in accessing data.
Ø Data isolation.
Ø Data integrity.
Ø Concurrent access is not possible.
Ø Security Problems.

Post Your Answer!
Send This to a Friend

← What are OPTIMIZER HINTS ?
What are levels of Abstraction? →

If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!


BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |

Related Interview Questions

  • What is a Processing Instruction in XML?  22.11.08

    An XML file can also contain processing instructions that give commands or information to an application that is processing the XML data. Processing instruction...

  • Which file do you edit to set partitions to mount at boot time?  08.11.08

    The file /etc/fstab manages which partitions are automatically mounted onto the file system. Answers b and c refer to valid items, but they are not used to mana...

  • Which file do you edit to set partitions to mount at boot time?  08.11.08

    The file /etc/fstab manages which partitions are automatically mounted onto the file system. Answers b and c refer to valid items, but they are not used to mana...

  • What is the meaning of dynamic processing ?  11.08.08

    It's rarely used. It means one program uses both sequential and random processing for a VSAM KSDS file....

  • What is IBM Database 2?  07.03.08

    DB2 is a subsystem of the MVS operating system. It is a Database Management System (DBMS) for that operating system....

  • What is a data source?  22.10.06

    A DataSource class brings another level of abstraction than directly using a connection object. Data source can be referenced by JNDI. Data Source may point to...

  • What is durability in DBMS?  11.03.06

    Once the DBMS informs the user that a transaction has successfully completed, its effects should persist even if the system crashes before all its changes are r...

  • What is a checkpoint and When does it occur?  08.03.06

    A Checkpoint is like a snapshot of the DBMS state. By taking checkpoints, the DBMS can reduce the amount of work to be done during restart in the event of subse...

  • What is durability in DBMS?  08.03.06

    Once the DBMS informs the user that a transaction has successfully completed, its effects should persist even if the system crashes before all its changes are r...

  • Discuss the mount and unmount system calls  08.03.06

    The privileged mount system call is used to attach a file system to a directory of another file system; the unmount system call detaches a file system. When you...