InfyTQ Introduction to DBMS Quiz 1

Database is also known as Collection of Data. A database is an organized collection of structured information, or data, typically stored electronically in a computer system

Database management system is a collection of Interrelated Data and set of data programs to access them.

ORACLE, MYSQL and FoxPro is considered as a DBMS.

File Management Storage System was used before DBMS came into existence . A file system is a technique of arranging the files in a storage medium like a hard disk, pen drive, DVD, etc. It helps you to organizes the data and allows easy retrieval of files when they are required.

Full form of DBA is Database Administrator. Database administrators ensure databases run efficiently. Database administrators and architects create or organize systems to store and secure a variety of data, such as financial information and customer shipping records.

View Level shows only the user interface to the user not how the data is stored in the system . At view level, user just interact with system with the help of GUI and enter the details at the screen, they are not aware of how the data is stored and what data is stored; such details are hidden from them

DBMS acts as an interface between Database Application and Database. Database management system is a software which is used to manage the database.

Duplication of data is called data redundancy. Data redundancy occurs when the same piece of data is stored in two or more separate places and is a common occurrence.

If the common fields are not matching in the Database then it is known as Data Inconsistency. Data inconsistency is a situation where there are multiple tables within a database that deal with the same data but may receive it from different inputs.