Section 1
Preview this deck
In relational database theory, a table is also known as a:
Front
| 5 | 0 | ||
| 4 | 0 | ||
| 3 | 0 | ||
| 2 | 0 | ||
| 1 | 0 |
Active users
0
All-time users
0
Favorites
0
Last updated
6 years ago
Date created
Mar 1, 2020
Cards (60)
Section 1
(50 cards)
In relational database theory, a table is also known as a:
Relation
The PHP statement $a = new classname("First"); denotes a(n):
Constructor
In a PHP __________, you can group together functionality that may be reused in multiple classes.
Trait
The ___________ MySQL statement allows a specified database user to grant his or her own privileges to others.
WITH GRANT OPTION
In object-oriented programming, __________ are properties or variables that relate to an object.
Attributes
What is represented by the C in the SQL statement SELECT C.Name FROM Customers AS C?
table alias
You can use a(n) ____________ as an alternative to implementing MySQL user passwords.
authentication plugin
What is the definition of a relational database schema?
Complete set of table designs
Which of the following commands do you use to specify which MySQL database you want to use?
USE
Which of the following shows the correct definition of a PHP exception?
throw new Exception($message, $code);
The object-oriented principle of ____________ means that different classes can have different behaviors for the same operation.
Polymorphism
A primary key can consist of ___________ column(s).
one or more
Which of the following is NOT an example of an update anomaly?
Creation
A SQL join with a WHERE clause is known as a:
equi-join
Atomic column values mean that you store only _______ attribute(s) in each row.
1
A(n) ___________ join represents the Cartesian product of two tables in a SQL database.
Full
.A(n) __________ shows which functions were executing at the time the exception was raised.
Backtrace
What is the default PHP class access modifier?
Public
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
Which SQL clause follows INSERT INTO?
VALUES
How do you create a new MySQL database?
create database dbname;
In PHP, the ________ block always is executed after the try and catch blocks.
Finally
You create methods by declaring ________ within a PHP class definition.
Functions
Having many _________ values in your database wastes space and causes problems working out totals.
Null
Which of the following is NOT a built-in method of the Exception PHP class?
getString()
In a relational database table, each value must have the _____________ specified by its column.
data type
Which of the following programming languages does NOT support true multiple inheritance?
PHP
Which of the following shows the correct use of the final PHP keyword?
final function operation() {}
The opposite of the MySQL GRANT statement is:
REVOKE
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
Which of the following MySQL privileges allows users to remove databases, tables, or views?
DROP
In PHP it's considered good coding practice to implement _______ try blocks in your code.
Small
Use the SQL _____________ keyword to perform regular expression matching.
REGEXP
LOCK TABLES is an example of a(n):
administrator privilege
In a database-backed PHP application, the _________ opens a connection to the web database.
PHP engine
In PHP you can have __________ catch block(s) associated with a single try block.
More than one
What is the most commonly used type of database according to the book's authors?
Relational
In the ANSI SQL standard, how many tables can be joined?
Unlimited
In creating your own subclass Exceptions, you can override the ________ built-in function.
toString()
Most of the public PHP exception methods are:
Final
What is the default sort order used by the SQL ORDER BY clause?
Ascending
In PHP, the keyword __________ triggers the exception-handling mechanism.
Throw
Which of the following is a valid MySQL connection command?
mysql -h dbserver -u joe -p
The SELECT ___________ wildcard operator matches all the columns in the specified table or tables.
*
A foreign key should have the same or comparable _________ as its related primary key.
data type
What is phpMyAdmin?
browser-based MySQL management tool
________ are methods, actions, or functions that an object can perform to modify itself or perform some external effect.
Operations
Which of the following WHERE clause operators tests whether two values are not equal?
!=
Section 2
(10 cards)