Objectives
This chapter explores DDL and DCL as they pertain to the Fundamentals Exam. The first part of the chapter discusses various database objects and how to use DDL to manage them. We conclude the chapter by describing how to grant and revoke authorities and privileges on database objects.
After reading this chapter you should have an understanding of the following:
The various types of database objects and their uses.
Data types pertinent to these objects and when to use a specific data type.
How to create, modify, and delete database objects using the DDL.
How to control access to database objects using the DCL.
Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
