PHP Welling 6-11

Which of the following WHERE clause operators tests whether two values are not equal?

!=

The SELECT ___________ wildcard operator matches all the columns in the specified table or tables.

*

Atomic column values mean that you store only _______ attribute(s) in each row.

1

What is the default sort order used by the SQL ORDER BY clause?

Ascending

In object-oriented programming, __________ are properties or variables that relate to an object.

Attributes

.A(n) __________ shows which functions were executing at the time the exception was raised.

Backtrace

What is the definition of a relational database schema?

Complete set of table designs

The PHP statement $a = new classname("First"); denotes a(n):

Constructor

Which of the following is NOT an example of an update anomaly?

Creation

Which of the following MySQL privileges allows users to remove databases, tables, or views?

DROP

Which of the following MySQL privileges allows users to run stored procedures and functions?

EXECUTE

Use the _________ keyword to specify that one class is to be a subclass of another.

Extends

Most of the public PHP exception methods are:

Final

In PHP, the ________ block always is executed after the try and catch blocks.

Finally

A(n) ___________ join represents the Cartesian product of two tables in a SQL database.

Full

You create methods by declaring ________ within a PHP class definition.

Functions

In PHP you can have __________ catch block(s) associated with a single try block.

More than one

max_connections is a ____________ parameter that determines the simultaneous MySQL connection limit.

MySQL

Having many _________ values in your database wastes space and causes problems working out totals.

Null

A SQL join with a WHERE clause is known as a:

equi-join

In PHP-MySQL connectivity, what is the purpose of the @ symbol?

error suppression

Which of the following shows the correct use of the final PHP keyword?

final function operation() {}

Which of the following is NOT a built-in method of the Exception PHP class?

getString()

Which of the following is a valid MySQL connection command?

mysql -h dbserver -u joe -p

What is the basic PHP library for connecting to MySQL?

mysqli

Which of the following functions changes the default database?

mysqli_select_db()

A primary key can consist of ___________ column(s).

one or more

MySQL ____________ can speed up query execution as well as protect against SQL injection attacks.

prepared statements

Why is the query $query = "SELECT ISBN, Author, Title, Price FROM Book WHERE $searchtype = '$searchterm'"; problematic?

susceptible to SQL injection

What is represented by the C in the SQL statement SELECT C.Name FROM Customers AS C?

table alias

Which of the following shows the correct definition of a PHP exception?

throw new Exception($message, $code);

In creating your own subclass Exceptions, you can override the ________ built-in function.

toString()

Which of the following commands do you use to specify which MySQL database you want to use?

USE

In the ANSI SQL standard, how many tables can be joined?

Unlimited

Which SQL clause follows INSERT INTO?

VALUES

The ___________ MySQL statement allows a specified database user to grant his or her own privileges to others.

WITH GRANT OPTION

LOCK TABLES is an example of a(n):

administrator privilege

You can use a(n) ____________ as an alternative to implementing MySQL user passwords.

authentication plugin

What is phpMyAdmin?

browser-based MySQL management tool

What is the first step in querying a MySQL database from the web?

check and filter data coming from the user

How do you create a new MySQL database?

create database dbname;

In database connection string terminology, DSN stands for:

data source name

A foreign key should have the same or comparable _________ as its related primary key.

data type

In a relational database table, each value must have the _____________ specified by its column.

data type

The expression $result->free();:

disconnects from the MySQL database

You can use the generic _______ functions if you want to use a database that doesn't already have a PHP library.

ODBC

________ are methods, actions, or functions that an object can perform to modify itself or perform some external effect.

Operations

Which of the following programming languages does NOT support true multiple inheritance?

PHP

In a database-backed PHP application, the _________ opens a connection to the web database.

PHP engine

The object-oriented principle of ____________ means that different classes can have different behaviors for the same operation.

Polymorphism

What is the default PHP class access modifier?

Public

Use the SQL _____________ keyword to perform regular expression matching.

REGEXP

The opposite of the MySQL GRANT statement is:

REVOKE

In relational database theory, a table is also known as a:

Relation

What is the most commonly used type of database according to the book's authors?

Relational

In PHP it's considered good coding practice to implement _______ try blocks in your code.

Small

Which of the following is NOT a valid optional parameter of the PHP Exception class?

Stack trace

What does SQL stand for?

Structured Query Language

In PHP, the keyword __________ triggers the exception-handling mechanism.

Throw

In a PHP __________, you can group together functionality that may be reused in multiple classes.

Trait