Server Side WEB Development. Unit 2. Working with databases.

Question 1

The mysqladmin tool can be used to perform administrative tasks, but not to run queries on database contents

Accepted Answer

True

Question 2

In the default transaction mode, it is possible to revert changes that are applied when executing an action query

Accepted Answer

Not always. It depends on whether the engine supports transactions or not.

Question 3

What is the default behaviour of the "fetch" method?

Accepted Answer

Returns an array with numeric and associative keys

Question 4

Which of these administration tools use a command line interface?

Accepted Answer

Both answers are correct

Question 5

What programming interface(s) does the MySQLi extension support?

Accepted Answer

Two programming interfaces: procedural and object-oriented

Question 6

phpMyAdmin and MySQL Workbench are web-based administration tools.

Accepted Answer

False

Question 7

If you want to know whether or not a record exists in a database table, which command line tool can you use?

Accepted Answer

mysql

Question 8

To establish a connection to MySQL using PDO, where can the TCP port number be specified?

Accepted Answer

In the DSN string indicating the data source

Question 9

The "fetch" method can return arrays with numeric or associative keys or objects

Accepted Answer

True

Question 10

What does the acronym PDO refer to?

Accepted Answer

A PHP extension that allows access to several database managers

Question 11

Which option would it be advisable to use to execute a query that returns a huge amount of data?

Accepted Answer

MYSQLI_USE_RESULT

Question 12

In the default transaction mode, it is possible to revert changes that are applied when executing an action query

Accepted Answer

False

Questions 12