oracle-databaseadministration.blogspot.com
Oracle DBA: Questions are asked relating to Unix
http://oracle-databaseadministration.blogspot.com/2008/02/questions-are-asked-relating-to-unix.html
Wednesday, February 27, 2008. Questions are asked relating to Unix. In many Oracle DBA interviews many questions are asked relating to Unix. Here I have collected some common Interviews questions asked to a DBA relating to Unix environment. These questions are mostly asked for senior Oracle DBA positions. I have compiled these questions based upon the feedback I got from many candidates who have attended interviews in various MNC'. 1 How do you see how many instances are running? 4 What is OERR utility?
oracle-databaseadministration.blogspot.com
Oracle DBA: Common Interview Questions for Oracle Database Administrator
http://oracle-databaseadministration.blogspot.com/2008/02/common-interview-questions-for-oracle.html
Wednesday, February 27, 2008. Common Interview Questions for Oracle Database Administrator. 1 What is an Oracle Instance? 2 What information is stored in Control File? 3 When you start an Oracle DB which file is accessed first? 4 What is the Job of SMON, PMON processes? 5 What is Instance Recovery? 6 What is written in Redo Log Files? 7 How do you control number of Datafiles one can have in an Oracle database? 8 How many Maximum Datafiles can there be in an Oracle Database? 9 What is a Tablespace? 23 Wha...
oracle-databaseadministration.blogspot.com
Oracle DBA: Common Backup Recovery Interview Questions
http://oracle-databaseadministration.blogspot.com/2008/02/common-backup-recovery-interview.html
Wednesday, February 27, 2008. Common Backup Recovery Interview Questions. Some of the Common Backup and Recovery Interview Questions for Oracle Database Administrator. These questions are common for both Senior Oracle DBA or Junior DBA. I have compiled these questions based upon the feedback I got from many candidates who have attended interviews in various MNC's. 1 Which types of backups you can take in Oracle? 2 A database is running in NOARCHIVELOG mode then which type of backups you can take? 20 Can ...
oracle-databaseadministration.blogspot.com
Oracle DBA: Oracle Technical Interview Questions Answered - Part1
http://oracle-databaseadministration.blogspot.com/2008/02/oracle-technical-interview-questions.html
Wednesday, February 27, 2008. Oracle Technical Interview Questions Answered - Part1. James F. Koopmann. Database Expert) Posted 10/21/2005. The interview process can be quite stressful. Here is the first part of a two part series on helping you answer those tough questions that you might experience in your quest for an Oracle DBA position. I actually wrote this article a long time ago but it is amazing how many questions I still get every week from this one. Stay tunned for Part II next week. The benefit...
vamsichikkam.blogspot.com
Oracle DBA Notes, Documentations for Newbies: June 2007
http://vamsichikkam.blogspot.com/2007_06_01_archive.html
Oracle DBA Notes, Documentations for Newbies. Helping Oracle/MySql Newbies, by providing Notes, Documentation, Tips and Tricks, OCP Q and A, Useful Links, FAQs, Oracle DBA Q and A and lots more. Jun 6, 2007. What is adident utility? Or To know the file Version in Oracle Apps? Adident utility in oracle apps is used to find version of any file . Example: adident Header filename. Links to this post. Patch Log file in Oracle Apps. Q: Where are the log files for the patch process stored? Links to this post.
oracledbascripts.blogspot.com
Oracle DBA Scripts: BIND VARIABLE PEEKING
http://oracledbascripts.blogspot.com/2010/08/bind-variable-peeking.html
Oracle Production support DBA Tips. Want to post your scripts here in this blog? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts. Monday, August 23, 2010. There are 3 things that might put you at risk of unstable plans due to bind variable peeking. 1 Histograms: The histogram tells Oracle about data distribution. Select column name, endpoint number, endpoint value. From dba tab histograms. Where table name='TEST INVOICE';. Labels: BIND VARIABLE PEEKING.
oracledbascripts.blogspot.com
Oracle DBA Scripts: January 2010
http://oracledbascripts.blogspot.com/2010_01_01_archive.html
Oracle Production support DBA Tips. Want to post your scripts here in this blog? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts. Wednesday, January 13, 2010. Oracle Critical File Protection. Step 1: Collect the file locations for control, redo log, and data files:. Step 2: Check file permission. Select 'Control Files: ' value from v$parameter where name= 'control files';. Select 'Control Files: ' value from v$parameter where name= 'spfile';. AND name not in.
infiniteandmore.blogspot.com
Information Storage and Retrieval: January 2014
http://infiniteandmore.blogspot.com/2014_01_01_archive.html
Enter your search terms. Information Storage and Retrieval. Saturday, January 25, 2014. Statistics is the science of collecting,organizing, summarizing, analyzing and interpreting data. Take numerical values whose "size" is meaningful. Quantitative. Variables answer questions such as "how many? Such as social security numbers and zip codes, take numerical values, but are not quantitative: They are qualitative. Variables usually does not make sense, even if the variables take numerical values. Categor...
infiniteandmore.blogspot.com
Information Storage and Retrieval: July 2013
http://infiniteandmore.blogspot.com/2013_07_01_archive.html
Enter your search terms. Information Storage and Retrieval. Wednesday, July 3, 2013. Asymptotic analysis of Algorithms. The complexity of an algorithm function is usually described as a function of the number of inputs it receives. Eg searching(linear search) a particular element in an array of n integers can be described as. F(n) = 4 2n. This method of removing all factors and of "keeping the largest growing term" as described above is what we call. In the limit of function f as. Big-Oh Notation: Its th...