Search results
Jun 15, 2024 · 2. Views can join and simplify multiple tables into a single virtual table. 3. Views can act as aggregated tables, where the database engine aggregates data (sum, average, etc.) and presents the calculated results as part of the data. 4. Views can hide the complexity of data. 5.
Jul 10, 2023 · RDBMS Interview Questions. Let’s start with the basic RDBMS interview questions first and then we will move to more complex database interview questions. Since these questions focus on the database fundamentals which are common to all the databases, so the questions hold good for the different databases – SQL server, Oracle, MySQL, etc. Ques.1.
In One-Tier Architecture the database is directly available to the user, theuser can directly sit on the DBMS and use it i.e.; the client, server and the Database all present on the same machine. 16. What is 2 tier architecture? Ans: The application on the client-side establishes a connection with the server-side in order to communicate with ...
Jun 28, 2024 · One-to-many:Two tables having primary and foreign key relation. Many-to-many:Junction table having many tables related to many tables. 11) Define Normalization. Organized data void of inconsistent dependency and redundancy within a database is called normalization. 12) Enlist the advantages of normalizing database.
Jun 7, 2022 · Answer: DBMS are software applications that help you build and maintain logically related data. Here are a few advantages of using a DBMS: Limit data redundancy. Restrict unauthorized access. Enforce integrity constraints. More data availability, sharing, protection, and storage. 2.
Mar 21, 2013 · The document discusses DBMS viva questions and answers. It contains 61 questions and their explanations related to key concepts in database management systems including databases, DBMS, data models, data storage, transaction management, and more.
Nov 2, 2023 · DBMS Interview Questions. Q11. What are relationships and mention different types of relationships in the DBMS. A relationship in DBMS is the scenario where two entities are related to each other. In such a scenario, the table consisting of foreign key references to that of a primary key of the other table.
