0
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.
Wiki User
∙ 15y ago
Wiki User
∙ 9y agoA 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). No stored file is created to store the contents of a view rather its definition is stored only.
Add your answer:
Earn +20 pts
What is a database GUI?
The graphical user interface of the database.
What is the component of database that serve as the intermediary between the user and the database?
dbms
Which database is closest to the user?
sql server database is more reliable and user friendly and easy to handle. As a member of hosting provider of mywindowshosting.com I used this database for my project since one year.
What is data base catalog?
The database catalog of a database instance consists of metadata in which definitions of database objects such as base tables, views (virtual tables), synonym, value ranges, indexes, users, and user groups are stored.The SQL standard specifies a uniform means to access the catalog, called the INFORMATION_SCHEMA, but not all database follow this, even if they implement other aspects of the SQL standard. For an example of database-specific metadata access methods, see Oracle metadata.
When a server compares a user's credentials with those in its database?
authentication
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 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 is single-user database?
Single-user database support only one user at a time
What is the example of single user database?
single-user database supports only one user at a time. In other words, if user A is using the database, users B and C must wait until user A is done. A single-user database that runs on a personal computer is called a desktop database.
What is a database GUI?
The graphical user interface of the database.
What is the component of database that serve as the intermediary between the user and the database?
dbms
What is a user database?
A user database is a system that more than 1 person can access and gain information from. Multiple users can input and store data in these database systems.
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 single-user?
Single-user database support only one user at a time
What is single user?
Single-user database support only one user at a time
Where database come from?
Database comes from the end user or the database users. Combining all the data database system is formed.
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.
