SQL Server interview questions What are Sub Query and Corelated Queries Brent Ozar Unlimiteds specialized experts focus on your goals, diagnose your tough database pains, and make Microsoft SQL Server faster and more reliable. Responses to Step by Step Oracle guides tejas patel Says December 8th, 2009 at 1231 pm. DBA. so please help me. Implementing iRecruitment iRecruitment Implementation What type of user does iRecruitment support iRecruitment supports the following types of users. Learn what you need to know to become a SQL Server DBA. Advice, interview tips, SQL resources and much more. Discover what its really like to be a SQL DBA. N recent days this is the most asked question to me by readers. How to get software testing job How to come in software testing field or Can I get job in testingVMware Interview Questions Tough Technical PDFFree VMware v. Sphere Interview Guide. In this VMinstall Guide Ill share a list of 2. VMware interview questions and answers that Ive crafted to screen for the best technical talent to manage and support VMware v. Sphere. Why is my list any different from the hundreds of others on the web Well, first of all, its not a VCP test brain dumpSecondly, these interview questions are carefully crafted to narrow the talent pool to the most qualified, not the most memorized. These interview questions require hands on experience to answer VMware Technical Interview Questions. The list of questions below is intentionally broken up into 5 groups System Requirements for ESXi 5. ESXi 5. 56. x Installation. System Requirements for v. Centerv. Center Installation. Managing v. Sphere Resources. These 5 groups will test for technical proficiency that an experienced VMware administrator will or should have. The list is also what I use when interviewing someone at an administrator level with VMware basics training, who will manage the day to day support, build, and provisioning of v. Center. ESXi hostsvirtual serversvirtual networksvirtual storage. Note This list of questions may also be used for screening v. Sphere Engineers or Architects. System Requirements for ESXi. Your company has a bunch of unused server hardware and you have been asked to build a v. Sphere environment. But before you start you want to make sure it is supported by the ESXi version you plan to install. Where would you find a list of hardware that is supported Answer You would check the VMware Compatibility Guidehttp www. Your hardware is on the compatibility list and now you need to know what the minimum CPU and memory requirement of an ESXi host when building a 6. OS that will take full advantage of ESXi features Answer 2 CPU Cores and 8 GB memory bare minimumBefore you start installing software what must be enabled in the server BIOS in order to run ESXi Answer The NXXD bit needs to be enabled. You also have an old pile of network adapters to choose from. Where would you find a list of network adapters NIC that are supported by the version of ESXi you are installingAnswer You would check the VMware Compatibility Guide same link as aboveOne of the servers you found wasnt on the list and now you have a problem that is causing ESXi to purple screen so you call VMware for support. What would happen if they found out your hardware was not supported Answer When hardware is not supported there are known issues that will happen and VMware cannot help to resolve problems due to unsupported hardware. Unpacking the ESXi hardware interview questions. Why are these questions about server hardware important Since 2. I have had the awful job of having to clean up behind admins that would build v. Center and ESXESXi on any hardware they found. Im guilty of it myself This is not only a bad practice but it also leads to unplanned maintenance and costly outages that impact users and customers. ESXi will run on just about any hardware but that doesnt mean it should. An experienced v. Sphere admin will know better than to waste time and a costly license trying to run a 6. OS on a server that doesnt support it. ESXi Installation Qs. Youve done this a hundred times. What are 3 methods that can be used when doing an Interactive ESXi installation Answer Boot from a CDDVD, boot from a USB, and PXE boot from a deployment server on the network. After so many ESXi builds you have figured out a faster way to do the install using a script. Whats the main difference between an interactive ESXi installation and a scripted installation Answer The interactive install will require you to follow along and fill in the configuration information whereas, in a scripted install, the configuration information will be queried from an unattended text file boot. Note ESXi uses a Kickstart installer similar to Linux. You can install ESXi in your sleep. What is the command to access the installer window on ESXi 5. Answer ShiftO will get you to the runweasel command prompt. Darn, one of your servers is not loading. Whats the first thing to double check when having a problem installing ESXi Answer Make sure the hardware clock is set to UTC and the NXXD bit is enabled in the BIOS. Youve typed this stuff in a million times. Name 5 of the 1. 0 bits of information required when installing ESXi Answer Keyboard Layout, VLAN ID, IP Address, Subnet Mask, Gateway, Pri DNS, Sec DNS, Host Name, Installation Location, Root Password. Now lets unpack VMware interview questions about ESXi Installations. ESXi is actually easy to install and setup however, problems do arise when there are different admins or teams building out environments that share the same network, storage, and server resources. It is very important to have a standard build process so all hosts are built the same way every time. Finding a good v. Sphere admin who can follow your standard, someone who can answer these basic questions, is a good start. System Requirements for v. Center. You decided not to run the v. Center appliance. Whats the minimum hardware requirements for a v. Center 5. x6. x serverAnswer It depends on whether other v. Sphere services such as single sign on, inventory service, and the database will be running on the same hardware with v. Center. Youre going to upgrade v. Center and the old v. Center is running on Windows Server 2. What Windows Operating System is required for v. Center 5. x6. x Answer Windows 2. SP2. Youre creating a list of ports you need the network admin to open on the firewall. What is port 9. 02 used for on v. Center Answer Port 9. Center uses to send data to hosts managed by v. Center. The old v. Center was running MS SQL Express but you are building 1. Installer Windows 7 Sur Vista Sans Cdi. ESXi hosts. Whats the difference between using MS SQL Server Express and MS SQL Server for v. Center Answer MS SQL Server Express is for v. Sphere installations with up to 5 ESXi hosts and 5. Your new boss doesnt like MS SQL and asked you to use Oracle. Does v. Center support Oracle 1. Answer Yes, but the JDBC driver must be installed manually. Lets review v. Center Interview Questions. Center is at the heart of v. Sphere and when its not properly setup there will be problems These problems may be as small as a frustrated admins who cant access and support virtual servers from a central management console. Or as large as a full blown outage and corruption of the v. Center database. For example, if a v. Sphere clouds grows too fast the additional load on hardware and system resources can cause performance problems that in worst cases can require a complete rebuild of v. Center on bigger hardware. Fortunately, each ESXi host can be managed separately if central management via v. Center is lost. An experience v. Sphere admin who can answer these questions will likely know this work around. Managing v. Center Resources. Before we dive into the final 1. I want to stress how important finding a team player that will work closely with storage and network admins really is. Tip Pay close attention for any sign that the person you are interviewing does not think heshe owns your v. Sphere Cloud Storage is everything Youve learned over the years theres more to v. Sphere than server hardware. What other 2 resources are just as important as servers and need to be properly planned out when designing and building a v.