SQL is both a Data Definition Language and a Data Manipulation Language. Which table statements are meant for defining and managing tables? Which table statements are meant for manipulating the data stored in a table?
ALTER TABLE, CREATE TABLE and DELETE TABLE are all used to manage the structure of your tables from creation and throughout the life of the table. SELECT, INSERT, UPDATE, and DELETE are all used to manipulate the state of the data stored in a table.
What is the general syntax for creating classes in Python?
The general structure for creating a class in Python is as follows: class NewClass(object): def __init__(self): self.instancevariable = 15 def myclassfunction(self, param1, param2) return self.instancevaraible * param1 * param2 The "object" in parentheses in the class header is the parent class of your class. The default is the generic object class that all classes in Python inherit from. The __init__ method is the constructor for your class and provides values to the instance variables of your class. It must have at least "self" as a parameter in order to be able to reference the instance being created.
What are the benefits of Object-Oriented Programming (OOP)?
There are a number of benefits to using OOP instead of procedural-style coding. The majority of the benefits of OOP are products of the necessity that OOP creates for thoroughly thinking through the design of a program before writing any code. Those benefits are: 1. Code Reuse: Because OOP creates logical units of code with data and operations that represent real-world objects, those units are easily included in multiple projects that use similar objects. 2. Data Encapsulation: OOP provides built-in protection for data and allows the designer to prevent clients of their code from manipulating data values in an invalid or harmful way. 3. Implementation Encapsulation: OOP allows others to use your code without needing to know the implementation details which prevents client code from being written in a way that is dependent upon the implementation of a particular piece of code. 4. Software Maintenance: The benefits of encapsulating the implementation of code and code reuse makes maintenance and improvement of legacy code much easier.