O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

In this chapter, we've looked at a number of the different supporting objects in an Oracle database. We've seen how different types of indexes can be used to speed performance. We've looked at how sequences can be used to generate primary key values. We've examined the ways that views can simplify our SQL queries. Finally, we have seen how two different types of synonyms can aid our ability to easily name database objects.

Certification objectives covered

  • Categorize the main database objects
  • Review the table structure
  • List the data types that are available for columns
  • Create a simple table
  • Explain how constraints are created at the time of table creation
  • Describe how schema objects work

With the conclusion of this chapter, we've come to the end ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required