Oracle Certification and Exams – Page 3 – Oracle Database

18/11/2022

Creating a Temporary Table Global Temporary Table- Tables and Constraints

Use the CREATE GLOBAL TEMPORARY TABLE statement to create a table that stores data only provisionally. You can specify that...

18/10/2022

Every row in every table has an address. The address of a row is determined from a combination of the...

18/09/2022

You can use either the DELETE statement or the TRUNCATE statement to remove records from a table. A DELETE statement...

18/08/2022

If you want to remove an object, such as a table, from a user, use the DROP TABLE statement. This...

18/07/2022

Sometimes, a table definition is not documented at the time of creation, maybe from a DBA or developer or directly...

18/06/2022

There are a couple of reasons to rename a column. Sometimes, requirements change, and you may want to modify the...

18/05/2022

There are a couple of reasons for renaming a table:• Make the table conform to standards• Better determine whether the...

18/04/2022

Oracle allows you to enable the logging of DDL statements to a log file. This type of logging is switched...

18/03/2022

When you are creating a table, you have the option of specifying the NOLOGGING clause. The NOLOGGING feature can greatly...

18/02/2022

If you work with large tables, you may want to consider creating your tables as PARALLEL. This instructs Oracle to...