Interested to Buy Any Domain ? << Click Here >> for more details...
Can you list down the different components of physical and logical database structure?
- 1 Answers
- 6 Views
- I also Faced
- E-Mail Answers
Answer / Indresh Kumar
The physical database structure includes: 1. Data Files: These store the actual data of the tables, indexes, and other objects in the database. 2. Redo Log Files: They record all changes made to the database so that they can be recovered in case of failures. 3. Control File: It stores vital information about the database structure, including names, locations, and online/offline status of data files and redo log files. The logical database structure includes tables, indexes, clusters, views, etc.
| Is This Answer Correct ? | 0 Yes | 0 No |
Mention what is oracle real application clusters?
What is the function of grid naming service used in oracle rac
Why do we need to rebuild indexes?
What if your ocr (oracle cluster registry) is corrupted?
Mention what is cluster?
How would you differentiate between cluster and grid?
How would you identify the shared_pool_size parameter that needs to be adjusted?
What is a flashback query and when should it be used?
What do you understand by row chaining?
What is required by oracle rac database to connect to a network?
What are the key characteristics of rac or why to use rac?
What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?
Oracle General 
