Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Describe ARCn,”Archiver Processes• Copy redo[…]
Read moreTag: db
What is a Segment,”A segment is a set of extents allocated for a certain logical structure such as:data segments, index segments, undo segments, temporary segments
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.What is a Segment,”A segment[…]
Read moreBenefits of the Database Approach,”Redundancy can be reduced and thus inconsistency can be avoidedData can be integrated and shared among applicationsStandards can be enforced by the DBAFormats, representation, naming
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Benefits of the Database Approach,”Redundancy[…]
Read moreWhat are the three files that comprise an Oracle database?,”control files, data files
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.What are the three files[…]
Read moreWhat are the mandatory Tablespaces?,”SYSTEM and SYSAUXcreated upon creation of database• The SYSTEM tablespace is used for core functionality (for example
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.What are the mandatory Tablespaces?,”SYSTEM[…]
Read moreThe three schema architecture
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.The three schema architecture User[…]
Read moreWhat are the additional files used during the operation of the database,”parameter file, password file, backup files, archived redo log files, trace files
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.What are the additional files[…]
Read moreWhat is ASM?
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.What is ASM? Automatic Storage[…]
Read moreUser level (external schema)
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.User level (external schema) Part[…]
Read morewhat are control files,”Each database has one unique control file that contains data about the database itself (that is, physical database structure information). Multiple copies may be maintained to protect against total loss. It can also contain metadata related to backups. The control file is critical to the database. Without the control file
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.what are control files,”Each database[…]
Read more