Web Application Architectures - Self Study Questions

The class is cancelled this week. Please use this opportunity to catch up with Java and
Web Development if you did not study/work in this area before. The questions asked
here are mostly technical questions. You may try to write programs to help answer
your questions.


Java Questions

What is the difference between procedural and object-oriented programs?
What are Encapsulation, Inheritance and Polymorphism?
What is the difference between Assignment and Initialization?
What are Class, Constructor and Primitive data types?
What is an Object and how do you allocate memory to it?
What is the difference between constructor and method?
What are methods and how are they defined?
What is casting?
What is method overloading and method overriding?
What is meant by Inheritance and what are its advantages?
What is the difference between this() and super()?
What is the difference between superclass and subclass?
What is an abstract class?
What is the difference between Integer and int?
What is the difference between abstract class and interface?
What is the difference between Array and vector?
What is the difference between exception and error?


Web Questions

How do you edit and debug an HTML file?
What is the difference between an HTTP GET and HTTP POST?
What is the full structure of a URL (URI)?
What is a domain name?
What is an IP address?
What is the default HTTP port and how can this port be changed from both client side
and server side?
What kind of HTTP request does the <a href="url">text</a> generate?
What are the typical tags that are used to create an HTML form?
How can you create an HTML table with 3 columns and 5 rows?
What are the common user behaviors when they are browsing a web page?
What is JavaScript and why is it used?


Database Questions

What is SQL?
What are SELECT, INSERT, and UPDATE statements?
How can you compare a part of the name rather than the entire name?
What is ERD?
What is primary key?
What is foreign key?
What are DDL and DML?
What is a database schema?
How do you execute a DDL script in MySQL?
In a typical database system for a grocery shop, how do you find out the following
information using a SELECT statement: Confectionery Brand, Unit Price, Supplier’s
Name, and Stock Level?