You must unload data from the orders, order_items, and products database tables to four files using the External Tables.
CREATE TABLE orders_ext
(order_id, order_date, product_id, product_name,quantity)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY ext.dir
LOCATION ('ordersl.dmp','orders2.dmp','orders3.dmp','lorders4.dmp')
)
PARALLEL
AS
SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity
FROM orders o,productsp,order_items
WHERE o.orderid = i.order_id and i.product_id = p.product_id;
You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?

• A.DEFAULT DIRECTORY
• B.LOCATION
• C.ORGANIZATION EXTERNAL
• D.PARALLEL
• E.TYPE

Comment: *

Name: *

Email: *

Verification: *

An incremental level 1 backup is taken every week day. A new tablespace is created before the daily backup is performed.
You execute:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE; Which two are true? (Choose two.)

• A.It creates a level 1 incremental backup set containing all the new data files.
• B.It creates a level 1 incremental backup set containing all the previously existing data files.
• C.It creates image copies of all the new data files.
• D.It creates a level 0 backup set containing all the new data files.
• E.It returns an error because there is no existing level 0 backup for the new data files.

Comment: *

Name: *

Email: *

Verification: *

You plan to create a new PDB by copying PDB$SEED.
Which two requirements ensure a successful creation? (Choose two.)

• A.The CDB, which will contain the PDB, must be in READ WRITE mode.
• B.A PDB local administrative user must be specified when creating the PDB.
• C.A PDB local administrative user must be granted the DBA role when creating the PDB.
• D.A default service for the new PDB name must already exist.
• E.The CDB must use Oracle Managed Files.
• F.The CDB must have PDB_FILE_NAME_CONVERT configured before executing the command.

Comment: *

Name: *

Email: *

Verification: *

When is the UNDO_RETENTION parameter value ignored by a transaction?

• A.when Flashback Database is enabled
• B.when the data file of the undo tablespace is autoextensible
• C.when the undo tablespace is of a fixed size and retention guarantee is not enabled
• D.when there are multiple undotablespaces available in a database

Comment: *

Name: *

Email: *

Verification: *

Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required? (Choose two.)

• A.The control file backup is older than the database backup.
• B.All the control files are missing.
• C.All the data files are missing.
• D.The current online redo log file is missing.
• E.A data file belonging to a noncritical tablespace is missing.

Comment: *

Name: *

Email: *

Verification: *