REVATURE EXAMINATION TEST 2026
QUESTIONS WITH SOLUTIONS GRADED A+
◉ 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
◉ What are the versions of SQL? Answer: SQL-86 to SQL:2016
◉ What are users vs schemas? 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? Answer: Cascading style sheets.
It styles the website by describing how the HTML elements are to be
displayed.
QUESTIONS WITH SOLUTIONS GRADED A+
◉ 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
◉ What are the versions of SQL? Answer: SQL-86 to SQL:2016
◉ What are users vs schemas? 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? Answer: Cascading style sheets.
It styles the website by describing how the HTML elements are to be
displayed.
