Revature Interview questions with 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 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>
