Revature Interview UPDATED Exam
Questions and CORRECT Answers
What is a getter/setter? What is their purpose? - CORRECT ANSWER - Functions that
modify private variables.
How do you select all tables in a database? - CORRECT ANSWER - SELECT* FROM
sys.Tables
or SELECT*FROMinformation_schema.tables
How do you link a style sheet to an html document? - CORRECT ANSWER - By using
the link element
<link rel="stylesheet" type="text/css" href="css/style.css">
Can we overload or override static methods in java? - CORRECT ANSWER - Yes, we can
overload static methods by having the same method but with different parameters in the sub
class. No, we can't override a static method because static methods are done at compile time
while method overriding only occurs at runtime.
What is override and overload? - CORRECT ANSWER - Override is when you use the
same method in a subclass but modify or add to it, while overload is when you use the same
method in a subclass but you have a different number or type of parameters.
What is an SQL trigger? - CORRECT ANSWER - They are stored programs that are
automatically executed in response to an event, such as inserting a new row in a table.
Name and explain some elements in HTML - CORRECT ANSWER - <a> for creating
hyperlinks,
<br> to create a line break,
<h1> to create a heading
<div>used to divide the page
,<p> used to create a paragraph
<article> to create independent self contained content from rest of page
<header> used to define the header section
<nav> used to define navigation area
<footer> used to define footer Area.;
Tell me about a project you recently worked on? - CORRECT ANSWER - The last major
project i worked on was a website for a arts and crafts business. I had to create an ecommerce
website from scratch without using a CMS or anything like that. I had to create a products page
and link that through php to a mySQL database, and then display all of the products, along with
the price and shipping. I then had to include the total price and integrate a third party credit card
processor. I also had to create a new login portal for customers that would show recent orders,
save credit card information, and allow them to change their information.
What is DBMS? - CORRECT ANSWER - Database management software. It allows users
to create, read, update , and delete data in a database. It stores data in files. It consists of the data,
the database engine that allows data to be accessed and modified,and the database schema, which
defines the database's logical structure.
What is RBDMS? - CORRECT ANSWER - Relational Database Management Software.
It stored data into columns and rows. SQL server is an example.
What does SQL stand for? - CORRECT ANSWER - Structured Query Language
Who determines the standards for SQL? - CORRECT ANSWER - The American National
Standards Institute
What are the versions of SQL? - CORRECT ANSWER - SQL-86 to SQL:2016
What are users vs schemas? - CORRECT ANSWER - A schema is collection of database
objects, including tables, views, sequences, stored procedures, etc. A user owns a schema.
, What is CSS and how does it work? - CORRECT ANSWER - Cascading style sheets. It
styles the website by describing how the HTML elements are to be displayed.
How do you change the background color? - CORRECT ANSWER - <background-color>
What are the different HTMl elements - CORRECT ANSWER - html, head, title, body
What is doctype used for? - CORRECT ANSWER - It tells the browser what version of
markup language is being used.
How can you create a button in HTML? - CORRECT ANSWER - <button
type="button">My Button </button>
How do you comment in HTML? - CORRECT ANSWER - <!-- This is a single line
comment -->
What is MVC? - CORRECT ANSWER - Model View Controller
it consists of three parts"
one that is the visual part that users interact with - the view,
one that represents the object being modeled, and
something that manages data between the different parts - the controller.
What are selectors? List some - CORRECT ANSWER - Patterns used to select the element
you want to change. .class, #id, :visited.
Questions and CORRECT Answers
What is a getter/setter? What is their purpose? - CORRECT ANSWER - Functions that
modify private variables.
How do you select all tables in a database? - CORRECT ANSWER - SELECT* FROM
sys.Tables
or SELECT*FROMinformation_schema.tables
How do you link a style sheet to an html document? - CORRECT ANSWER - By using
the link element
<link rel="stylesheet" type="text/css" href="css/style.css">
Can we overload or override static methods in java? - CORRECT ANSWER - Yes, we can
overload static methods by having the same method but with different parameters in the sub
class. No, we can't override a static method because static methods are done at compile time
while method overriding only occurs at runtime.
What is override and overload? - CORRECT ANSWER - Override is when you use the
same method in a subclass but modify or add to it, while overload is when you use the same
method in a subclass but you have a different number or type of parameters.
What is an SQL trigger? - CORRECT ANSWER - They are stored programs that are
automatically executed in response to an event, such as inserting a new row in a table.
Name and explain some elements in HTML - CORRECT ANSWER - <a> for creating
hyperlinks,
<br> to create a line break,
<h1> to create a heading
<div>used to divide the page
,<p> used to create a paragraph
<article> to create independent self contained content from rest of page
<header> used to define the header section
<nav> used to define navigation area
<footer> used to define footer Area.;
Tell me about a project you recently worked on? - CORRECT ANSWER - The last major
project i worked on was a website for a arts and crafts business. I had to create an ecommerce
website from scratch without using a CMS or anything like that. I had to create a products page
and link that through php to a mySQL database, and then display all of the products, along with
the price and shipping. I then had to include the total price and integrate a third party credit card
processor. I also had to create a new login portal for customers that would show recent orders,
save credit card information, and allow them to change their information.
What is DBMS? - CORRECT ANSWER - Database management software. It allows users
to create, read, update , and delete data in a database. It stores data in files. It consists of the data,
the database engine that allows data to be accessed and modified,and the database schema, which
defines the database's logical structure.
What is RBDMS? - CORRECT ANSWER - Relational Database Management Software.
It stored data into columns and rows. SQL server is an example.
What does SQL stand for? - CORRECT ANSWER - Structured Query Language
Who determines the standards for SQL? - CORRECT ANSWER - The American National
Standards Institute
What are the versions of SQL? - CORRECT ANSWER - SQL-86 to SQL:2016
What are users vs schemas? - CORRECT ANSWER - A schema is collection of database
objects, including tables, views, sequences, stored procedures, etc. A user owns a schema.
, What is CSS and how does it work? - CORRECT ANSWER - Cascading style sheets. It
styles the website by describing how the HTML elements are to be displayed.
How do you change the background color? - CORRECT ANSWER - <background-color>
What are the different HTMl elements - CORRECT ANSWER - html, head, title, body
What is doctype used for? - CORRECT ANSWER - It tells the browser what version of
markup language is being used.
How can you create a button in HTML? - CORRECT ANSWER - <button
type="button">My Button </button>
How do you comment in HTML? - CORRECT ANSWER - <!-- This is a single line
comment -->
What is MVC? - CORRECT ANSWER - Model View Controller
it consists of three parts"
one that is the visual part that users interact with - the view,
one that represents the object being modeled, and
something that manages data between the different parts - the controller.
What are selectors? List some - CORRECT ANSWER - Patterns used to select the element
you want to change. .class, #id, :visited.
