0
Add your answer:
Earn +20 pts
Describe the external level of the ansi sparc?
The external level of the ANSI/SPARC architecture represents how users view the data stored in the database. It defines the logical view of the data for each user, which includes specifying the data format, structure, and access permissions that users interact with. This level shields users from the complexities of the internal and conceptual levels of the architecture.
How do you view users permissions in oracle database via sql query?
ask the DBA
What defines how users view the organization of the data?
a data model
What is the purpose of database auditing?
Database auditing is used to observe the actions of the database users. It is commonly used for security purposes to ensure that information is only accessed by those with the proper authority to view it.
What are the Classification of data model?
Data models can be classified into three main categories: conceptual data model (high-level view of the data and its relationships), logical data model (detailed structure of the data and relationships), and physical data model (implementation of the database design on a specific database management system).
Show the difference bw 3-levels of data abstraction in DBMS?
The three levels of data abstraction in a DBMS are physical, logical, and view. Physical level: Describes how data is stored in the database, including details like data storage and access paths. Logical level: Focuses on the structure of the data in the database, including schemas, tables, and relationships. View level: Represents how users view the data, providing a customized and simplified representation of the data to different user groups.
What is data abstraction in DBMS?
Purpose of database users with an abstract view of the data that is system hides certain details of how the data are stored and maintained. It gives an architecture is to separate the user applications and the physical database.
What is a form used for in a database?
A form is an interface in user specified layout that lets users to view, enter, change data directly in the table.
Where can one view trailers for Bratz movies?
You can always view trailers for the Bratz movies for free on Youtube, where users and movie companies have uploaded the trailer of on IMDB, the International Movie DataBase.
Who is the most important user of a database?
Short answer, from a DBA's point of view - Each person who logs into the database. A DB system is there to provide data to the end user. If users can't get their data the database is useless. "Important", in this case, is an extremely subjective term.
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.
Objective of three level architecture in simple language?
All users should be able to access same data.A user's view is immune to changes made in other views.Users should not need to know physical database storage details.DBA should be able to change database storage structures without affecting the users' views.Internal structure of database should be unaffected by changes to physical aspects of storage.DBA should be able to change conceptual structure of database without affecting all users.
