Explain the three Level Architecture of the Database System
Answer / Raja Singh
The Three-Schema Architecture, also known as the Three-Level Model or TTM (Terry's Triple Models), is a database design which involves a logical schema, a view schema, and a physical schema. The logical schema organizes data from the user's perspective, the view schema translates the logical schema into the capabilities of the database management system, and the physical schema stores data on disk.
| Is This Answer Correct ? | 0 Yes | 0 No |
how to generate an auto incremental number in a ssis package?
What is cardinality in db?
Can we linked SharePoint to a SQL databasebe?
1 Answers Sans Pareil IT Services,
What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.
How do you organize a database?
Can you drop all the columns of a table ?
1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?
What do you understand by e-r model?
What is the main purpose of normalization?
Explain types of indexing in dbms?
Why do I need netlib?
What are the 5 databases?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)