Basic DBMS Interview Questions and Answers -2
Ads
Introduction:
The term "DBMS" (Database Management System) refers to a group of tools or programmes that let users build and manage databases. A database management system (DBMS) offers a tool or interface for carrying out different actions on a database, such as inserting, removing, updating, etc. Here we've compiled a collection of the most frequently asked DBMS interview questions to assist you to ace your interviews and improve your knowledge. If you want an ideal job, Nithra jobs provide lakhs of job offers in Tamil Nadu! Make use of it!
1. What is the relation calculus? Non-Procedural language
2. What is the total view of database called? Conceptual view
3. Cartesian product in relational algebra unary or binary? a Binary operator
4. A huge collection of the information or data accumulated form several different sources is known as ________: Data Warehouse
5. What is DBA in DBMS? Database Administrator
6. Generally, a file is a collection of related ______.Records.
7. DML is provided for. Manipulation and processing of database.
8. 'AS' clause is used in SQL for. Rename operation
9. Architecture of the database can be viewed as how many times. Three levels
10. In a relational model, relations are termed as. Tables
11. The database schema is written in. Data definition language (DDL)
12. What entity set has no primary key? Weak entity
13. The language used in application programs to request data from the DBMS is referred to as the. Data manipulation language (DML)
14. Related fields in a database are grouped to form a ___________. data record
15. A _________ is a virtual table that draws its data from the end of an SQL SELECT statement. View
16. Which file manipulation command is called to extract some records from a file? SELECT statement
17. The physical location of a record is determined by a mathematical formula that converts a file key to a record location: A hash function
18. In E-R Diagram derived attribute are represented by. Dashed ellipse
19. The two ways in which entities can participate in a relationship? Total and partial
20. The set of all possible values of data items is called. Domain
21. What is another name for the strong entity? Dominant entity
22. This function is used if we are only interested in specific columns of a table. Projection operation
23. The multiple lower entities are grouped (or combined) together to form a single higher-level entity? Generalization
24. RDBMS terminology for a row. Tuple
25. The term "TCL" stands for_____. Transaction Control Language
Conclusion:
Although DBMS enables real-time data manipulation, two engineers working on the same database from different parts of the world will be able to instantaneously observe any changes made on the other side, with nearly no delay. Because they can permit or deny access to users, databases give us the ability to manage enormous amounts of data at once while also providing a reliable and secure environment.