- Tell me about yourself.
- What types of development environments have you used in the past?
- What would you do if you were asked to perform a task and weren't sure how to complete it?
- Can you tell me about a work situation where you delivered excellent customer service?
- Can you give me an example of a time that you’ve been flexible in a workplace?
- What makes you stand out as a candidate?
- Tell me how the internet works.
- Pretend I’m not a tech person. Can you explain Application Support in simple terms?
- What is the difference between a GUI and a CLI?
- What’s your process in troubleshooting a crashing application?
- How would you go about automating your systems weekly maintenance tasks?
- What is OOP?
- what is an interface?
- What is class?
- Tell me about constructors.
- What is an object?
- What are methods?
- How do you instantiate an object from a class?
- What is the difference between final and finally?
- What is the difference between Arrays and ArrayLists?
- What is a database?
- What is database management software?
- What is DDL/DML?
- What is the difference between SQL and MySQL?
- How do you write a SQL SELECT statement?
- What is a primary key?
- How does an INNER JOIN work?
- What is normalization? What is its purpose?
- What is ITIL?
- What are some of the main benefits to implementing ITIL in an organization?
- You are an employee working at the help desk of a large technology company. You receive a ticket from a user requesting help, stating that they cannot reach the company website. What might be a possible cause of this?
- What are some of the guiding principles of the ITIL framework?
- What is SSH? How is it useful to us in the context of Linux?
- What is the difference between UNIX and Linux?
- Explain the UNIX architecture . What are the different pieces?
- What are the three types of data streams in BASH?
- What is the UNIX command to change permissions of a file or directory?
- How would I set up a database server? What are my options?
- What is PL/SQL, how is it different from SQL?
- What is the difference between a Stored Procedure and a Function?
- What is a trigger?
- What is the difference between a primary and foreign key constraint?
- What is WebLogic?
- In WebLogic, and other servers, we have the ability to create clusters. What is a clu ster? And what is the benefit of using them?
- What are some of the ways to monitor the performance of your WebLogic server?
- What is Tomcat used for?
- How are web applications deployed on Tomcat?
- How can we monitor the performance of our Tomcat server?
- What is one tool that can be used to monitor alerts and the status of devices on a network?
- What are Job Codes in Linux/Unix?
- What is an example of a CRON job?
- What are some of the ways to check the health/status of an application?
a. Name a few Object Oriented programming languages b. How is OOP different from a Procedural language like C c. Name 4 key concepts from OOP
a. Given an array of numbers, describe a logic to find the smallest number b. Given an array of Strings, describe a logic to find the total number of Strings with length less than 5 characters
a. Write the logic in 2(b) above in the form of a program with 2 functions, one for finding the length of a string, and another for finding the number of strings with less than N characters.
a. In the following code find the error:
String[] myList = [“red”,”blue”,”green”];
for (int i=0; myList.length; i++);
if (myList[i] == “blue”) print “Found blue\n”;b. Write a BASH script that prompts a user for their name, stores it to a variable, prompts a user for their age, stores it to another variable, and finally prints out a string with the values of the variables.
a. What are the different parts of a database connection string
a. Given a Company table with a list of all Companies in a state (fields: Name, Address, City, Zip, Phone), write a query that counts all the Companies within a given zip code.
a. Continuing with the above example, there is another table “Employees” with fields: company_id (referencing the Company table), Employee Name, Title, Phone, Position Type (P=part-time, F=Full-time), list all employees of a company within a specific zip code. b. Find the number of companies by zipcode and the number of employees per company by Position Type (P, F).
a. In 3(a) change the query to find all zipcodes starting with 5, 6, or 7
a. What is the difference between DML and DDL b. Give one example of each
a. What is the command to show queries currently running against the database?
Noice