Revature Interview Exam|| Most Recent Exam Actual
Complete Real Verified Exam Questions And Correct
Answers (Verified Answers) Already Graded A+ |
Guaranteed Success!! | Newest Exam!!!
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.;
,2|Page
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.
, 3|Page
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.
How do you change the background color? - Answer-
<background-color>
What are the different HTMl elements - Answer-html,
head, title, body