Here is a copy of my whole report


Student Progress Report

Name College No Assignment Result Wayne
CW PL TMA10 90%

Number of times you have connected to Student World: 338
The date of your last visit to Student World: Friday, 29th June, 2007

Please continue to connect to Student World on a regular basis.


You can now vote for Tutor Team Member of the Month via Student World. From Student World, please go to Classroom, then choose Cyberclass and from there select the Tutor Team Member of the Month link from the middle column. We very much value your opinion, so please make sure you enter your vote for Tutor Team Member of the Month.

In addition, we have Student of the Month. As recognition of their achievements the winner of Student of the Month will receive a new PC, plus two runners-up will receive PC World vouchers, so this is certainly worth entering. You can do so within Student World: go to Classroom, then choose Cyberclass and select the Student of the Month Competition Entry.


Thank you for submitting your work for Tutor Marked Assignment 10. Your work for this assignment is enclosed.

Excellent result, well done. You obviously studied very hard to get this result; excellent. There are just a few small points that I would like to bring to your attention, these are noted below. If you have any queries on these please do not hesitate to contact me. I look forward to receiving your work for Tutor Marked Assignment 11 next.

The access code for your next assignment is: 29175


Question 01: Relational databases organise data into formally defined what?
A tables
B files
C filehandles
D hashes

Your answer, tables (A), is correct. A table can be thought of as a two-dimensional entity containing records in columns and rows. Data can be accessed concurrently. A table contains data that may relate to data in other tables.



Question 02: Most databases support some form of SQL. What does SQL stand for?
A Simple Question Language
B Structured Question Language
C Simple Query Language
D Structured Query Language

You said Structured Query Language (D), which is the right answer. Structured Query Language commands are used by the Database Interface module (DBI) to query databases. The DBI is composed of a common set of commands that facilitate the interaction of a Perl script with any database.



Question 03: The Database Driver Module enables you to change databases by installing a different database driver, called a Database Interface Module.
A true
B false

You said false (B), which is the correct answer. The Database Interface Module (DBI) enables you to change databases by installing a different database driver called a Database Driver Module (DBD). The DBD interacts directly with the database.



Question 04: The _______ consists of a thin layer of method calls that are sent to a database specific driver for the database. The _______ translates the method calls into native methods for the target database.
A DBI, SQL
B DBD, SQL
C DBD, DBI
D DBI, DBD

The correct answer is DBI, DBD (D), as you selected. Data can flow in both directions. The results are returned through the DBD layer to the DBI layer. The data is then passed to the Perl program.



Question 05: What is the minimum number of parameters the dbi->connect() method requires to connect to a database?
A one
B two
C three
D four

Your answer, three (C), is incorrect. Revise the connect Method topic within your course material and let me know if you have further trouble. The correct answer is one (A).



Question 06: What method must be called prior to executing an SQL query?
A parse
B prepare
C execute
D practice

The correct answer is prepare (B), as you selected. The prepare method of the database connection object parses the SQL statement, validates it, and returns a reference, known as a statement handle, $sth. After you have prepared an SQL query, it must be executed.



Question 07: What extra information is required when connecting to a database which is located on a different server?
A host name
B network name
C port number
D username
E password

You said host name which is correct. This is the name of the computer which runs the database server.

And port number which is also correct. The port number will depend on the database involved and its individual setup.



Question 08: SQL has three types of commands, which are:
A Data Description Language (DDL)
B Data Definition Language (DDL)
C Data Query Language (DQL)
D Data Creation Language (DCL)
E Data Manipulation Language (DML)
F Data Management Language (DML)

You said Data Definition Language (DDL) which is correct. Data Definition Language, DDL, is the part of SQL that is used to create a relational database, modify the database structure after it has been created, and delete it when it becomes obsolete. DDL provides the structure that contains the data and defines the data types for the columns in the table.

And Data Query Language (DQL) which is also correct. Data Query Language (DQL) allows you to query the database for information that matches the criteria you specified.

And Data Manipulation Language (DML) which is also correct. Data Manipulation Language (DML) allows you to enter data into a database, change data, or delete data from a database, using the INSERT, UPDATE and DELETE command types.



Question 09: When creating a new database table, UNIQUE, NOT NULL and PRIMARY KEY are all known as what?
A criteria
B caveats
C constricts
D constraints

Your answer to this question was constraints (D), which is correct. Constraints are optionally applied to the different fields within a database table when it is initially constructed. A constraint is a rule that all the data in that column must follow.



Question 10: The underscore used in a select query represents a single character and the asterisk represents any character or string of characters.
A true
B false

Your answer, false (B), is the right one. Although the asterisk is commonly used in applications as a wildcard character, representing any character or strings or characters, in SQL the percentage sign is used instead.