Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Describe ARCn,”Archiver Processes• Copy redo[…]
Read moreCategory: Database
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 moredescribe the Shared SQL area
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.describe the Shared SQL area[…]
Read more