Search results
DBMS LAB VIVA QUESTIONS 1. What is DBMS? Software that manages data Allows user to DEFINE datatypes and constraints, CONSTRUCT (store) data and MAINPULATE data through queries. Hierarchical, Network, RDBMS, OODBMS NOSQL 2. Advantages of DBMS Redundancy of data avoided. Restricted and protected access to data.
According to the ANSI/SPARC DBMS report, a DBMS can be envisioned as a three-layered system: internal, conceptual, and external. 1. Internal (physical) level: this is the lowest level of abstraction and it describes how the data is physically stored and organized on the storage medium, as well as access to the data, such as through data storage in tables and the use of indexes to expedite data access.
Model Viva Questions for “DBMS II LAB” Branch : VI sem CSE Title of the Practical: Design of E-R Diagram Q1:What is E-R diagram? A1:E-R refers to entity relationship diagram. Q2:What is key? A1: Key is used to specify how entities within a given entity set and relationship within a given entity relationship set are distinguished.
DBMS LAB VIVA Questions :-What is database? A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and populated with data for a specific purpose.
KTU S5 Database Management Systems Lab (CSL 333) Programs (2019 - Scheme) - vivekkj123/ktu-s5-csl-333-dbms-lab
-:DBMS LAB VIVA QUESTIONS:-A 1. Create a table name “Student” with columns name – Student ID, FirstName, LastName and Age, where Student ID is primary key. Insert any 10 records of your choice. Now select all those students whose age is between 18 and 25 and whose name start with letter ‘E’. 2.
DBMS-specific Configuration and management of storage engine Computations to modification of query results by computations, like summing, counting, averaging, grouping, sorting and cross-referencing Constraint enforcement Application
