Archive for the ‘Fresher Oracle DBA tips’ Category

How to clear Oracle certification exams

February 25, 2020

There should be little question in your mind that you simply face a test filled with specific and pointed questions. The Oracle certification exam test consists of around 60-70 questions that you simply must complete in 90 minutes.

Questions belong to at least one three basic types; multiple-choice with one answer, multiple-choice with quite one answer, and fill within the blank questions. you want to answer the fill-in-blank questions with the precise answer, including spelling, otherwise, you will miss the question.

Always take the time to read an issue a minimum of twice before selecting a solution, and always search for an Exhibit button as you examine each question. Exhibits include graphics information that pertains to the question. An exhibit is typically a screen capture of program output, a selected SQL statement, or GUI information that you simply must examine to research the question’s scenario and format a solution.

Not every question has just one answer; many questions require multiple answers. Therefore, it’s important to read each question carefully, not only to work out what percentage answers are necessary or possible, but also to seem for extra hints or instructions once you are selecting answers. Such instructions often occur in brackets immediately following the question itself, as they are doing for all multiple-choice questions during which one or more answers are possible.

Obviously, the sole thanks to passing any exam is to pick enough of the proper answers to get a passing score. However, Oracle’s exams aren’t standardized just like the SAT and GRE exams required for entrance to the school or grad school within the U.S; they’re much more diabolical and convoluted. In some cases, questions are strangely worded, and deciphering them is often a true challenge. In those cases, you would possibly get to believe answer-elimination skills. nearly always, a minimum of one answer out of a question’s alternatives are often eliminated immediately because it matches one among these conditions. It doesn’t apply to things. It describes a nonexistent issue, an invalid option, or an imaginary state.

After you eliminate all answers that are obviously wrong, you’ll apply your retained knowledge to eliminate further answers. Search for items that sound correct but that ask actions, commands, or features that aren’t present or available within the situation that the question describes. Also, look in other test questions for possible answers to the question you’re battling.
If you’re still faced with a blind guess among two or more potentially correct answers, reread the question. attempt to picture how each of the possible remaining answers would alter things. Be especially sensitive to terminology because sometimes the selection of words (remove rather than disable) can make the difference between a right answer and a wrong one.
Only when you’ve got exhausted your ability to eliminate answers do you have to guess at a solution. An unanswered question offers you no points, but guessing gives you a minimum of some chance of getting an issue right. Just don’t be too hasty when making a blind guess.

You can wait until the last round of reviewing marked questions, even as you’re close to run out of your time, or out of unanswered questions before you begin making guesses.

How to Face Technical Oracle DBA Interview

February 21, 2020

Facing personal technical Oracle DBA interview is very difficult because you need to concentrate on multiple areas like dressing, attitude, the body language of replying, face reaction, and tricky Oracle database administration questions.

Conceivably yet further disturbing than the queries you are going to have to answer, you are going to have to determine the just correct covering to be dressed into a job interview.  You craving to appear proficient and comparable to you are going to find in with the company.  A nice regulation of thumb for men is that you can’t overdress for the interview – a shirt and tie or a suit is always a safe choice.  For women, selecting kinds of stuff is more difficult.

For both men and women, choose a dress that you consider relaxed in and that matches you correctly.

You don’t want pants that are too stretched or a shirt that is too comfy across the upper body.  It will be a disruption for both you and your interview taker.  Beside the same layer, pick colors that outfit you but aren’t too dazzling or outlines that are excessively dark.  You desire the spotlight to be on your replies, not what you are wearing.

Memorize too that your general exterior is going to be moderated, and this comprises additional than the costumes you are wearing.  Cleanliness and brushing: be spotless, efficient and orderly.  It is most likely most excellent not to dress in a burly perfume – possibilities are you will be in a tiny area and it could formulate others painfully.  Your claws should be brief and fresh, your looks fresh and clean, and have mint candies with you or sweep your tooth instantly before making for the appointment.

You may be unsure what all of these elements have to do with your prerequisites and obtaining the job.  It has to do a lot with it, particularly if you are going to be compacting with the company’s clients face-to-face.  The organization will want to hire workers who are going to symbolize the organization in the most excellent likely light.

If you are facing any technical interview then you should need to prepare yourself first with all difficult interview questions like tricky questions, version related questions, and real-time scenario-based questions. You should need to consider the organization’s basic requirements and should be aware of the exact technical environment of the company before start facing these kinds of technical queries. The interviewer always tries to search for a candidate who can take care of their existing infrastructure as well as a quick learner with a nice performer. Keep in mind, every company has different technical specifications and different requirements. Your personality, dressing, knowledge, experience, and understanding will help you to get a job. For preparing the Oracle DBA interview, you can take the help of any decent book which covers all versions and tricky real-time scenario-based questions with proper explanation.

Selecting either Oracle DBA or Oracle APPS DBA

February 17, 2020

Many firms utilize the database on the pc to store information. the power of the info base to supply maximum security and effectiveness in storing the data is paramount for any organization. It thus requires specialized attention. the choice on whether to travel for Oracle DBA or Oracle APPS DBA may convince be a frightening task. Both systems have proved their function ability within the market as they need working well for several clients. The database consulting company would be ready to be better placed to advise you on the benefits of every system after analyzing the stress of your organization. it’s thus difficult to work out which one is best since the clients’ requirements tend to differ.

More often or not the database of any company is managed by a database administrator who is additionally mentioned as a DBA. the most role of the DBA is to put in, update and maintain the system. it’s worth noting that there some companies that have invested during a personal DBA on their premise. this type of move is threatening the recognition and existence of jobs for the DBA administrators. Such a move is mentioned as outsourcing since the service is provided by a knowledgeable company that focuses on that field. This move has proved cost-effective to the businesses since the prices of employing and maintaining an employee are eliminated.

The main function of the remote database administrator is analogous thereto of getting a DBA on the location. the sweetness about this technique is within the incontrovertible fact that issues that arise thanks to an employee falling sick and therefore the like are greatly eliminated. Other avenues that are eliminated include; vacations, paid leave, taxes or some levels of inefficiency.

The organization that focuses on providing quality DBA services should get on call around the punch in case the client is faced with any sought of challenges. The consulting company on the opposite hand should have very highly qualified DBA experts who are equipped with the knowledge of handling any sought of challenges which will arise because the company strives to supply excellent quality service to its clients. The DBA experts should be ready to keep themselves updated on the functions that the system is performing including updates and upgrades.
It is essential to utilize a DBA company that focuses on the company’s specific type like oracle database consulting. this may add to the probabilities of receiving top quality services.
Once the newest versions of database systems are available the DBA consulting company should be appositively to line it up for his or her clients without having to cause an excessive amount of interruptions to the system.

Most of the outsourcing DBA consults have a system that alerts them just in case there’s any malfunction within the system. This plays an enormous role in ensuring that the system is up and running most of the time since such interruptions are identified and addressed immediately effect.

Salary Expectations in Oracle DBA

January 27, 2020

bribe, corruptionThe salary for the Oracle DBA is directly influenced by the background of the employee. It depends on the quality of the background of the employee. Professionals of oracle DBA with an extra-strong background expects a salary of an amount that is equal to 3 times their age. Graduates from business schools such as those students who have pursued their careers in bachelor’s degrees or master’s degrees expect a salary premium because they are doing their graduation highly competitive universities. Again the oracle professionals who have their advanced degree certificates from famous institutes earn far more salary as compared to that of the average salary Oracle DBA. These certificates may not have the capability to increase the salary of the professionals in the starting stage but it shows the commitments that the person made in building up her or his career in the field of oracle database administration.

Oracle is now a day considered as the most flexible, complex and robust database. This is now impossible to handle without the application of any type of mentor and for this reason, all the trainers for oracle are professional workers. These professionals are working harder and harder to be an expert in oracle and they are now sharing the secrets behind their success and suggest tips to the newcomers in the field of oracle database administration so that they can get an average salary Oracle DBA. These oracle professional trainers are now becoming so expert in oracle that they can certify each and every database and can give a complete oracle database optimized verification to the newcomer. That means they can verify different areas of the database of any project and can provide a brief idea of whether the database is liable or not. That is why most of the people prefer this.

Common Questions in HR interviews

January 29, 2019

Here I am providing you some of the common questions and answers of HR interview. For more detail you can check my official blog at Gitesh Trivedi blog.

Que: Tell us something about yourself?
Ans.: Be step by step whereas responsive this question. Jump with your Name the candidate should cowl his skilled expertise. Keep in mind you speak that has relevance to the required profile. You want to provide a temporary plan regarding your educational qualification, achievements together with the career goals.

Remember that before telling something regarding your interests and traits, you have got already mentioned and gained the data regarding the obtainable position.

Que: What are your weaknesses and strengths?
Ans.: This is the largely asked question throughout interviews. Be terribly positive whereas respondent these queries and provides a sensible answer. Attempt to render a positive account each the queries.
While talking regarding your strengths describe regarding your skills and talents that are the foremost appropriate to the vacant position. like “I don’t simply follow the deadlines however attempt to end the given task well before the given deadlines.”

When there’s the communicate say regarding your weakness you’ve got to be a touch diplomatic. Show the positive facet of your weakness like “I praise my team when each winning action, then again I feel that I will improve them to try and do higher.”

Que: Why should we hire you?
Ans.: One of the foremost typical queries that are asked throughout the interview. Here you’ll be able to offer some examples within the sort of your experience and past achievements. To answer this question in best means, you must have done the preparation and compare your skills with the need of the vacant position. the most effective answer to this question is often “because you have got the chance and that I have the competency to accomplish that chance.”

Que: Tell Me the difference between hard work & smart work?
Ans: Hard work suggests that you may provide physical & mental stress to yourself for completion of labor on alternative hands sensible work suggests that you simply to use your information especially direction to complete your task.

Que: Are you willing to relocate?
Ans: If you wish a job in this company your answer is affirmative, I’m able to relocate or travel.

Que: Describe your ideal company, location & job?
Ans: Don’t be Foolish to grant the solution like that my ideal company is INFOSYS location Bombay and Job coder. This Ans are making a dangerous impression to an hour. The preferred Ans ought to be:-
Ideal company means: – wherever client satisfies for employee’s project. Wherever manager satisfies for employee’s performance.
Ideal location means: – wherever I’ll get new Skills, Knowledge, and act with totally different individuals.
Ideal Job means: – wherever I’ll suppose my theoretical information supported that I’ll get sensible information

Que: Tell about your outstanding experience of your career?
Ans: I was in past company and providing DBA support throughout the night. At that, I used to be alone Oracle DBA in duty with some IT operation guys. At 2:45 AM, I used to be watching all info and same time I found one thing wrong with our one in every of the production database. info crashed and that we got physical corruption during a file that size was around eighty GB. Instantly I attempted to decision my superiors however no one picked my phone. that point I made a decision to revive file from the last backup and commenced recovery method. Before this method, I ended my all standby info of the production database. Recovery method took around four hours for extracting a file from backup, copying, applying archive logs. However, finally, production info was up. Early within the morning, I got a decision from my superiors and that they aghast to listen to concerning this state of affairs. Next day I got appreciation however those half dozen hours were extremely alarming on behalf of me.

Que: Do you have any question for me?
Ans I might wish to grasp the talent you found missing to ME. so I might improve myself to suit for the corporate clearly if I’m selected. If I’m not selected these days, your opinion is going to be serving ME to the future interviews many thanks…

Make to Easy any Tough HR interview

January 29, 2019

Make to Easy any Tough HR interview

Interview questions usually around the base of what he wrote in his biography circulates, and the interviewer asks many questions about their qualifications, experience and academic until I feel much more satisfied with their performance and confidence you can customize your request. Finally, an opportunity, questions or concerns you should ask in an interview. But this is a very important issue that should be much higher.

A reasonable question:

The first basic awareness of the problem in context, would you have enough information to give a clear image or to work or not. While, for example, to remember and gather information about the final “no” when the caller to ask questions? The clock is completely wrong. Also, ask the interviewer asks a good idea, no doubt, increase the employer that you are more interested in the program. However, ask any questions you might ask well-informed if answered, but during the interview. It does not irritate the employer to ask stupid questions.

ESSENTIAL

In addition to his interview questions and answers give you the opportunity to how to analyze. Moreover, in order to identify, formulate the question: Instead of asking, “What role should be to increase the company,” “What man is set to the role of business plans,” because the questions that give you confidence and a good impression of you.

Prepare for questions:

You have to ask a few questions for the interviewer. But think about it, these questions can help employers make a good impression of you. Moreover, it is also an essential market research company, the company develops in the future, and the current level, so if it really helps and gives a good picture of who has studied the company. Avoid stupid questions and clarify questions if you are brave, confident.

Sometimes, some of the questions the interviewers are not looking for the most useful reactions and hopeless, but I really think that the problems are very useful candidates for the character and behavior or apparent danger. These applications are often asked to interview a candidate for the views and thoughts to read.

How become Oracle DBA?

January 23, 2019

I have been getting so many inquiries from the various candidate who are having keen interest to be Oracle DBA. I am providing some information regarding this.

DBA (Database Administrator) is a person who is an expert with exceptional skills required in the fields of database management. These professionals are the worker bees that make sure that the system runs smooth and without any glitches. It is their primary duty to troubleshoot any problem. Especially developed certifications, training and hands-on experience are offered by database product manufacturers to train professionals to handle their products and solutions. DBA is a busy person in a corporate environment, even income corporate structures there are a number of DBAs at a single site. This all depends upon the complexity of the whole system.

DBA professional is a person who is equipped with the latest and up-to-date knowledge of the database system of his own choice. Advance knowledge is then combined with periodical training held by the manufacturer i.e. Oracle, and the final element, experience. Experience is considered to be the most important element, it is the stage when you get personal experience to troubleshoot the database system. A person who lacks any of these three elements would fail in his attempt to be called DBA.

Before purchasing the necessary course materials one should choose the correct database platform to begin. Latest platforms developed and launched by Oracle include the reliable 11g and 10g products. So one needs to choose the course for induction, he has ample choice such as Oracle DBA 11g or Oracle DBA 10g along with necessary Oracle DBA training. Once a person has made up his mind, the next step is to get admission in an authorized training and testing center. This is necessary and is mandatory for beginners. Experienced professionals would be able to benefit from their previous experience.

The route to Certified Oracle DBA is divided into three brief steps. These steps are interconnected and one must complete all three steps to complete his certification. The very first step is Oracle Certified Associate, this is the initial step and is composed of three exams. You must pass at least two to make it to the second step. Oracle Certified Professional is the second step professional, it is necessary to acquire training at this level to qualify for the next final level. Along with training you also need to pass the examination. Once cleared now you move to the final level the Oracle Certified Master, you need to get advanced training and have to pass at least two exams to become the Oracle DBA.

This is a long road but it is very much necessary so that you can actually perform your job. Maintaining and troubleshooting Oracle database systems can only be performed by a certified professional. A huge commercial and corporate firms have giant interlinked database systems that interact around the world. Only a certified person will be able to point out the problem and fix it. Confidence is also boosted with the training that you get in the three qualification levels. You will also get a chance to upgrade your knowledge in future too.

Robert Bruce and the Spider

January 15, 2019

self confidenceThis story I heard so many times from my father in my younger age. It is really self-grooming story. The story is following.

Robert Bruce was the King of Scotland. He was defeated by his enemy. He escaped from the battlefield and ran away to the forest. He was very sad and in despair. At last, he took shelter in a cave.

He tried to come back to his country and make it free. Several attempts were made but all his efforts were in vain. He fought against the enemy several times but was driven back. After his defeat in several wars, he spent his days in utter despair and sorrow. He gave up the idea of fighting more wars.

While he was lying in the cave, he saw a spider. It was trying to climb up the wall. Its aim was to reach up to the top. It made seven attempts to reach the top of the wall but failed. Thought it had failed seven times, it did not give up its efforts. It tried again and again. At last, it succeeded.

Robert Bruce was curiously watching the spider. He learned a lesson from the repeated efforts of the spider and its ultimate success. The king again thought of fighting another war against the enemy. He came out of the cave and organized his army once again. At last, he made a final attack against the enemy. The enemy was defeated and was driven away from his country. Thus Robert Bruce succeeded in his final attempt.

This story I heard lots of time from my father when I failed in some task and sat down with sorrow. My father always told me about Gita’s knowledge “कर्म करो और फल की इच्छा मत करो. क्यों की कर्म करना आप के हाथ में है और फल देना ईश्वर के हाथ में है” If you do not make any effort then how can you get success. It means you need to put efforts again and again until you are getting success. Do not leave your attempt.

I am getting so many responses about the failure to get fresher Oracle DBA job, now what should need to do. I am advising them to try again and again until getting success. Never bother about your failure. Try to concentrate on your mistakes and try to avoid those mistakes in the next attempt. Then you would get success definitely and it is my promise. Always boost up your self-confidence and go ahead for attempting new attempt.

Wish you all the best.

5 Important Basic mistakes during telephonic Interview

January 10, 2019

telephonic interviewNowadays, most of the concerns are bearing telephonic interview as a primary step for the hiring process. To be designated in the telephonic interview is a very significant thing because if you are not selected in this then there are no chances for succeeding to the next step. Most of the people do impractical mistakes and as a result, they are not selected for the interview. Given below are the five basic mistakes during a telephonic interview. These 5 mistakes are very small but very important for all including fresher dba, intermediate dba and expert dba who are having keen interest to search job.

  1. Most of the people are not aware of the purpose of the telephonic interview. Sometimes the telephonic interview is held in the primary round of interview. But, it is for sorting out the candidates for the next step of hiring. So, give the interview showing seriousness. Do not eat anything while you are on phone. If you are eating or drinking, then the interviewer considers that you are not presenting any interest in his words.
  2. Most of the people speak too fast or too slow during a telephonic interview. The average speaking tone must be used. If they are speaking too fast then the interviewer will have to ask for repetition and speaking too slow then interviewer thinks that they are not interested.
  3. Most of the people do not listen to what the interviewer is saying. They must try to listen to each and every word of the interviewer. Active listening plays a very important role in a telephonic interview.
  4. Most of the people give telephonic interview using a mobile connection. Network problem always persists in a mobile connection. Try to use a landline connection while giving a telephonic interview.
  5. There is always a lack of communication interest while in a telephonic interview. The candidate must also questions about the goals and objectives of the company from the interviewer so that the chances of success are more.

3 useful Job Search Tips that boost Your achievement

January 10, 2019

Here I am providing some useful ohhh, very useful Oracle dba fresher job searching tips.

1) Tactic discovery a job as if it were a full-time job because it is. In the event you had a job, you would document to work simultaneously each day (like 8 am), take an hour (or less) for lunch, and quit simultaneously each day (like 5 pm). You would work five days every week. And you would work hard to accomplish as much as you could because your career depended on it.

When you are trying to find a job, you ought to follow the same type of schedule because your future depends on it.

Treating your job search is like part-time diversion assurances that it will take longer.

So, arise tomorrow by broadcasting to work and spending the day on responsibilities that prime to a job.

As you must assume, this is a significant plan. The previous you ample it, the earlier you gain promotion into a job.

2) Tactic discovery a job as if it were a plan. That means you ought to set goals for yourself, make designs, and monitor your progress. You ought to apply all of the tools and skills that you used in your last job to the project of finding your next job.

3) Be your own boss. Set prospects for what you need to achieve, provide direction, and observe your work.

Meet with yourself one time each week to evaluate your performance. I recommend doing this by writing three reports. The first is a candid evaluation of what you accomplished in the coursework of the earlier week. The second is a description of your designs for the approaching week. Your designs ought to include your goals, actions, and priorities.

Next, map out a realistic plan for the next three days based on achievable goals. For instance, you could set objectives for the number of individuals you will call, the number of networking conferences you will appear, and the research you will conduct.

The first time that you write these reports, write an evaluation of what you have finished so far. Portray the results that this work has produced. And compare these results with what you desired to have.

Finding a job is a full-time job. Effort according to with a strategy and the support of a good boss (yourself).

In the approaching weeks, compare the results that you obtained in the coursework of the earlier week with the goals that you set. For example, in the event you planned to attend twelve networking meetings and you attended only three, you ought to a) describe why this happened and b) plan actions that will correct such a difference. You ought to also analyze why you missed your aim because this provides insights on what you need to do differently. For example, your aim (e.g., of attending twelve networking meetings) may have been set high. Or possibly there are things you can do that will make it simpler to accomplish your job search goals, such as carpooling with a friend who is also looking for a job.

I wish you the best of success.