MIDTERM IT202
Which clause in a SQL statement specifies the table(s) that should supply the data that is returned? FROM WHERE ORDER BY SELECT
FROM
What type of SQL statement is used to assign user privileges in MySQL? ASSIGN REVOKE GRANT GIVE
GRANT
Which of the following is a SQL statement that you can use to retrieve data from a SQL database? SELECT RESULT GET RETRIEVE
SELECT
When you create a PDO object, you have to pass all but one of these arguments to it: Which one is it? Data source name Your name User name Password
Your name
The intersection of a column and row in a database table can be called a cell plot slot box
cell
When coding relative URLs, you can begin the URL with a single dot (.) to indicate that the URL should start with the ________________ directory. child current parent root
current
A/An ________________ is an object that contains information about an error. exception username MySQL database PDO class
exception
To return an array for the first row of a result set that's returned by a SELECT statement, you use the ________________ method of the PDOStatement object for the result set. fetchFirst() fetch() getFirst() get()
fetch()
Which of the following is a method of the PDOStatement class that returns an array for the next row in a result set? next() getArray() fetch() getRow()
fetch()
To get an array for all rows in a result set, you can call the ________________ method of the PDOStatement object for the result set. getAll() fetch() fetchAll() get()
fetchAll()
Which of the following can be used to get the data from an array that contains all rows of a result set? forall loop roll over foreach statement fetch() method
foreach statement
Which URL can be used to start phpMyAdmin on a local system? http://localhost/phpmyadmin phpmyadmin://localhost http://phpmyadmin.localhost http://phpmyadmin
http://localhost/phpmyadmin
What keyword must you code to create a PDO object? create make pdo new
new
Which keyword is used to create an object from a class in PHP? create instantiate argument new
new
The most common type of relationship between tables in a relational database is many-to-many one-to-one one-to-many
one-to-many
Each row in a table should be able to be uniquely identified by a: cell field name record primary key
primary key
To control what users can do with a database, SQL can be used to assign ________________ to users. passwords permissions keys privileges
privileges
You can use phpMyAdmin to import and run a SQL ________________ that creates one or more databases. include file script file exec file batch file
script file
What attribute of a column determines the data that can be stored in the column? whether it can contain null values the default value the data type whether it's auto-incremented
the data type
To handle exceptions, first you code a/an ________________ around any PHP statements that might throw an exception. method try/catch statement try block MySQL statement
try block
