Page 90 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Unit 5: Integrity Constraints

6. "DCL statements begin with one of the following keywords: GRANT, or REVOKE". Discuss Notes
the reason behind this.
7. "Programs written in the host language can use the embedded SQL syntax to access and
update data stored in a database." Explain
8. "REVOKE permissions on tablename from username" discuss the use of this command.
9. CREATE TABLE sales_order

(s_order_no varchar2(6) PRIMARY KEY,
s _order_date date, client_no varchar2(6),
dely _Addr varchar2(25), salesman _no varchar2(6),
dely_type char(l) DEFAULT 'F',
billed_yn char( l), dely_date date,
order_status varchar2(1 0))
and also enter atleast two values in each column

10. What do you mean by default value?
Answers: Self Assessment

1. Integrity constraints 2. null value
3. composite 4. data type
5. PL/SQL Developer 6. Data control language (DCL)
7. GRANT 8. embedded SQL

9. fetch statements 10. don't return

5.10 Further Readings

Books C.J. Date, Introduction to Database Systems, Pearson Education.
Elmasri Navrate, Fundamentals of Database Systems, Pearson Education.
Martin Gruber, Understanding SQL, BPB Publication, New Delhi
Peter Rob & Carlos Coronel, Database Systems Design, Implementation and
Management, 7th Edition.
Raghurama Krishnan, Johannes Gehrke, Database Management Systems, 3rd Edition,
Tata McGraw Hill.
Silberschatz, Korth, Database System Concepts, 5th Edition, McGraw Hill.
SIlberschatz-Korth-Sudarshan, Database System Concepts, 4th Edition, Tata
McGraw Hill

Vai Occardi, Relational Database: Theory & Practice, BPB Publication, New Delhi

Online links www.en.wikipedia.org
www.webopedia.com
www.web-source.net

LOVELY PROFESSIONAL UNIVERSITY 83