Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Background Processes PMONSMONDatabase writer processLog[…]
Read moreTag: db
A database stores
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.A database stores data and[…]
Read morePMON,”It monitors all the other background processes. When a server or dispatcher process terminates abnormally, it performs process recover.Cleans up the database buffer cache and freeing resources that were allocated for client process. It releases the resources held by failed user process, rolls back the transaction that caused the process to fail, and releases the row and table level locks held by the failed user process. PMON rolls back the transaction that caused the process to fail
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.PMON,”It monitors all the other[…]
Read moreSurrogate Key
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Surrogate Key a primary key[…]
Read moreSMON
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.SMON Is in charge of[…]
Read moreTable names are written how?,”All capital letters ex. STUDENT, COURSE
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Table names are written how?,”All[…]
Read moreDBWN
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.DBWN writes modified buffers in[…]
Read moreColumn names are written,”with an initial capital letter, and compound names are written with a capital letter on each word:- Term, Section, ClassNumber
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Column names are written,”with an[…]
Read moreLGWR
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.LGWR Manages the redo log[…]
Read moreDatabases record data but they do so in such a way,”That we can produce information from the dataThe data on STUDENTs, CLASSs
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Databases record data but they[…]
Read more