Oracle Certification and Exams – Page 2 – Oracle Database

19/09/2023

Reactively Creating Indexes- Tables and Constraints

Rarely do DBAs and developers accurately create the right mix of indexes when first deploying an application. And that is...

19/08/2023

There are usually two different situations in which DBAs and developers decide to create indexes: Proactively Creating Indexes When creating...

18/07/2023

This section contains a few scripts to help you enable constraints that you’ve disabled. Listed next is a script that...

18/06/2023

One nice feature of Oracle is that you can disable and enable constraints without dropping and re-creating them. This means...

18/05/2023

A check constraint works well for lookups when you have a short list of fairly static values, such as a...

18/04/2023

Foreign key constraints are used to ensure that a column value is contained within a defined list of values. Using...

18/03/2023

In addition to creating a primary key constraint, you should create unique constraints on any combinations of columns that should...

18/02/2023

When you implement a database, most tables you create require a primary key constraint to guarantee that every record in...

18/01/2023

Index-organized tables (IOTs) are efficient objects when the table data is typically accessed through querying on the primary key. Use...

18/12/2022

No redo data are generated for changes to blocks of a global temporary table. However, rollback (undo) data is generated...