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_s 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/" 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 divused 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.