Database Management Systems - Overview

Home >> Computer Awareness

1. Databases in Access are composed of four objects: tables, queries, forms, and reports. Microsoft Access Pivot Table Database allowed to select one row heading, one column heading, and one filter field. It has been removed in Access 2016.


*******

2. With relational DBMSs known as RDBMSs, the Application programming interface is SQL.SQL a standard programming language for defining, protecting and accessing data in a RDBMS.


*******

3. IMDBMS stands for In-memory database management system. It provides faster response times and better performance. It is a database management system that predominantly relies on main memory for data storage, management and manipulation.


*******

4. CDBMS stands for Columnar database management system. It well-suited for data warehouses that have a large number of similar data items.


*******

5. Data abstraction and independence A DBMS provides following advantages: Data security A locking mechanism for concurrent access An efficient handler to balance the needs of multiple applications using the same data The ability to swiftly recover from crashes and errors, including restart ability and recoverability Robust data integrity capabilities Logging and auditing of activity.


*******

6. Dr E.F.Codd is also known to the world as the 'Father of Database Management Systems'. He had propounded 12 rules which are in-fact 13 in number. The rules are numbered from zero to twelve. According to him, a DBMS is fully relational if it abides by all his twelve rules.


*******

7. In the relational database model, data is stored in relations, more commonly known as tables. Tables, records (sometimes known as tuples), and fields (sometimes known as attributes) are the basic components of a RDBMS.


*******

8. Michael Widenius is known as the Father of MySQL. He is the main author of the original version of the open-source MySQL database and a founding member of the MySQL AB company.


*******

9. A database administrator is a specialized computer systems administrator who maintains a successful database environment by directing or performing all related activities to keep the data secure.


*******

10. There are many types of Database Languages. A few among them are - Data Definition Language. DDL stands for Data Definition Language, Data Manipulation Language, Data Control Language etc.


*******

11. Transaction Control Language is used to run the changes made by the DML statement.(TCL) commands are used to manage transactions in the database.


*******

12. The subschema is the logical description of that section of the database which is relevant and available to an application. A subschema is a subset of the schema and inherits the same property that a schema has.


*******

13. Databases in MS Access are composed of four objects.These are tables, queries, forms, and reports.Together, these objects allow us to enter, store, analyze, and compile data according to the wish.


*******

14. A database model is a type of data model that determines the logical structure of a database and fundamentally determines in which manner data can be stored, organized and manipulated.Types of database models are Hierarchical database model,Relational model,Network model,Object oriented database model,Entity-relationship model,Document model,Entity-attribute-value model,Star schema etc.


*******

15. Examples of ORDBMSs include PostgreSQL developed by the PostgreSQL Global Development Group,Oracle Database by Oracle Corporation, Informix by IBM,SQL Server by Microsoft and Greenplum Database by Pivotal Software etc.


*******

16. Atomese is the graph query language for the OpenCog graph database.Cypher is a query language for the Neo4j graph database.Datalog is a query language for deductive databases.


*******

17. Andreas Reuter and Theo Harder coined the acronym ACID for Atomicity, Consistency, Isolation, and Durability. In the context of databases, a sequence of database operations that satisfies the ACID properties is called a transaction.


*******

18. The DBMS manages three important things: the data, the database engine and the database schema. The database schema defines the database’s logical structure.


*******

19. A commit is the final step in the successful completion of a previously started database change as part of handling a transaction in a computing system.


*******

20. A rollback is the undoing of partly completed database changes when a database transaction is determined to have failed.


*******
Advertisement

Kindly help us to keep GKToday updated and error free. Use this form to report error or outdated information in questions. We shall rectify asap...