1z0-067 試験問題を無料オンラインアクセス

You plan to migrate a production database to Real Application Clusters (RAC).
You created a test RAC database by cloning the production database and plan to replay a workload, captured from the production database.
Examine these steps:
1) Preprocess the captured workload.
2) Restart the database instance in RESTRICTED mode.
3) Set up Replay Clients.
4) Restore the test database to the point when the capture started on the production database.
5) Remap connections.
Which is the correct sequence of required steps?

• A.1, 4, 5, 3
• B.1, 4, 3, 5
• C.1, 2, 4, 5, 3
• D.2, 1, 5, 3, 4

You create two Resource Manager plans, one for night time workloads, the other for day time.
How would you make the plans switch automatically?

• A.Use scheduler schedules.
• B.Use the mapping rule for the consumer groups.
• C.Use scheduler windows.
• D.Use job classes.
• E.Set the switch_time plan directive for both plans.

Which two statements are true regarding SecureFile lobs?

• A.Fragmentation is minimized by using variable-sized chunks.
• B.The amount of undo retained is user controlled.
• C.They support random reads and writes of encrypted LOB data.
• D.They can be used only for nonpartitioned tables.

Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):
$> impdp <user_name> full=Y network_link=hrdb_test transportable=always transport_datafiles=
'/u01/app/oracle/oradata/hrdb/sales01.dbf',
'/u01/app/oracle/oradata/hrdb/cust01.dbf',
'/u01/app/oracle/oradata/hrdb/emp01.dbf',
version=12 logfile=import.log
Which three are prerequisites for successful execution of the command?

• A.The export dump file must be created before starting the import on the target database.
• B.All the user defined tablespaces must be in read-only mode on the source database.
• C.The impdp operation must be performed by the same user that performed the expdp operation.
• D.The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXP_FULL_DATABASE role.
• E.The source and target databases must be running on the same platform with the same endianness.
• F.The path of data files on the target database must be the same as that on the source database.

Which three statements are true about the SQL*Loader utility?

• A.It can be used to create tables using data that is stored in external files.
• B.It can be used to load data from external files using direct path only.
• C.It can be used to extract and reorganize data from external files, and then load it into a table.
• D.It can be used to load data from multiple external files into multiple tables.
• E.It can be used to generate unique sequential values in specified columns while loading data.