Tutor Marked Assignment PL TMA-10
In a Nutshell - CIW Course Section 2 Part B
PL TMA-10 - CD Access Code: 26382
Q1. Relational databases organise data into formally defined what?
- a) Tables
- b) Files
- c) Filehandles
- d) Hashes
Q2. 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
Q3. The Database Driver Module enables you to change databases by installing a different database driver, called a Database Interface Module.
- a) True
- b) False
Q4. 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
Q5. 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
Q6. What method must be called prior to executing an SQL query?
- a) parse
- b) prepare
- c) execute
- d) practice
Q7. 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
Q8. 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)
Q9. 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
Q10. 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