The persistent configuration settings for RMAN have default for all parameters.
Identify four RMAN commands that produce a multi-section backup. (Choose four.)
In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.
Minimal disruption to availability is required.
Which three statements are true about this requirement? (Choose three.)
A: You can create and rebuild indexes online. Therefore, you can update base tables at
the same time you are building or rebuilding indexes on that table. You can perform
DML operations while the index build is taking place, but DDL operations are not
allowed. Parallel execution is not supported when creating or rebuilding an index
online.
D: Moving (Rebuilding) Index-Organized Tables
Because index-organized tables are primarily stored in a B-tree index, you can
encounter fragmentation as a consequence of incremental updates. However, you can
use the ALTER TABLE...MOVE statement to rebuild the index and reduce this
fragmentation.
C: If a table can be compressed in the new tablespace, also it can be compressed in the same tablespace.
In your multitenant container database (CDB) that contains pluggable databases (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?
If a program unit does not need to be executed with the escalated privileges of the definer, you should specify that the program unit executes with the privileges of the caller, also known as the invoker. Invoker's rights can mitigate the risk of SQL injection.
Which three operations can be performed as multipartition operations in Oracle Database 12c? (Choose three.)
Multipartition maintenance enables adding, dropping, truncate, merge, split operations on multiple partitions.
A: Merge Multiple Partitions:
The new ''ALTER TABLE ... MERGE PARTITIONS '' help merge multiple partitions or subpartitions with a single statement. When merging multiple partitions, local and global index operations and semantics for inheritance of unspecified physical attributes are the same for merging two partitions.
B: Drop Multiple Partitions:
The new ''ALTER TABLE ... DROP PARTITIONS '' help drop multiple partitions or subpartitions with a single statement.
Example:
view plaincopy to clipboardprint?
SQL> ALTER TABLE Tab_tst1 DROP PARTITIONS
Tab_tst1_PART5, Tab_tst1_PART6, Tab_tst1_PART7;
Table altered
SQL>
Restrictions:
Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):
Which three are prerequisites for successful execution of the command? (Choose three.)
In this case we have run the impdp without performing any conversion if endian format is different then we have to first perform conversion.
