Oracle Interview Questions

1. Explain the difference between a hot backup and a cold backup and the benefits associated with each.

A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. A cold backup is taking a backup of the database while it is shut down and does not require being in archive log mode. The benefit of taking a hot backup is that the database is still available for use while the backup is occurring and you can recover the database to any point in time. The benefit of taking a cold backup is that it is typically easier to administer the backup and recovery process. In addition, since you are taking cold backups the database does not require being in archive log mode and thus there will be a slight performance gain as the database is not cutting archive logs to disk.

2. You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

I would create a text based backup control file, stipulating where on disk all the data files were and then issue the recover command with the using backup control file clause.

COMMON INTERVIEW Q&A

1. Tell me about yourself:
The most often asked question in interviews. You need to have a short
statement prepared in your mind. Be careful that it does not sound
rehearsed. Limit it to work-related items unless instructed otherwise.
Talk about things you have done and jobs you have held that relate to
the position you are interviewing for. Start with the item farthest
back and work up to the present.

2. Why did you leave your last job?
Stay positive regardless of the circumstances. Never refer to a major
problem with management and never speak ill of supervisors, co-workers
or the organization. If you do, you will be the one looking bad. Keep
smiling and talk about leaving for a positive reason such as an
opportunity, a chance to do something special or other forward-looking
reasons.

.Net Interview Questions And Answers for freshers and experienced

Questions : 1

What is Code Access Security (CAS)? How does CAS work?

Answers : 1

CAS is the part of the .NET security model that determines whether or not a piece of code is allowed to run, and what resources it can use when it is running. For example, it is CAS that will prevent a .NET web applet from formatting your hard disk. The CAS security policy revolves around two key concepts - code groups and permissions. Each .NET assembly is a member of a particular code group, and each code group is granted the permissions specified in a named permission set. For example, using the default security policy, a control downloaded from a web site belongs to the 'Zone - Internet' code group, which adheres to the permissions defined by the 'Internet' named permission set. (Naturally the 'Internet' named permission set represents a very restrictive range of permissions.)

25 IMPORTANT INTERVIEW TIPS:

1. Arrive a little early. If you arrive about fifteen minutes before the scheduled interview time, you will have time to collect your thoughts, wipe the perspiration from your hands, and scan the lobby for current company information.  You will also show your interviewer that you value his or her time.
2. Do your homework. Know the interviewer's name and how to pronounce it (including proper title: Mr., Mrs., Dr., etc.). Know the company's major products or services, the organization of the company (divisions, parent company, etc.), current business news about the company and the company's major customers and competitors. You can learn most or all of this information from the company's website, annual report or company literature.

Sample Interview Questions:

• Tell me about yourself... (Your answer should contain much more about your job skills than your personal life.) Talk about the growth of your career, what you learned from previous employment or even things like how your volunteer worked help you develop your organizational, time management and leadership skills.
  
• What are your strengths? (If you really enjoy new challenges and tackle them in an organized manner, this would be a useful strength in almost any situation.)  You can talk about your ability to find unique solutions to problems.  Be prepared with some concrete examples, since that may be the follow-up question.

15 Popular Interview Questions Answered

1)  Tell me a little bit about yourself.



Oh, yes, this is the question that is most likely to be asked first. I call it a two minute commercial about yourself. This is a great opportunity to sell yourself to the school
district representatives. Keep in mind, if it is the first question asked, it will set the stage for the interview, so it needs to be extremely strong. Don’t be too modest. This will provide an overview, an introduction, to you. You might start by stating, “As you can see from my resume….” and then mention your degrees and certifications and give a quick run down of your relevant experience. The last 1 ½ minutes should be used to communicate your strengths and skills and what you can do to enhance education in their district. In other words, they are asking “Why should we hire you?” Practice this carefully. You need a few sentences that answer that question at the end of your response. Also, at the end, you may want to mention why you would enjoy working for the school district in the position for which they are hiring.





6 Common Teacher Interview Questions and How to Answer Them

1. Tell us about yourself.

This will be among the first common teacher interview questions at almost every in-person. Just give a brief background in about three sentences. Tell them what colleges you graduated from, what you're certified to teach, what your teaching & working experiences are, and why you'd love the job.

2. How do you teach to the state standards?

If you interview in the United States, school administrators love to talk about state, local, or national standards! Reassure your interviewer that everything you do ties into standards. Be sure the lesson plans in your portfolio have the state standards typed right on them. When they ask about them, pull out your lesson and show them the close ties between your teaching and the standards.