0
A view is a virtual table that does not really exist but is instead derived from one or more base tables. Since it is a virtual table no stored file is created to store the contents of a view only definition of view is stored.
Wiki User
∙ 9y ago
Wiki User
∙ 9y ago1) A view is a virtual table that does not really exist in its own right but is instead derived from one or more underlying base table(s). 2) The view is a kind of table whose contents are taken upon other tables depending upon a given query condition. 3) No stored file is created to store the contents of a view rather its definition is stored only.
Add your answer:
Earn +20 pts
Which model represents the end user's view of the database?
the ---- of a database presents the views that the end user have
What are views n a database system?
Used to view colums and rows
How do you create views?
Views can be created in a database using the CREATE VIEW key wordEx:CREATE VIEW view_name ASSELECT column_name(s)FROM table_nameWHERE conditions
What are the 3 views of dbms?
A Database has three views. The External Schema: What the end user sees. The Internal Schema: What the programmers of the program see. The Conceptual Schema: The basic plan of the database. Most of the time this is in paper form as a Conceptual Schema Diagram (CSD)
What are the different views of data in a database management systems?
In a database management system, data can be viewed in three main ways: Conceptual view: Represents the overall framework or structure of the entire database. External view: Shows a subset of the database and is tailored to meet individual user requirements. Physical view: Describes how data is stored on the physical storage media.
What can use two different views to create a table?
In a database management system, you can use two different views to create a table by performing a union operation on the two views. This will combine the results of the two views into a single virtual table, allowing you to access the data from both views in one unified table.
What are user views in database?
A database View is a query which shows a portion of data in the database. It can be thought of as a virtual table. An example of a view would be one in which all attributes of an employee are returned as the result without salary details. Views are often used to provide "filtered" views of a database. A view can also hide the complexity of getting the correct data when a query is sent.
Functions of schema?
The schema (pronounced skee-ma) of a database system is its structure described in a formal language supported by the database management system (DBMS). In a relational database, the schema defines the tables, the fields, relationships, views, indexes, packages, procedures, functions, queues, triggers, types, sequences, materialized views, synonyms, database links, directories, Java, XML schema's and other elements.Schema's are generally stored in a data dictionary. Although a schema is defined in text database language, the term is often used to refer to a graphical depiction of the database structure.Hope this helps!Inclus - We provide indivdual and coporate trainingsEducate, Learn & Servewww.Inclus.net
What is the difference between database and table?
A table is an object inside a database. A database has tables of data, views, indexes and programs. A database can have 10 or thousands of tables. More specifically, a table is a collection (rows) of data on a single related topic. For example, the Employees table would have employee data, each row being a different employee, but it would not have Inventory data. That would be in the Inventory table. A database is a collection of objects, primarily tables, but also indexes to help search the tables, views that filter, select and combine the data in the tables, and stored procedures (pre-defined programs that perform specific actions on the database).
Explain the architecture of DBMS?
the architecture of dbms contains three levels 1/ external level:different users views of the database,shows relevant data for a particular user. 2/conceptual level:global view pf the database;describes what data is stored and its relationships. 3/internal level:physical representation of the database on the computer, Describes how the data is stored in the database.
What is database repository?
A repository is a collection of all data definition, data relationships and report formats, i,e; meta data of a database.
What is difference between data dictionary and database schema?
A data dictionary is a collection of metadata about the data elements in a database, where as, a database schema is a design blueprint for how data is structured and organized within a database. The data dictionary describes the data, while the schema defines how the data is stored.
