After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.What must you do to activate the new default value for numeric full redaction?
You must track all transactions that modify certain tables in the SALES schema for at least three years.Automatic undo management is enabled for the database with a retention of one day.Which two must you do to track the transactions? (Choose two.)
You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the tables indexes, to another tablespace.The table does not have a primary key and is used by an OLTP application.Which technique will move the table and indexes while maintaining the highest level of availability to the application?
To implement Automatic Management (AMM), you set the following parameters:When you try to start the database instance with these parameter settings, you receive the following error message:Identify the reason the instance failed to start.
What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database? (Choose two.)
Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)
