Revature
Interview
questions with
100% correct
answers 2024
What is a getter/setter? What is their
purpose? - answer Functions that modify
private variables.
How do you select all tables in a database? -
answer SELECT* FROM sys.Tables
or SELECT*FROMinformation_schema.tables
,How do you link a style sheet to an html
document? - 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? - 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? - 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? - 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 -
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? - 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? - 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? - answer Relational
Database Management Software.
It stored data into columns and rows. SQL
server is an example.
What does SQL stand for? - answer
Structured Query Language
Who determines the standards for SQL? -
answer The American National Standards
Institute
Interview
questions with
100% correct
answers 2024
What is a getter/setter? What is their
purpose? - answer Functions that modify
private variables.
How do you select all tables in a database? -
answer SELECT* FROM sys.Tables
or SELECT*FROMinformation_schema.tables
,How do you link a style sheet to an html
document? - 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? - 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? - 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? - 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 -
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? - 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? - 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? - answer Relational
Database Management Software.
It stored data into columns and rows. SQL
server is an example.
What does SQL stand for? - answer
Structured Query Language
Who determines the standards for SQL? -
answer The American National Standards
Institute
