Section 1
Preview this deck
PDO Offers: a) Fast access to databases b) Multi-database support c) Built in security d) All of the above
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 14, 2020
Cards (84)
Section 1
(50 cards)
PDO Offers: a) Fast access to databases b) Multi-database support c) Built in security d) All of the above
d) All of the above
After every PDO operation, one of two results are returned.
True
public function count($number) { return $number + 2; } count($amount); In the code above, $number is a parameter and $amount is an argument
True
To retrieve the number inserted into the auto incremented field, use the lastId() method
False
public function accountQuery() { return $balance; } The above code will return the value of the 'balance' property
False
Abstract methods have a method signature but no body.
True
Each object of the same class has the same properties and methods
True
PDO has support for more than twelve databases
True
PDO is designed to replace MySQLi
True
Objects have properties also known as behaviour
False
The acronym PDO stands for: a) PHP Decadal Oscillation b) PHP Data Objects c) PHP Designation of Origin d) PHP Development and Operation
b) PHP Data Objects
All properties values of the same class are equal
False
A global variable can be declared however it is not recommended
True
PDO Supports every major database system
True
Single inheritance is when a subclass inherits properties and behavior from a single superclass.
True
PDO has been available since PHP 5.0
True
To get the number of row returned from a query operation use the numRows() method
False
public function count($number) { return $number + 2; } count($amount); In the code above, $number is an argument and $amount is a parameter
False
The parent keyword can be used to access properties or methods of a superclass from a subclass.
True
The self keyword refers to the current object.
False
PDO offers unified interface to access many different databases.
True
A parent class is also known as a superclass.
True
To access a static property use the Object Operator (->)
False
API's are used by programmers to interact with a class.
True
Accessor methods are used to modify values of properties
False
Every object of a class can access a static property of the same class.
True
Abstract methods must be implemented in all classes which inherit them.
True
Instantiation is the process of creating an object of some class
True
Mutator methods are used to modify values of properties
True
Using the private visibility modifier allows you to access methods and properties from outside the class
False
CRUD operations are the most common operations implemented in software
True
Static methods belong to the class rather than an object of a class.
True
To get all results into an associative array from a select SQL query use: a) fetchAll(PDO::FETCH_ASSOC) b) fetch_array(PDO::FETCH_ASSOC) c) fetch(PDO::FETCH_ASSOC) d) fetchAll_array(PDO::FETCH_ASSOC)
a) fetchAll(PDO::FETCH_ASSOC)
class OnlineStore { public $inventory = $inventory + 10; } The above code is will produce an error
True
Protected access offers as much security as private so it is recommended that you use protected visibility whenever possible.
False
Subclasses inherit all properties and methods defined in its superclass.
True
PDO offers multi-database support.
True
The keyword 'create' is used to create an instance of a class
False
public function accountQuery() { return $this->balance; } The above code will return the value of the 'balance' property
True
$sql = "SELECT * FROM movies"; $result = $dbc->query($sql) if ($result==false) { } In the above statement, if $result is FALSE, then there are no records in the 'movies' table.
False
Abstract may have public or private visibility.
False
Abstract classes are meant to be extended
True
echo $johnsSavingsAccount->$type; The above code will output the value stored in property 'type'
False
Instantiation must be performed within the class definition
False
If you want to track the number of objects that have be instantiated, use a static property
True
When extending a class with abstract methods, the actual method must be defined with the same number of arguments.
True
Most object oriented languages do not support inheritance.
False
Multilevel Inheritance is when a subclass inherits from another subclass.
True
PDO is short for: a) PHP Database Oriented Programming b) PHP Database Object c) PHP Data Operations d) PHP Data Object
d) PHP Data Object
Having a query with placeholders, you have to prepare it, using the PDO _________ method. This function will return the same PDOStatement object, but without any data attached to it. a) pdoprepare() b) prep() c) prepare_statement() d) prepare()
d) prepare()
Section 2
(34 cards)