PHP Exam Questions with Correct
Solutions
User management - Answer-is the process of controlling which users are allowed to connect to the
MySQL server and what permissions they have on each database.
phpMyAdmin does not - Answer-handle user management, rather it passes the username and password
on to MySQL, which then determines whether a user is permitted to perform a particular action.
Within phpMyAdmin, administrators have - Answer-full control over creating users, viewing and editing
privileges for existing users, and removing users.
Within phpMyAdmin, user management is controlled via - Answer-the Users link from the main page.
Users can be created, edited, and removed.
To creating a new user - Answer-1) click the Add a new user link near the bottom of the Users page (you
must be a "superuser", e.g., user "root").
2) Use the textboxes and drop-downs to configure the user to your particular needs. 3) You can then
select whether to create a database for that user and grant specific global privileges.
4) Once you've created the user (by clicking Go), you can define that user's permissions on a specific
database (don't grant global privileges in that case). In general, users do not need any global privileges
(other than USAGE), only permissions for their specific database.
, To edit an existing user - Answer-simply click the pencil icon to the right of that user in the Users page.
You can then edit their global- and database-specific privileges, change their password, or even copy
those privileges to a new user.
To deleting a user - Answer-From the Users page, check the checkbox for the user you wish to remove,
select whether or not to also remove any databases of the same name (if they exist), and click Go.
to assigning privileges to user for a specific database - Answer-Users are assigned to databases by
editing the user record (from the Users link on the home page) not from within the Users link under the
table. If you are creating a user specifically for a given table you will have to create the user first (with no
global privileges) and then go back and edit that user to add the table and privileges for the individual
table.
PHP is an acronym for - Answer-PHP is an acronym for "PHP:
PHP files can contain - Answer-text, HTML, CSS, JavaScript, and PHP code
PHP code are executed on - Answer-on the server, and the result is returned to the browser as plain
HTML
PHP files have extension - Answer-".php"
PHP runs on various platforms - Answer-(Windows, Linux, Unix, Mac OS X, etc.)
PHP supports a wide range of databases - Answer-True
PHP is free - Answer-True
Solutions
User management - Answer-is the process of controlling which users are allowed to connect to the
MySQL server and what permissions they have on each database.
phpMyAdmin does not - Answer-handle user management, rather it passes the username and password
on to MySQL, which then determines whether a user is permitted to perform a particular action.
Within phpMyAdmin, administrators have - Answer-full control over creating users, viewing and editing
privileges for existing users, and removing users.
Within phpMyAdmin, user management is controlled via - Answer-the Users link from the main page.
Users can be created, edited, and removed.
To creating a new user - Answer-1) click the Add a new user link near the bottom of the Users page (you
must be a "superuser", e.g., user "root").
2) Use the textboxes and drop-downs to configure the user to your particular needs. 3) You can then
select whether to create a database for that user and grant specific global privileges.
4) Once you've created the user (by clicking Go), you can define that user's permissions on a specific
database (don't grant global privileges in that case). In general, users do not need any global privileges
(other than USAGE), only permissions for their specific database.
, To edit an existing user - Answer-simply click the pencil icon to the right of that user in the Users page.
You can then edit their global- and database-specific privileges, change their password, or even copy
those privileges to a new user.
To deleting a user - Answer-From the Users page, check the checkbox for the user you wish to remove,
select whether or not to also remove any databases of the same name (if they exist), and click Go.
to assigning privileges to user for a specific database - Answer-Users are assigned to databases by
editing the user record (from the Users link on the home page) not from within the Users link under the
table. If you are creating a user specifically for a given table you will have to create the user first (with no
global privileges) and then go back and edit that user to add the table and privileges for the individual
table.
PHP is an acronym for - Answer-PHP is an acronym for "PHP:
PHP files can contain - Answer-text, HTML, CSS, JavaScript, and PHP code
PHP code are executed on - Answer-on the server, and the result is returned to the browser as plain
HTML
PHP files have extension - Answer-".php"
PHP runs on various platforms - Answer-(Windows, Linux, Unix, Mac OS X, etc.)
PHP supports a wide range of databases - Answer-True
PHP is free - Answer-True
