Page 31 - Open Soource Technologies 304.indd

Open Source Technologies

Notes 2.4 Keywords

Grant Command: This is the simplest method for adding new users.

Column: You cannot create a table without specifying any column name.
Flush: Privileges command is used to reload the privileges tables.
Revoke: Command is used to remove the privileges.

Table: A table must have atleast one column.

Explain directory listing of My SQL applications.

2.5 Self Assessment Questions

1. The simplest method for adding new users is _______________ command.
(a) Revoke (b) Insert
(c) Grant (d) Update

2. _______________ command is used to remove the privileges.
(a) Grant (b) Insert
(c) Update (d) Revoke

3. Users can drop (delete) tables and databases through.
(a) Delete (b) Drop
(c) Insert (d) Alter

4. _______________ is used to import or dump data.
(a) File (b) Select
(c) Flush (d) Delete

5. The FLUSH PRIVILEGES command in the My SQL monitor to ___________ the privileges
table.

(a) Insert (b) Reload
(c) Delete (d) Drop

2.6 Review Questions

1. How will you connect SQL to the server?
2. How will you create a database?
3. What is CREATE TABLE?

4. Explain two-step authentication process.
5. What do you mean by GRANT Command and give its syntax?

26 LOVELY PROFESSIONAL UNIVERSITY