I applied online. The process took 2 weeks. I interviewed at Revature in Nov 2017
Interview
The usual. They called for a get to know you informal phone call where I got a technical interview. I had a week to prepare for the interview . The lady was reading it off the script but she was really nice and was patient with me. The question were purely definitions and a little bit of impromptu SQL statements.
Interview questions [3]
Question 1
SQL
What is DBMS?
- Database management system
What is RDBMS?
- Relational database management system
- Stores data into tables(columns and rows)
- SQL Server is an example of RDBMS
What does SQL stand for?
- Structured Query Language
Who determines the standards for SQL?
- ANSI (American national Standards Institute)
What are the versions of SQL?
- 86th to 2016
Users vs Schemas?
- USERS = SCHEMAS
There are 4 main categories of SQL statements
- DDL(Data definition language)
o CREATE, ALTER, DROP
o In ALTER you can add/remove columns and constraints
o Examples of constraints
♣ Primary key used to ID a row or record, null values are not allowed
• Primary key = unique key + not null constraint
♣ Unique constraint null values are allowed
♣ Foreign key a column in a table that refers to the primary key of another table
♣ Check
♣ Default
♣ Index
♣ Not Null
- DML (Data Manipulation Language)
o SELECT, DELETE, INSERT, UPDATE
o Objects created using DML:
♣ Table
♣ Index it is used retrieve data faster
• Optimizes access to data in a shema
♣ View it is a stored query
♣ Sequence
♣ Synonym
o SELECT: if you are using 2 or more tables:
♣ You need a parent/child or primary key/foreign key relationship
♣ You will also need to use joins when you are getting data from 1 or more tables
♣ Types of joins”
• Inner join
o Returns records that have matching values in both tables
• Left join
o Return all records from the left table, and the matched records from the right table
• Right join
o Return all records from the right table, and the matched records from the left table
• Full join
o Return all records when there is a match in either left or right table
- DCL (Data Control Language)
o Control the level of access that users have
o GRANT, REVOKE
- TCL (Transaction Control Language)
o COMMIT, ROLLBACK
o Savepoint partial rollback
What is the difference between truncate and drop?
- Truncate will keep the table structure and delete the rows and you can’t rollback
o Empties the table
- Drop will drop the entire table
What are set operators?
- They combine two component queries into one result
- Queries containing set operators are called Compound queries
- Examples of set operators
o Union - All distinct rows selected by either query
o Union all - All rows selected by either query, including all duplicates
o Intersect - All distinct rows selected by both queries
o Minus - All distinct rows selected by the first query but not the second
What is the UNION Operator?
- It is used to combine the results of two SELECT statements
- They must have the same number of columns and data types AND be in the same order
What is the difference between ORDER BY and GROUP BY?
- Order by is only for sorting purposes
- Group by used with aggregate functions (COUNT, MAX, MIN, SUM, AVG) to group the result-set by one or more columns
What is the difference between the WHERE and HAVING clause?
- Where is used to filter records from a result
- HAVING is used to filer values from a group
o Used with group by
What is the purpose of JOIN in SQL?
- Combines one or more tables in a relational database
How do you select all rows and columns of a table in SQL?
- SELECT * FROM…
When using NULL..
- ___ IS Null (Correct)
- ___ = NULL (incorrect)
o because null is not equal to null or null is not not equal to null
What is a subquery?
- Query with in a larger query
What are examples of oracle datatypes?
- Char
- Number
- Float
- Integer
- Varchar2
What is normalization?
- It is a process to remove redundancy across tables
- Instead of having multiple of the same fields in different tables you can consolidate them into and ID so you are able to refer to one ID .
Difference between INNER JOIN and OUTER JOIN?
-
What is a foreign/primary key?
- A primary key uniquely identifies each row in a database
o Can’t contain null values!!!
- A foreign key is used to link data between two tables together
Give a simple CRUD query
-
JAVA
What is OOP?
- Is programming based on objects
What are the four pillars of OOP and describe them?
- Inheritance
o Is a parent child relationship where one object gets all the properties and behaviors of the parent object.
o Ex. Dog object can inherit the animal object
- Polymorphism
o Is the ability of an object to take many forms
- Abstraction
o Is the process of hiding certain details and only show the essential features of the object.
- Encapsulation
o Is the process of wrapping code and data together into a single unit
o All interaction is preformed through an object
What does finalize() (finalize method) do?
- Can’t be overridden
What is difference between final and static keywords?
- Final
o Once assigned it can’t be modified
- Static
o Defines class members and it is shared across all instances
How do you create a variable in JavaScript?
- ‘var’ = whatever you want to variable to be assigned to
- ex: var name = ‘keerthi’
What do you use JavaScript for?
- In web pages
What is a stored procedure?
- It is a set of pre-compiled SQL statements
- it is stored in the database
What is the difference between "==" and "===" in Javascript?
- === strictly equality comparison
o meaning the datatypes, you are coming must be the same
- == abstract equality comparison
o the datatypes can be different because both values are converted to a common data type
What is the difference between == and .equals()?
- == is a reference comparison( based on memory addresses)
- .equals() compars the actual vales in the objects
What is Method Overloading?
- A feature that allows a class to have more than one method with the same name as long as the number or the type of input parameters are different.
What is Method Overriding?
- A feature that allows the child class to ‘override’ the parent class’s method and give its own specifications.
- Example: if class dog extends animal. The dog class is able to change the animal class methods specifications.
- You can use the keyword ‘super’ to avoid writing out the generic code twice.
o If you are just adding to the parent method
What are the different access modifiers?
- Private
- Public
- Protected
- Default
What is a Jagged Array?
- An array whose elements are arrays
- “array of arrays”
What are the differences between an Interface and Abstract Class?
-
What's the difference between a list, a Set and a Map?
- They are all interfaces of java
-
What's the difference between an Array List and a Linked List and which is preferable?
- They both implement list interfaces
- Array List uses dynamic array to store elements
o Can act as a list only
o Better for storing data
- Linked List uses doubly linked list to store elements – FASTER
o Can act as a queue and a list
o Better for manipulating data
What is an object, and how is it different from a class?
- An class is a template (blueprint) for creating objects.
- An object is a member or an ‘instance’ of a class
What is a object class?
- It is the parent class of all classes
- All methods in this class are protected
What is a wrapper class?
- A wrapper class wraps around a data type and gives it an object appearance
- Two major uses:
o To convert simple data types into objects
o To convert strings into objects
How do you initialize an object (in Java)?
- By using the new keywords?
- Constructors?
What are undeclared variable in javascript?
- Variables that have been declared with out the keyword ‘var’
-
What are getter and setters?
- They are both methods in java
- Getter gets the value of a variable and setter set the value of a variable.
Can you have multiple catch blocks on a try statement?
-
Can you overload a constructor?
- Yes.
Are strings in Java immutable? Why?
- Yes.
- https://stackoverflow.com/questions/22397861/why-is-string-immutable-in-java
-
What is JVM, JRE, JDK?
- JVM Java virtual machine - abstract
o It is a virtual machine that runs the java bytecodes
- JRE Java runtime environment
o It is the implementation of JVM - physical
- JDK Java development kit - physical
o It contains he JRE and the development tools
What does the "$" mean in JQuery?
- It’s an alias to JQuery
How might one mimic multiple inheritance in Java?
-
What is casting?
- Taking an object of one type and turning it into another object type
What is the different between hashmap and hashtable?
- Hashmap
o Better for non -threaded applications
o Allows 1 null key and any number of null values
- Hashtable
o Is synchronized
o does not allow null keys or values.
What is an interface?
- It is a contract that provides how the class should look/behave like
What is a package?
- It is an organization of classes and interfaces
-
HTML
What is CSS and how is it used in web development?
- CSS stands for cascading style sheets
- It is used to describe how the HTML document looks
How do you insert an image in HTML?
- <img> tag
- and SRC for the source file a
- and if you want to rename the file us ALT
How do you change the background color?
- <bgcolor = …>
What are the different HTML elements?
- <HTML>
- <Head>
- <Body>
- <Title>
- <br> …etc
HTML Tags
- not all of them come in pairs!
What is the use of DOCTYPE in HTML?
-
How could you create a button with HTML?
- <button type=”button”> Click me</button>
How do you comment in HTML?
- <!—comment-->
I applied online. I interviewed at Revature in Nov 2025
Interview
Completed unpaid training program successfully and was placed on a waitlist for payed training. The unpaid program focused on full stack Java development and lasted for around 3 months. The final exam was based on the topics and assesments covered in the program.
Interview questions [1]
Question 1
Are you willing to relocate to any city within the US?
First an aptitude test which was majorly mcqs, quite easy for people with a computer science background but they also allow candidates with non cs to join so it might be the reason. Then you can take part with their unpaid training which they teach in depth over basics upto creating API for backend using Spring and Java then you get enrolled for their paid program waitlist where they contact you if they have a client that fits with you.
It was good. Interviewer asked me questions based on oops, threads, exception handling, SQL . I was interviewed for 25 minutes and all the questions are answerable and at a level of basic to intermediate.
She also asked me a query approach in SQL and also execute a code.
