#DBAchallenge скачать в хорошем качестве

#DBAchallenge

Questions: --- The update query will process if 1 block has 5 row where 2 rows has updated what about 3 rows that will lock or not? --- select * from emp; how it will access SGA? --- How many DBWn and LGWR I can have in my database? --- You want to find out how many users are defined in the password file and what privileges those users have. How would you accomplish this? #DBAchallenge-2 Q2: update emp set sal=2000 where empid=123; How the update query works and how it will access SGA? Q2: What are the use case of password file other than remote admin operation? #DBAchallenge, Do submit your questions using below Link https://forms.gle/EsU8wgxhrSN4CCaF6 More information refer our blog: https://mallik034.blogspot.com/ #passwordfile #select #update #locks #process #ASM #RMAN #RAC #dba #interview #question #answers #DBAchallenge #oracle #database Regards, Mallikarjun Ramadurg Mobile: +91 9880616848 WhatsApp: +91 9880616848