Computer Science > QUESTIONS & ANSWERS > Revature Interview questions (All)

Revature Interview questions

Document Content and Description Below

Revature Interview questions What is a getter/setter? What is their purpose? - ✔✔Functions that modify private variables. How do you select all tables in a database? - ✔✔SELECT* FROM sys.Tab ... les or SELECT*FROMinformation_schema.tables How do you link a style sheet to an html document? - ✔✔By using the link element <link rel="stylesheet" type="text/css" href="css/style.css"> Can we overload or override static methods in java? - ✔✔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? - ✔✔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? - ✔✔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 - ✔✔<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? - ✔✔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? - ✔✔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? - ✔✔Relational Database Management Software. It stored data into columns and rows. SQL server is an example. What does SQL stand for? - ✔✔Structured Query Language Who determines the standards for SQL? - ✔✔The American National Standards Institute What are the versions of SQL? - ✔✔SQL-86 to SQL:2016 What are users vs schemas? - ✔✔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? - ✔✔Cascading style s [Show More]

Last updated: 3 years ago

Preview 1 out of 16 pages

Buy Now

Instant download

We Accept: