DBMS stands for Database Management System. It is a software system designed to facilitate the management and organization of databases. A DBMS allows users to store, retrieve, modify, and manipulate vast amounts of data efficiently and securely.
Key aspects and functions of a DBMS:
- Data Organization:
A DBMS provides a structured framework for organizing data. It allows data to be stored in tables, which consist of rows (records) and columns (attributes). This structured approach ensures data integrity and enables efficient data retrieval.
- Data Retrieval:
With a DBMS, users can retrieve data from databases using query languages such as SQL (Structured Query Language). These queries enable users to search for specific data, perform calculations, and extract meaningful insights.
- Data Manipulation:
DBMS systems support various operations for manipulating data. Users can insert new data into the database, update existing records, or delete data as needed. The DBMS ensures data consistency and integrity during these operations.
- Data Security:
DBMS systems incorporate security mechanisms to protect sensitive data. Access controls, user authentication, and encryption techniques are implemented to safeguard data from unauthorized access and ensure data privacy.
- Data Integrity:
DBMS systems enforce data integrity by implementing constraints and rules. These constraints ensure that data entered into the database adheres to predefined rules, such as unique key values or referential integrity between tables.
- Data Backup and Recovery:
DBMS systems provide mechanisms for data backup and recovery. Regular backups protect against data loss due to system failures, hardware malfunctions, or disasters. In case of data loss, the DBMS enables the restoration of the database to a previous state.
- Data Concurrency:
DBMS systems support concurrent access to the database by multiple users or applications. They manage concurrent transactions, ensuring that data remains consistent and preventing conflicts that may arise from simultaneous updates.
Here are some Basic Simple DBMS GK Question list:
|In the relational modes, cardinality is termed as:
|Number of tuples.
|Relational calculus is a
|Non- Procedural language.
|The view of total database content is
|Cartesian product in relational algebra is
|a Binary operator.
|DML is provided for
|Manipulation & processing of database.
|‘AS’ clause is used in SQL for
|ODBC stands for
|Open Database Connectivity.
|Architecture of the database can be viewed as
|In a relational model, relations are termed as
|The database schema is written in
|In the architecture of a database system external level is the
|An entity set that does not have sufficient attributes to form a primary key is a
|weak entity set.
|In a Hierarchical model records are organized as
|In an E-R diagram attributes are represented by
|In case of entity integrity, the primary key may be
|In tuple relational calculus P1 ®P2 is equivalent to
|¬P1 Ú P2
|The language used in application programs to request data from the DBMS is referred
|A logical schema
|is the entire database.
|Related fields in a database are grouped to form a
|The database environment has all of the following components except:
|The language which has recently become the defacto standard for interfacing application
|grams with relational database system is
|The way a particular application views the data from the database that the application programs with relational database system is
|In an E-R diagram an entity set is represent by a
|A report generator is used to
|print files on paper.
|The property / properties of a database is / are :
|It is an integrated collection of logically related records.
|The DBMS language component which can be embedded in a program is
|The data manipulation language (DML).
|A relational database developer refers to a record as
|The relational model feature is that there
|is much more data independence than some other database models.
|involves modelling independent of the DBMS.
|The method in which records are physically stored in a specified order according to a key
|A subschema expresses
|the external view.
|Count function in SQL returns the number of
|Which one of the following statements is false?
|Data elements in the database can be modified by changing the data dictionary.
|An advantage of the database management approach is
|data is integrated and can be accessed by multiple programs.
|A DBMS query language is designed to
|support in the development of complex applications software.
|TrAnsaction processing is associated with everything below except
|confirming an action or triggering a response.
|It is possible to define a schema completely using
|DDL and DML.
|The method of access which uses key trAnsformation is known as
|Data independence meAns
|programs are not dependent on the physical attributes of data and programs are not dependent on the logical attributes of data.
|The statement in SQL which allows to change the definition of a table is
|E-R model uses this symbol to represent weak entity set ?
|Doubly outlined rectangle
|SET concept is used in :
|Relational Algebra is
|Procedural query Language
|Key to represent relationship between tables is called
|_______ produces the relation that has attributes of R1 and R2
|The file organization that provides very fast access to any arbitrary record of a file is
|DBMS helps achieve
|Data independence and Centralized control of data
|Which of the following are the properties of entities?
|In a relation
|Ordering of rows is immaterial and No two rows are identical
|Which of the following is correct:
|None of these
|It is better to use files than a DBMS when there are
|Stringent real-time requirements, Multiple users wish to access the data and Complex relationships among data.
|The conceptual model is
|independent of both hardware and software.
|What is a relationship called when it is maintained between two entities?
|Which of the following operation is used if we are interested in only certain columns of a
|Which of the following is a valid SQL type?
|CHARACTER, NUMERIC and FLOAT
|The RDBMS terminology for a row is
|Which of the following operations need the participating relations to be union compatible?
|UNION, INTERSECTION and DIFFERENCE
|The full form of DDL is
|Data Definition Language
|Which of the following is an advantage of view?
|Data security, Derived columns, Hiding of complex queries
|Which of the following is a legal expression in SQL?
|SELECT NAME FROM EMPLOYEE;
|The users who use easy-to-use menu are called
|Which database level is closest to the users?
|Which are the two ways in which entities can participate in a relationship?
|Total and partial
|The result of the UNION operation between R1 and R2 is a relation that includes
|all the tuples of R1 and R2 which have common columns
|Which of the following is a comparison operator in SQL?
|= , LIKE and BETWEEN
|A set of possible data values is called
|Which of the operations constitute a basic set of operations for manipulating relational
|Which of the following is another name for weak entity?
|Which of the following database object does not physically exist?
|not a value
|Which of the following is record based logical model?
|A data dictionary is a special file that contains:
|The name of all fields in all files, The width of all fields in all files, and The data type of all fields in all files.
|A file manipulation command that extracts some of the records from a file is called
|The physical location of a record is determined by a mathematical formula that trAnsforms
|Using Relational Algebra the query that finds customers, who have a balance of over
|PCustomer_name(s balance >1000(Deposit))
|A primary key is combined with a foreign key creates
|Parent-Child relation ship between the tables that connect them.
|In E-R Diagram derived attribute are represented by
|Cross Product is a:
|An instance of relational schema R (A, B, C) has distinct values of A including NULL
|A is not a candidate key
|Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,
|The natural join is equal to :
|Combination of projection and Cartesian product
|Which one of the following is not true for a view:
|A view definition is permanently stored as part of the database.
|A primary key if combined with a foreign key creates
|Parent-Child relationship between the tables that connect them.
|In E-R Diagram relationship type is represented by
|Hierarchical model is also called
|To delete a particular column in a relation the command used is:
|The ______ operator is used to compare a value to a list of literals values that have been
|A logical schema
|defines the structure of the data itself and the relationships between the various attributes, tables, and entries.
|A B-tree of order m has maximum of _____________ children
|_____________ function divides one numeric expression by another and returns the
|A data manipulation command the combines the records from one or more tables is called
|In E-R diagram generalization is represented by
|_________ is a virtual table that draws its data from the result of an SQL
|The method of access which uses key trAnsformation is known as
|A table joined with itself is called
|_________ data type can store unstructured data