Page 249 - Open Soource Technologies 304.indd

Open Source Technologies

Notes 14.4 Keywords

Column Level: Column privileges apply to single columns in a given table.
Database Level: Database privileges apply to all tables in a given database.

Global Level: The global privileges apply to all databases on a given server.
Table Level: Table privileges apply to all columns in a given table.

$ dhost: $ dhost is the name of MySQL server. When your webserver is on the same machine
with the MySQL server you can use localhost or 127.0.0.1 as the values of $ dhost.

1. Using SQL statements, create stored parameter.

2. Create a database of hospital management.

14.5 Self Assessment Questions

1. Data Reader command is used to fetch the data one row at a time.

(a) True (b) False
2. _____________ operates in client/server architecture.
(a) MySQL (b) Telnet

(c) PHP (d) DOS
3. The _____________ privileges apply to all databases on a given server.

(a) database (b) GRANT
(c) global (d) table

4. The _____________ statement allows you to create a table within the current database.
(a) edit table (b) create table
(c) open table (d) none of these.

5. A table must have at least _____________ column.
(a) five (b) two
(c) four (d) one

14.6 Review Questions

1. Write steps to opening and closing a connection to MySQL database.

2. Explain Linux system.
3. What are the steps to create database?

4. What is the difference between DROP and DELETE table?

5. What do you mean by Backing up a Database?

244 LOVELY PROFESSIONAL UNIVERSITY